Search results

For the record, Rich gave me the right answer in disguise : :) Dim FileName As String FileName = Screen.ActiveDatasheet!csv_file

Thanks for the suggestions but I would rather try this way to begin with. Is there a way of referring to a record in a table by record number ?

Selects the correct record in the datasheet and message shows the correct number - but returns data from another record.

Sorry, I probably did not make it clear. The ActiveDatasheet is the standard one we get by double clicking the table in the Tables list - not a special form. The code is run from a button in the toolbar. We are importing thousands of records into a table from .csv files with a VBA macro, and...

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...

There are all sorts of courses that give certificates etc - the question is whether they would be accepted by an employer.

We have to bear in mind that an Inputbox always gives text. We have to test if the text can be interpreted as a number, and convert to a number if the situation requires it. We may need to test further to see if the number is in the correct format for our purposes eg. date. Here is some code...

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()...

A variable declared in a subroutine is Private to that routine. In a module - Dim - works at Project level Public - works at Application level The Static keyword operates only within the procedure that contains it.

Works fine thanks. I am "sure" I tried that - not exactly I suppose. Another 10 hours I might have got it.

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...

Have a look at the FileDateTime property.

Fornation. No problem. Just keep going.

Thanks Fornation & Pat Hartman. As PH said, the Sum() one did not work. His NZ() answer did though. Very grateful. This also works :- Total: IIf([Expenditure PTD]=0,[JUL],[JUL]+[Expenditure PTD]) I am looking forward to getting this into Excel where I am on more firm ground <g>. Regards...

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...