Search results

Thanks RuralGuy, I knew it had to be something simple, just staring at it continuously, I couldn't see it. :D

I'm slightly confused with this question as I've got two continuous forms dealing with separate parts of a database and one works and the other doesn't, so I created a test table, continuous form and entry form which does not work either. I've got a test table with 'Acc_code', 'name' and...

That seems to be an interesting way of pausing the running code for a timed period, but is there no way to halt the execution of a macro until the external batch file has completed its procedures and returned control back to Access?

I'm trying to import a file that's being updated with information from an RS232 data logger. While there is no information updating the file, it's safe to import the file and then empty it which can be done from DOS copy commands, essentially I do the following: Make a snapshot of the existing...

I've got an unbound form which has a field that I need to relate to from a query, I've got no problems relating to specific records, but I've not quite cracked the ability to select all other records if the field is left at 0. I've tried using in the query under the 'table' field (for selecting...

Absolutely fabulous, I tried playing with the crosstabs queries, and reading the access programmers book but not 100% understanding how to use them. Your example is spot on and has resolved the problem. Many many thanks. :D

sorry, PC lag, this message has been posted twice - admin, please delete one of them :(

Hi everyone, I can't get my head around this so I'm looking for some help if possible please, there are two questions, the first is: When in the query, I want the criteria for the date selection to be a question, ie. "[Week Start Date?]" but I want the actual criteria selection to be from the...

Hi everyone, I can't get my head around this so I'm looking for some help if possible please, there are two questions, the first is: When in the query, I want the criteria for the date selection to be a question, ie. "[Week Start Date?]" but I want the actual criteria selection to be from the...

Many thanks all of you, those final solutions have worked perfectly for the solution to my problem. What would I do without the Access Programmers Forum :-)

Although I assume that would work, would the Dcount function not be easier, or does it have to be that complicated to close a form with no records? I've tried in the On Open in the Switchboard VBA code: If DCount("Reference","Notification",>0) Then DoCmd.OpenForm "Notify" Where Reference is a...

The form opens when the database first opens, so there is VBA code in the Switchboard to automatically open the form over the top of the switchboard, but obviously I need it not to open the form if no records from the query are found.

It seems so simple to do, but I've spent ages looking through the forums and haven't found a simple implementation of it. How would you close a form based on a query called 'Retired' if no records are found? I assume it's going to be a bit of VBA code, but I'm still learning VBA. :-(

That works fine, although I would now like to do the following: After Access checks to make sure that the IE application is running and logged on within the protected web page, I need it to activate (appactivate) IE AND Open the hyperlink to the page within the protected area. In short...

I have a database that has links to pages behind a password protected website. If you login to the website and enter your username and password so that the session is authorised the hyperlink in the access database has no problems opening. For some strange reason, I've been experiencing the...

Well I've been working on this problem for many a week now and I've finally pulled the last strand of hair from my head and I'm consulting you guys here, 'cause I just don't know. I've got an access database that links via hyperlink fields to stored pages on a password protected web page. If...

Thanks Travis, I can stop pulling my hair out! I knew it had to be something fairly simple, but I don't go into the programming side very much so I can do simple stuff (? but that was simple!) I guess it's not what you know, but who you know! Happy Halloween . . . .

Hello everyone, hope someone can help. I've got the following code running within my program, supplied gratefully by another member on the forum, I would like to adjust the code slightly, but I don't know how, here's the code: Private Sub Command165_Click() Dim rst As DAO.Recordset Dim stSQL As...

Many thanx Travis, It certainly did work, but I guess u knew it would! I guess I just didn't look at the problem straight, and so much of this code and others within the program kinda scrambles your brain, especially if the solution is obvious! Cheers Tony

Hello everyone, hope someone can help me. I'm using the following code to extract e-mails from my database, compile them into a string and use that in outlook (not spam) the only problem is that I need to exclude entries that are blank. The original bit of code had this in the compile line...