Search results

Keith, Just started looking at Access VBA again after a 4 year hiatus and ran into the same problem. Sigh... my hair thanks yours! Thanks also everyone!

AJE, Can you setup a dynamic named range in Access like in Excel? http://www.contextures.com/xlNames01.html =OFFSET($A$1,0,0,COUNTA($A:$A),1) I am doing the opposite here, coming from Access to a pivot table in Excel :)

I think that Call Shell is what you want Dim stAppName As String stAppName = """C:\WINDOWS\explorer.exe"" /e, G:\location on network" Call Shell(stAppName, 1)

I would check out Access help for: Converting DAO Code to ADO And ADO Methods that would be a good place to start

not sure what you are really asking. Are you saying that the database is open, and you want to create a new form for it? Or are you saying that you have already created a form, but it is not working to let you input data into a table?

http://www.access-programmers.co.uk/forums/showthread.php?t=143771 This thread is very good for starters!

Now I am REALLY confounded! Why would you have data come out of a database and back into one? :confused: Seems like it would be better to link the data in the two databases and work from there.

Another point.. why do you bother with Excel updating and importing into Access? Why not just use Access in the first place? Have your users use Access to input information and then away you go with whatever you want to do with the data! :cool:

http://www.access-programmers.co.uk/forums/showthread.php?t=132521&highlight=double+click+row http://www.access-programmers.co.uk/forums/showthread.php?t=109022&highlight=double+click+row These topics should give you a starting point..

Hmm.. somewhere in the code you will need to run the SQL Set rs = db.OpenRecordset(queryNameOrSQL) Should this be ? Set rs = db.OpenRecordset(SQLText) Because I do not see where you actually run the query of your SQLtext. A place to start..

Why does it get entered more than once in the first place? I know that you do not have control over this, but can you affect what you are given so you can make your life easier? Do multiple customs agents send in the information? Why cant they just submit the information one time? If you had...

Must you have duplicate entries? Is there a way to eliminate them? ie never allow them to be entered in the first place? Your users should not be making duplicate entries into any type of system! :eek: If there are records that they need, they can look them up in Access BEFORE adding them to...

this is code for setting up column widths after exporting to Excel ' Set the column widths in Excel Dim WS As Worksheet Dim Ws_Count As Integer Dim I As Integer Dim xlapp As Object Dim xlwkb As Object Set xlapp = CreateObject("Excel.Application")...

Mike, I do something like this but I append to a table in Access every time it is run, then I export that table to Excel. This works fine. I have 3 queries, the last which appends information to a table. The information from that table gets extracted by the qryStats, and goes into the...

Haha! Well that solved getting some information. But, I only got 5 records total, not 5 from each associate. 36 associates * 5 records = 180 total records. Would I have to step through the tblAssociates in a DO LOOP?

I probably just need to put my glasses on, but I cannot figure this out! I am trying to gather 5 of each associates records and put them into another table. The table temp gets randomized. It also has around 40,000 records. There are 36 associates in tblAssociates. strSQL = "SELECT TOP...

First, Could you just use the default search? If that WILL NOT work, then look under the samples in the forum here. There should be plenty of search databases.

First, I would compact and repair the DB. If that didn't work, I try to duplicate this in another form. Create a new form and see if that one has the same problem.

Couldn't you create a report and let the users click a button to see the report with the sums? No coding involved there ( with use of wizards!) :cool:

Mike, Were you able to compact the DB? Will it upload to the forum now? If not send it to me at qdogfball@yahoo.com and I will try to help you out.