Search results for query: *

Hi: I have a query that builds a table for use in a report and I need to be able to key multiple entries as criteria. These are not always the same number of entries. How do I capture these values for use in this query? I was thinking along the lines of an input box that has custom buttons that...

Thanks for the response, assets. I was scared for a little while.

I figured out what the problem was. Thanks for looking though. Someone had the database open and then just closed the database window, but not Access, then opened the database again on top of that. Thanks.

Hi everyone: I have a major problem. I am trying to open one of my networked databases and am getting an error that says something to the effect of,"....database needs repair, may have been shut down unexpectedly...." When I click "yes" to begin repair, I get a message...

Hello all: Is there a way that I can run a certain query once daily? I know there is an OnTimer event but the maximun amount of time you can select is only an hour. I just want to make sure that something happens once daily. Thanks for your time and help. Daniel

RickSpr: Thank you very much. It was the quotes! I had no idea it would be that simple. Appreciate the help. Daniel

willir: Yes. I have the option explicit required in the options menu. I just decided to re-create the form. The new form is working as it should. I have no idea what happened to the other form. Should I get delete the old form or do you think whatever caused the problem is contained within...

No. It is giving that error message for some other objects that I know I haven't changed. Anything that has code is not working; just on this one form though. The other forms in the database are functioning just fine. I am very frustrated. Thanks for your help.

Hello everyone: I am having major trouble with the code in one of my forms. I am getting an error ("Procedure declaration does not match description of event or procedure having the same name.") when I try to run any of my code. This just started happening seemingly out of the blue...

Hi: I am running some data validation dealing with tolerances. For example: Private Sub txtElongation_BeforeUpdate(Cancel As Integer) Dim MinElong As Double, MaxElong As Double Select Case Me.cboWireSize Case "0.172": MinElong = 10: MaxElong = 40...

Toga: Try this link. It may help you out. I haven't personally done this. I only know that it can be done. http://p2p.wrox.com/archive/access/2003-01/55.asp HTH

That is what I am doing now. I want to automate this process through VBA. That way I won't have to rely on a person to decide what is acceptable and what is not. Thanks.

Yes. That is what I am doing in the macro. I am running a query that is picking out the good records. Thanks.

Hi: I have a database that contains test records. The testers key this information in and those data are written to one table. The records that are "good" are then copied via a macro to another table that only contains "good" data. ("Good" means that the record has...

Toga: There is a program called pdf995 that works pretty well. You can use it for free but their website pops up when you use it if it is not registered. However, if you want to buy it, it is only ~$20. If you have 25 or more users, they say they offer a group license. Just type pdf995 into...

Thanks cghoga. That worked out just fine. I appreciate the help. Daniel Pope

Have you tried outputting the reports into .pdf format? Most people have access to Adobe Acrobat if they don't have .snp. Just a suggestion. Don't know how practical it is for your app. HTH. Daniel Pope

I have a command button that goes to a new record when clicked. However, I have some validation on a text box that ensures that the user enters a certain number. If this condition is not met, a message box is thrown up and the user can't advance until the condition is met. It is on this step...

Hello again: I would like to place a time stamp on each record in a database. How do I make it so that each record has a unique time stamp? The NOW() expression updates in such a way that every time I open the database, the time and date is "NOW". Please help. Thank you very much...

Wow! That was simple. I was thinking way too hard. I'll remember that forever now. Thanks a lot for your fast response. Daniel