Search results

Is this the correct code to access and upload a text file from the desktop to the Inventory table in the NEW Inventory Scanner DB file in the Inventory folder on the J: drive? I keep getting a “this isn’t a valid path” violation. Whatsamatter? DoCmd.TransferText acImportDelim, "Invent Import...

fhs That's exactly what I was looking for. Thank you very much.

How can you change the date format in an Update query from 2/7/2005 to 20050207? Thanx.

I've got a field named Course and all the records are in capital letters, like PERFORMANCE MANAGEMENT. I need to change the records to the format of first letter capitalized, all others in lower case, like Performance Management, to save space. I guess I need a function or some code to pull this...

In a select query, I have a list of values, let's say production amounts, and some of them are the same amount. I need a function that will "rank" the values, that is, identify the largest - 1, then the next largest - 2, and so forth. If there are four values that are the same then each gets the...

In a report, I have a loan amount with multiple facilities being funded by that loan. Each facility shows the full loan amount, let's say $20,000,000. If there are five facilities, then the loan amount is displayed five times. I know how to hide the loan amount from being displayed in the...

I need to develop a way by which data on a formatted Excel spreadsheet can be scanned into an Access application. Now I know I'm asking for a lot of stuff here, but here goes. The Access application has forms that are used to enter and edit data. However, there are some external users who type...

I have a report that will be viewed within the application that needs to be "signed-off" by three authorities who are certifiying to the authenticity of the data. I would appreciate any ideas about how to accomplish this objective.