Search results for query: *

Thanks. I worked off your suggestion and made changes to fit. Worked perfectly. I appreciate the help. New skill learned, too.

I've done quite a bit of work in VBA with custom functions, but they are generally for calling the function within in a query where all the Joins are done. You're suggesting I execute the whole process in VBA? What would the statement be for calling the tables? I have two - ZIPSCOORDS and...

I have a table of zip codes (about 42k of them) and a table of offices (500 or so) we work with. I want to, through a lat/lon calculation, update a field called 'closest office' in the zip code table so that I can identify the closest office for each zip. I have the lat/lon calculation, but I...

I would love to be working with Oracle but am limited to Access for the moment. I understood the 1 gig limitation, but I did not think it was applied to linked tables. I was hoping that if I used the linking, I could work around the size limit. In regard to parsing the files, it was a download...

I have a delimited text file that is approximately 24 million records and occcupies just over 6 gig of space. I'm working on Access 97, so I knew I could not import the file. I attempted to link the file. I created a spec, went through the file import process, and got a table with the proper...

I'm not sure this is the best way to do it - but it works. Create the command button and then copy code such as this into the 'on click' property. Obviously change the names as needed. Sub CmdButton_Click() On Error GoTo Err_CmdButton_Click [SearchFieldName].SetFocus...

I am receiving a data file which has 8-10 discrete pieces of information which I am filing into separate fields. However, I have another field, a 'notes' field into which I'd like to insert literals for each of the data points. i.e. if the customer indicates he/she wants to purchase $250,000...

rcbatlinux - I need to use the advancedfilter in VBA - can you provide the code - I tried using a it but can't get the criteria piece to function correctly.

This isn't the prettiest solution, but if you need to get the report out, how about using the string: =LEFT([ZIP CODE],5) & "-" & RIGHT([ZIP CODE],4) as the control source rather than simply [zip code].

Hi. I have an MS Access database set up to capture and report reply card responses. I have a main file on a shared network drive, and I provide each of the clerks entering data with a local db for entry. They write to a table on the hard drive and at the end of the day, upload to a linked...

Hi. I have an MS Access database set up to capture and report reply card responses. I have a main file on a shared network drive, and I provide each of the clerks entering data with a local db for entry. They write to a table on the hard drive and at the end of the day, upload to a linked...