Search results

Just a thought... Thinking it might be worthwhile to convert the Excel spreadsheet to a CVS file, then create an import spec, and use the transfer text method.

Just a thought... Pat, I've been in cavscout's situation. I've had to deal with importing data with over 100k records or more. The tables become HUGE, and after a time would refuse to delete all the records at once. Ended using an import spec, and just deleting the table. Just my 2/100...

FoFa, Thanks for the guidance. I'll have to tinker with your suggestions and see if I can make them work. Indy was nice today. Clear, blue skys, 82, low humidity. I've been at "The Fort" for over 20 years now. Worked on Post for the Engineers, but when FBH closed, I was RIFed into USAFAC...

Table Design Access 97 Greetings. Apologizing in advance for the lengthy post. Looking for clues on the best method to capture data for a management report. I have to capture and report on several categories pertaining to Performance, Leave and Discipline. I'm currently using Excel, but...

Here is the SQL to put into a query to return random records every time. The Rnd() function uses the EmployeeID minus the figure returned by the Timer() function as the seed, so that every time the DB is opened, the Rnd() function starts with a different seed. And so different XX random records...

db format ?? dcx693, What format is your attachment in? Most people post in Access 97 (which is what I have here at work). Could you repost the db in Access 97? Thanks !!

Raskew (Bob), Thanks again for your reply. I suspect that I botched my explaination of what I was attempting. BTW, I pasted your code into a module, and it worked flawlessly. What I'm after is a bit different. At the primary database window, one can see Tables, Queries, Forms, etc. These...

Thanks, Pat...!! Pat, Thanks for the query. Another question... How do I use the below expression that you provided? Does it somehow fit into the SQL, or somewhere else? TempSet1!DESCRIPTION = Nz(fldLoop.Properties("Description"),"") Thanks again !! Bob

Looks Great....but... Raskew (Bob), Your code looks great, but I have a couple of questions...: 1. How would one implement the code you provided? 2. I'm trying to get the Objects and their Descriptions placed into a new table, called t_Database_Objects. It holds the name of the object...

Sorry for the delay... Sorry for the delay in replying. Your solution worked! Thank you very much! Bob in Indy

Hmmm.. Raskew, Thank you for your reply. I've tried inserting your expression into a query grid, but it's not working. I also tried to insert a minus sign (-) at the far left of the number I need to change to a negative, but it doesn't work either. In the query grid: Detail1: Format("-" &...

Greetings, Searched the forum for a method to convert a Positive Number to a Negative Number based on the data in another field. Could not find anything. I get data in Excel 97 which contains a field called DetailAmount. All of the numbers are positive. Another field called TransactionType...

Work-Access 97 SR1 Home-Access 2000 Greetings, Analyzing Time and Billing. I receive a flat file in Excel every two weeks, which I append to an Access file. A large portion of the analysis is capturing errors between the HourTypeCode and WC5. As of now, I have over 12K records to process...

Do you have to import the data at all? Neil, I suspect that the proponent agency will balk at "linking", but I'll advance the idea. The app runs pretty slow right now...will be much slower linking. Thanks for the suggestion!! Bob in Indy

Fornatian, The Access database indeed resides on a shared drive. FoFa, I've not tried the Make Table query...but I'll give it a whirl. Thanks to both of you. I'll let you know what I come up with. Bob in Indy

Greetings, (Access 97 SR1) I have a finance & acctg database that has three tables in it (Army, DoD, Other). Using macro to; 1. Link to external info. 2. Delete the records in the permanent tables above. 3. Append new records from linked info into the appropriate table above. PROBLEM The...

hammerva, Create a new query based on the table with your data. On the field line of a query column, paste this expression: Date By Month: Format([Discovered On],"mmm yy") Add the field containing the defects. Click the SIGMA button on the query toolbar, select COUNT for your defects, and...

Does it matter ?? Karen, The autonumber field is something Access uses to keep track of records. You really don't need to pay attention to it. But.......If you want to have the numbers in sequence, you can copy a table, and paste ONLY THE STRUCTURE as a new table. Create a query based on...

Dean, I'll presume that you have a field called Country. In the Criteria line of your query, enter this: [Enter Country] This will open a small entry box for the user to input the country of their choice. This will return all countries that equal the name the user input. HTH Bob in Indy

Give them SnapShot Why not just give them SnapShot? It's free, and not that large. If you want to email reports to people regularly, that's how I'd do it. Bob in Indy