Search results

Ricky, could you point me in the right direction to check or repair my librery reference problem if that could be causing me the trouble. Thanks for your help. Mel

Thanks for the help I replaced all lines of MsgBox Error$ with what you asked me to do, and now I can compile the form and make a MDE file. Thanks alot for your help. Mel

Could any one point me in the right direction with this problem. When I tried to make an MDE file from my database I got the following message “compile error in hidden module: Form_Order_Entry. When I go to my form in design view and click on the compile icon, the following errom comes back...

I did not want to do it that way because they could enter a plate numer that has never been entered before, so the message would tell them plate number is wrong or not on file. Mel

I have a query named UPDATE INVOICE one of the fields is [PLATE NUMBER] I use the following in the criteria for that field, Like [Enter Plate Number]. When I run the query I am prompted to enter a plate number. I have created a form that is also called UPDATE INVOICE, and use this query as the...

I have a small inventory program that I have been working on with help from some good people at the Access forum. It will give you starting qty and when you use a part it will auto adj your inventory qty. It will also track returns and received parts and make adj to your inventory count, if you...

I have a form named BO Parts, it gets info from a query named "Receive BO Parts". When I open the form it opens to a new record with the cursor blinking in a field named [Pick Tkt Number]this is a text field. What I'm trying to do is when I type in a Pick Tkt Number, if I allready have a record...

where are you putting the validation rule info, when I put your >010001 and <019999 in the table and add that field to a form it works fine. Maybe you can give a little more detail about your problem.

I just opened access to show my tables, forms, etc, and then just clicked on my switch board from my forms tab and dragged it onto my desk top. this worked fine, if the icon is ok with you thats it. Mel

I found the following code in a previous Access Forum question. How to make the value of a field carry over to the same field when you go to a new record and repeat for each new record untill the the user inputs a new value. (Pick Tkt Number is the name of my field). When I try to compile the...

I think this should work for you, If your report is based on a form add a text field to your form and for the control source enter the following IIf([field 1]>500,[field 1]-250,[field 1]/2) field 1 being the name of your field, then add this field to your report it should give you what you...

What you should do is in the query that you are using to run your report just enter your date field + 30 Example [Date] + 30 this is assuming your field is name date if not type in whatever you are using. Then add this field to your report.

Dont know why the 411 is coming up, check to see that the date entered is really a date and not a text entry. Also check that the PC has the correct date. Other then that cant think of anything else. If it a small data base and you want to e-mail it to me to look at its ok. My e-mail is...

Avick, here is how I can get a form to to what you asked for. It probly is the long way to get the job done but it will certainly work. First I added a new field to the table [Paid] and made it a Yes/No type data. On my form I created 2 text boxes and added the [Paid] field, in the control...