Recent content by qdogfball

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?