Search results
-
B
Get Selected Record In Activedatasheet
Get Selected Record In Activedatasheet [solved] I am trying to get a value from an ActiveDatasheet. The following code returns the correct record number but the data is from record 1 (or another record in the middle of the table when using other dbOpen.. arguments. Any help appreciated. Dim...- brianb
- Thread
- Replies: 6
- Forum: Modules & VBA
-
B
Format field numbers after make table
I am running a Make Table query which includes a UDF to convert text to numbers (removing commas for thousands and brackets for negatives). After it has run I can manually change the number column formats in the table to "Standard". Can I do this in code ? I have tried putting Format()...- brianb
- Thread
- Replies: 0
- Forum: Modules & VBA
-
B
IsError/IsNumber not working in query
Access 97 I am importing a text file containing lots of garbage. To remove this garbage I am writing a make table query that checks Field5 (which is a number as text) via a calculated field. If it produces an error then discard the record, keeping the ones that convert correctly to numbers. The... -
B
Problem with adding 2 field contents together in a query.
Hi All I am having great problems with a Query in Microsoft Access 97 which combines 2 tables where I am trying to create a calculated field to add the contents of 2 fields together (one from each table). I keep getting a blank field in data view. I have checked that the fields are Numeric...