Search results

Interesting, yeah, I may look into doing the timer thing.. Thanks for your response!

Do you have any references or anything I can use to get started on this? I searched the web, but there didn't seem to be anything specifically geared to what I need regarding the completion of a file being posted.. Thanks..

Yeah, obviously trying to avoid this if possible..though from the responses it sounds like there isn't anything that can be done from Access VBA.. btw, I did use FileLen - see the end of my code..:D Thanks for your assistance! :)

Hi I have some code that checks if a file exists, its file size, creation date and date modified. The code works fine..however.. I need to import the file it is checking and that file can sometimes take up to 30 minutes to complete its posting. In fact I used the code to check it the other day...

After all that, something that simple! Thanks so much!

Hi I have been importing files for a good while using the import spec feature and the docmd.transfertext command in Access97. However, in all of these, the files I've been importing have all had fields in the first row. This new text file I'm importing doesn't and I don't know if that has...

This part of the code assigns variables to the excel application Dim automApp As Excel.Application Dim xlWksht As Excel.Worksheet Dim xlWkbook As Excel.Workbook then you create a recordset object from Access from your data table or query. A recordset object is a copy of your Access data table...

I have some code that copies results of a query to excel then does some formatting. The formatting code works with the exception of one piece of the code. The piece that doesn't work (bolded below) is supposed to highlight from cells F1 to G1 and then select down to the last populated cell...

Looks like this is now ok. My Access is Novell delivered at work and I messed with some of the install apps they have for MS Office and now it seems to be working..thanks..

Access 2000

When I click on the tables tab and then right click in the white space and select IMPORT, I get the IMPORT dialog box as expected. Then if I select a file to import (I've tried using Excel and Text files of type) and then click the IMPORT button on the dialog box, the dialog box closes and at...

It is. As I explained, the main function works. I can step thru it and see the correct date, and besides, the function assigns correctly the adding of a "Y" or "N" where appropriate. It is the calling of that other one that doesn't..any suggestions? Thanks..

I have 2 functions, one figures out adding 6 months to a given date. The 6 months added is stored in the variable dt - which is a public variable in a module..however, this function returns a value of "Y" or "N". This function works fine.. I would, however, like to see this date in my query...

Never mind, this is a logical error regarding the data, I see what it is doing now..thanks..

The following formula returns -1 for all valid date values that are appended together from a string where the string field has 6 characters in it. However, it will not return 0 for all values that do not meet this criteria. It shows nothing in the field..(when I put my cursor in one of these...

Cool enough, thanks!

Bob, first part very useful, 2nd part, using Access 97 which apparently doesn't have it.. Thanks for the assistance..

If you would have taken the time to look at the time's of my 2nd response and Bob's, you would have seen that they were posted at the same time (minute wise) and perhaps wondered if I was only responding to the first response and therefore didn't know at the time there were two responses as you...

Yes, as I mentioned, could use a select case, but am always looking for built in functions to do the job..

Wanting to take a string month name and turn it into a valid month date format.. for example: fcn("January") = 1 Also, how do I change the value of the month, e.g. 1, back to January? for example, fcn(1) = "January" I know I could do a select case to do this the long way, but thought...