how to create text-field that holds more than 255 char.
If I, try to enter more than 255 in the Field Size field.
Displaying this message
"Setting for field size properity is 0 to 255" :confused:
Is it possible to use <enters> in text or varchar fields??
In this way users can easily switch to the next line instead of typing everything all together
Hello,
In a form i have a field and i would like to test the field value character by character.
Ex : if the user typed ABCDE i want to detect the A as soon as the user typed A, etc..
I want to test each value of my field
A
AB
ABC
ABCD
and this before the user quit the field
I tried to to test with keydown event but the field value is null until user goes to the next field. i tried to concate each keycode but it's a little complexe if user press SUPPR, backtab, insert etc...
I want use this to do a search (like in listbox)
Thanks in advance for help.
VINCENT
I am looking to create a catalog database. It is to serve as a finished product warehouse, as well as a product development tool. There are a number of fields, most of which are straight-forward.
One large problem I have is that the product descriptions are roughly 700 characters. Is there a way to have this information entered into Access and stored either in this database or elsewhere?
Any help would be GREATLY appreciated.
I am using the dcount function as the example I display below. The problem is that it returns the correct result (i.e. 59) but the data type is text (59 is on the left side) . I need this to be number.
=DCount("[OrderID]", "Orders", "[ShipRegion] = 'CA'")
I need to bee able to query out all entries that are not like the following format S01-19-01-3. Users are entering incorrect data such as So1-19-o1-3, S0119-01-3, S01-19-01-3. Users are supposed to enter the data with One letter, 3 dashes and 7 numbers. If they enter any other way I need to be able to identify it with out searching through some 4000 records. Please help
View 3 Replies View RelatedI know I have seen post close to this one but not hitting what I need.
I currently have a query that is structured as such...
Service: IIf([Serv] Like '*AA*',' Bas ','') & IIf([serv] Like '*AB*','Exp ','') & IIf([serv] Like '*CA*',' Dig ','') & IIf([serv] Like '*89*',' 384 ','') & IIf([serv] Like '*8H*',' 3M ','') & IIf([serv] Like '*?5*',' 5M ','') & IIf([serv] Like '*=W*',' 10M ','') & IIf([serv] Like '*<1*',' Tele ','')
Works great except for the last IIF stmt has now been changed to look for the code *6 - not wildcard6 -
How can I get Access to realize that I need it to look for
anything to the left or right but it must find the *6
This IIf([serv] Like '**6*',' Tele ','') wont work b/c I have other codes that end in 6.
I am at a loss - any help is appreciated.
I have this test file I am using. I want to figure out how to make a query( using the wizard or other functions are fine) . In this stream it always has Invoice Number: 385152769: I want to query to get 385152769 for every line. Is this possible?
View 2 Replies View RelatedHi,
I've read a bit on exporting Access fields longer than 255 characters (Memo) into Excel, and the general concensus is that it cannot be done.
All I need to do is run a report, right click the report, and select Export from the menu.
However, if it can be done using a query, any assistance or pointing in the right direction will be greatly appreciated.
Thanks..
Chris
I have tried to use a bit of code so return the Last Year and WeekNo in my database, to select some records but�. It currently fails, I think this because it returns the values as text and will then not compare to a numeric field. Is there an easy way to change this code so it returns numbers.
qryCurrentWkYr
Code:
SELECT
Right(yw,2)
AS week,
[Code].....
Hello,
I have an unbound form where the user enters feedback, usually > 255 chars. When they hit the "Submit" button, an append query adds this to a memo field on a table. A memo field should be able to hold 65,000 some characters however everything after 255 turns into a special character, mostly boxes. Any ideas on how to retain the text?
Thanks for any suggestions!
Stone
I have 2 columns that are listed as such:
AssumptionMo AssumptionYr
MAY 2014
JUN 2015
JUL 2015
OCT 2016
I need to create a field called AssumpDate that converts the month into a date field on the 1st day of the month. ex May 2014 needs to read 5/1/2014. When I use the expression AssumpDate: DateValue("1-" & [Assumption_Month] & "-" & Year(Date())) of course the year changes to the current one--2015. How can I I change the expression so that the year is based on the AssumptionYr column?
Hi all
I've posted this in my usual Excel forum without any response so I figure someone here might be able to help. I'm using an SQL query in an Excel VBA macro to extract info from an Access table and dump it into an Excel worksheet, which works fine except for a Memo field, which is truncated to one character length - text fields are fine, just this one Memo field. I'm using the Microsoft DAO 3.6 library. Any ideas?
Cheers
Col
I have a bunch of queries put in 1 macro. Of course, some queries have the same parameter [Enter current monthend] so when I run a macro, there are few popups asking to [Enter current monthend]. It’s annoying for users to put in the same parameter 2 or 3 times for a report. Is there a way to avoid it?
I tried to make [Enter current monthend] as a new_field so the 2nd query could pick up new_field instead of [Enter current monthend] again but that gave me an error b/c the new_field automatically has ‘binary’ datatype instead of ‘date’ datatype. How can I fix this?
Thanks.
Hai all,
i am creating one table that table i am using the unique field of time stamp( Primary key).
but problem is timestamp taking the date, time(hh:mm:ss) only.
its not taking the miliseconds thats why its duplication of date, time
Hi,
my table have a a text field F1 (data ex:25%) and number field F2 . I have a query which contains a new number field based on the above fields i.e F3=F1*F2.My query is not able to retrieve the data.My data is been filled with error#.How i can convert the data types in order to get the multiplication of those two fields.
Thanks in adavance
sam
the standard value for the yes/no datatype = no..I try to set the standard value to yes but I can not be allowed for yes ? how do I set it to yes ? I have open the table, then I could not change to yes.
View 2 Replies View RelatedHi,
I need to create an sql query for an ms access db that will return the data type of a given column.
Can anyone help me? I quite new to sql etc.
thanks in advance!
When I export or do a make table query from Oracle to Access, the new table has some of the datatypes changed. Many of my numberic fields are decimal instead of Long Interger. I then need to go and manually cahnge them back. If I forget or miss one, it crashes another application we use.
Has anyone come up with a solution to automatically go through the table structure and change the datatype from one format to another? This would be a great help.
I am using Oracle 9i and Access 2002.
Thanks for you time
Sherriff
Hi,
When I click this buton I get an error on one of the following lines.. I can't figure out why and how to fix it.
the error I get is
run-time error '3464':
Data type mismatch in criteria expression.
I made the part where the error occurs in bold and italics
'submit for approval
Private Sub Command22_Click()
Dim rs As Object
Dim rs2 As Recordset
Dim db As Database
Dim name As String
Dim x As Integer 'will be used as flag for do while loop
Dim cnt As Integer 'this will contain the number of records in the recordset
'MsgBox (Me.projno)
Set db = CurrentDb
Answer = MsgBox("Are you sure you want to submit this timesheet?", vbYesNo)
'if cancelled
If Answer = vbNo Then
Else
x = 0 'initialize flag
Set rs = Me.Recordset.Clone
rs.MoveLast
cnt = rs.RecordCount
rs.MoveFirst
Do While x < cnt
If rs!statusPM = "pending" Then
MsgBox "This timesheet has already been submitted. You can't submit this again."
x = cnt
End If
If rs!statusPM = "approved" Then
MsgBox "This timesheet has already been approved by your supervisor. You can't submit this again."
x = cnt
Else
MsgBox (rs!projno)
Set rs2 = db.OpenRecordset("SELECT projmanager FROM Projects WHERE projno =" & rs!projno)
Do While Not rs2.EOF
name = rs2!projmanager
MsgBox (name)
rs2.MoveNext
Loop
rs.Edit
rs!statusPM = "pending"
rs!status = "pending"
rs.Update
x = x + 1
'MsgBox (rs!projno)
rs.MoveNext
End If
Loop
'clear variables
Set db = Nothing
Set rs2 = Nothing
End If
End Sub
Thanks in advance,
I'm a having a problem with a Yes/No datatype. Fundamentally, my code looks like this:
strSQL = "SELECT * FROM tblAddresses " & _
" WHERE YPID = " & Me.Parent.IDNUMBER & " AND CurrentAddress = yes"
Set rs = db.OpenRecordset(strSQL)
Now this statement returns 3 records even though only 1 Current Address exists.
false also returns 3 records
true also returns 3 records
no also returns 3 records
-1 also returns 3 records
0 also returns 3 records
1 RETURNS 0 records!!
If I look at the table in Access, I only have 1 CurrentAddress record for my IDNumber.
I have a problem with changing a datatype into a number. The thing is that all the fields are in text and i want to change some of them to a number datatype. If i try to change the field to a number i get a message that come up as This:The setting for the field size property of on or more fields has been changed to a shorter size. If data lost, validation rules may be violated as a result. I try to export it into an excel file and change all the field that i need to be a number and convert them into a number and it work by when i import them back into access they don't change.
View 6 Replies View RelatedDear All,
I have a property database linked to ArcView 3.1. It has a field that links to the ArcView Database called ID which is unique and set to a data type of double.
I have a further form that can go straight to a record if you know it's ID.
This form works fine so long as the ID field is no more than 5 digits. I have a series of polygons that have six figure ID's - the link to arcview works fine using these six fig ID fields however the form that looks for that particular ID can't cope with the six figure numbers...
My problem is although I could change all the ID's of the records in the Database so that the search on ID worked (ie five figure id) they then wouldn't match with the overlay in ArcView and I would not be able to link through using code without first changing and matching all the codes associated with the polygons (time consuming)
I did try changing the datatype of the ID field to long integer but still have the same problem. Strange that the search works for five figure IDs and not six.
Does anyone know whether this is a data type error or is it some simple oversight.? I can probably work out some way of changing all the ID fields to five figures but would prefer to keep the six figures as they are used in some pre-printed material as refs
Thanks in advance
Mark
There is a end_date column record with date/time datatype, how could i query datat that showing the particular is empty.
I try end_date = NULL, no record is showing and end_date = ' ' , datatype mismatch... so which one should i write?
order_id is an autonumber key field form table Orders_table. Is is also selected in the row.source for the form I am using.
ComboOrder_ID is a combo box that looks up the order_id from the table with a SELECT...
... So I think the two should be the same datatype!
When I set the order_id in the combo the event procedure runs I get the following debug error:-
Runtime error '3464':
Datatype mismatch in criteria expression
This is the code for the after event on that combobox:
[code]
Private Sub ComboOrder_ID_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "orders_table.order_id = '" & Me![ComboOrder_ID] & "'"
If rs.NoMatch Then MsgBox "it's the <find> that is broken" Else Me.Bookmark = rs.Bookmark
End Sub
[end code]
Any help is much appreciated
Thx.
Kev.
I am building a database in Access 2007 that needs currently includes images and excel files as embedded OLEs. I am aware this is not ideal, but I can't change my employer's mind.
I've been looking in to the Attachment data type but am having trouble deciding if it will work as a substitute for my purposes. I know a variety of image file types can be displayed inside Access on forms and reports, but I can't find anything about displaying the contents of an excel sheet. I read something about using Active X controls to display .pdf images - is there anything similar for Excel?