Search results

*Bump* Please help? Anyone?

Can no one help?

I've done this but both errors are still occuring.

Neither of those solved the problem. I'm still getting the same error. I removed the Error checking part, which allowed the debugger to start. It highlights the open form command. It looks to me as if it isn't even opening the form which exports the data. I get a run-time error 2494. I set...

OK, what kind of SQL statement? I have no experience with SQL. The original code above specifies strSQL = "select something from somewhere" so I assumed that meant the location of the file. What is this used for? Ah, OK. So how would I get it to open an existing document?

*Bump* Can anyone help?

I know this has been quite a while but my boss pulled me from this project for a while. I've just returned to it and I still can't get this to export. I have a Form on which there are two options to search by (Project Name or Order Number). The form also has 3 options for the order type (Cease...

Those lines were in the code, I just quoted the part that was highlighted by the debugger. But that was the problem, I didn't have the reference set. I now do and that error has gone.

OK, been a while, I know. But I finally got round to trying this out. Every time I run it I get a Compile error: User defined type not defined and it highlights the first row except the Dim expression - xlapp As excel.Application. Any help with this would be appreciated as I am way out of my...

Ah, thanks for that. Good to know.

Excelent, I shall give it a shot and report back later. One other question though, what does the "rs.eof = false" bit specify?

Hi, thanks for that, and sorry for long delay in reply (work's been mad n this got pushed to the bottom of the pile). Your code seems very generic though. I was hoping for more along the lines of a tutorial. Or some personal help. I need to export to specific cells. For example, I need the...

Hi, I'm new to access vba and need to export the results of a query to an excel document. The excel document has certain cells which I have to fill in to place an order. I want to automate this process but don't know where to start. Can someone please help me?

Thanks, interesting to know. I now have one very happy customer. Thanks again.

THANK YOU!!! I didn't even know you could remove the $ signs. You have just helped me no end.

I am completely new to the world of coding excel. I do some basic VBA coding in Access but never in excel. I have a problem where certain excel documents with 1 workbook each are kept in seperate locations with restricted access. I also have a central document with a copy of all the workbooks. I...

That works fine, thank you. Exactly what I was after.

OK, thanks for the tips. I've made those changes you said. I'm expecting 5-600 records in the main table, with only 2 or 3 results back, maybe up to 10 with popular surnames. I used intCount = Me.RecordCount and got Compile error: Method or data member not found. The DCount line works but if...

Hi, I'm new to VBA coding and self-taught on everything I know. I'm trying to build a simple database for tracking accounts ordered through a third party. I have a Form which opens a Query, but when the query returns nothing I want it to display a MsgBox asking if the user wants to search again...