Search results

With your SendObject, are you sending the subordinate table, or the query? Does the query contain the field you wish to have? These are the first things I would check.

Have you tried format([field], "$0") in your queries?

I've never actually done it, but I know it is possible. To active many queries, I suggest you do some VBA code. Something like: DoCmd.OpenQuery "qryMyQuery", acViewNormal I'm not 100% sure how to give it parameters, but you're a smart person, you'll figure it out. The code you'll need to call...

You probably should seperate your application in a front-end and back-end. The users would each have their own mdb file (which is the front-end). This file would contain the queries, modules, reports, forms and macros. The front-ends would all link to the same mdb file which contains all the...

Because I open it and close it around 20-30 times per day. I don't have the patience to wait 30-40 seconds each time.

MS-Access 2000.

I want to compact the database currently opened with VBA code. I do a lot if import, update and delete in a very amount of time. By comptacting, I hope to reduce the filesize of my DB. In the last line of my VBA function, I added: DBEngine.CompactDatabase "M:\ACCESS\REPORTER.MDB"...

I have the exact same question.. so instead of making a new thread, I'll post it here. Is Make-Table Query available in MS-Access 2000? It doesn't appear in the FILE MENU of my query (or table, I tried both). And... yes, I did click on the double arrows to see all the choices available. If...

If I'm understanding correctly, you want to do character recognition from access of scanned pictures? I don't think you can. Or at least, you won't succeed without thousand of hours of coding. If you could manage to scan this in a somewhat text document (with a third party software for...

KenHigg: Both of them works.. although I would try it with "&" instead. If that doesn't work, post the value of each variable (not just strFinalSQLStatement).

The best thing to debug it, is to use the immediate window (CTL-G) and type ?strSQL. You can then take the output... and try it in a query. This line of code: strSQL = "SELECT [ADD 1], [ADD 2]" & _ "FROM [TEST]" & _ Shoud be: strSQL = "SELECT [ADD 1], [ADD 2]" & _ " FROM [TEST]" & _ Because...

Just to clarify, this error happens 75% of the time (or at least the first time I launch the event). It always stops on the same line.

I have a weird problem. When I click on my button to launch the event, it runs through some of the code. It then stops on the same line, without it being a breakpoint. This error seems to come and go. Any idea what the heck this is?

1. What is the error message? 2. Are you trying to copy the same DB you are using?

You were right, it was the lines in between that caused the problem. Thanks for the link to Microsoft's web site. It was very useful. For people out there who have the same problem, let me cut and paste the working code: Set xlsFile = CreateObject("Excel.Application") Set xlsWR =...

This is great advice! I'll try it and let you know.

You posted 4 times the same question in the last 24 hours. It's not because you have fallen on deaf ears. I don't know how to give the password through VBA. On the other hand, you could delete the link, and relink again and again.

After some analyzing... I believe it has something to do with the processes. It's like it open a process, that doesn't shutdown. Still has no clue how to solve this.

Thanks in advance for any help you can provide me with. As some of you may know (I've posted about this before), I export a lot of queries/table to Excel. I saw in the sample database section, someone posting code about using an Excel object through VBA in MS-Access. Exactly what I need to...

To answer some of your questions... I would seriously think to calculate the seconds. Minute, is just isn't enough. This way, if he hangs up at 12h31:12 but picks up at 12h31:45, you will have the precision needed.