Search results

Im not totally sure if queries would be the same but I would assume so. What i do when limiting fields in reports is when opening it you present your information. DoCmd.OpenReport [form name here], acViewReport, , [WHERE stipulation here] in the WHERE stipulation you would put something...

Ok so my database contains a duplicate record check. My boss wants me to have the prompt box that comes up if there is, take the user to the duplicate record to modify instead of what it currently does which is asks if they want to save a new record. Can someone help me with this general line...

How about a database that has a scanner for every item in your house. This database has 2 functions in it as well. Store and get. So when you go out and buy something new... it stores it in a hugeass room behind you. and when you say get item.. it knows exactly what to get you. This include...

Ah! gotcha. FormName was actually returning the current Form's Name not the name in the box named FormName. I renamed the field in all of the related tables and what not and it appears to be working. :-) Thanks for the suggestion

So i've created the checker to make sure that the user entered a name that matches with a form. The problem is that when i use the Dcount function no matter what the user enters it is considered false (0). There is a table with all of the form names in it and what Dcount is supposed to do is...

So perhaps I should put the code on the before update and then instead of doing this code i could use a Dcount function to cross check if it is in the other table?

I'm doing this on a button. What this is is a separate form from menu. The user clicks the menu button and it brings up this form which contains a drop down menu of items as well as 2 buttons. Go and Cancel. The go button executes this code and the cancel executes the DoCmd.Close code...

(The only reason i need this is im getting errors when they try to open a form that isn't available) Not quite sure why its happening but regardless of what i enter it is now executing case else then going on with the code :-(. So even on the drop down menu items i'm getting errors... this is...

Ah its backwards. I want those words to allow it to go through and if anything else is put in for it to give the error message. That was my original problem is finding a not equal to operator... even searching on the web i couldnt find anyhting like that

I am actually getting a syntax error by not having it equal to something. it keeps telling me that it is getting a compile error expected list separator or ). Then if i put a ) in it expects me to put an = (expression) Any suggestions?

Hey I'm writing this prompt box and I want to have it check to see if there is anything entered in the drop down menu except what is supposed to be there. If so I would like for it to do a MsgBox saying error please put something in ... yadda yadda. My problem is every thing that i have tried...

I have created a custom menu bar that checks for duplicates via before update. This menubar attempts to bypass it however when i close the form and try to open another it keeps giving me the error you cannot modify a new report while another is already being processed. here is my code...

Thanks! That was exactly what i needed it all works perfect now :)

Ok so I have the basic outline for how to check for duplicates but my problem now is when im comparing two different text fields that have text/numbers EX: Enter the week/month (drop down menu with Aug/01, Aug/02, Aug/03) ect. I have my code to check the Emp_ID with the table and to...

Ok so I'm in a function on a beforeUpdate event and I have it set so that it cancels the event in case of duplicates. The problem im having is that if they navigate away from the page via that button it will continue to leave the form. How do i cancel that event as well ONLY if there is a...

Actually that problem i fixed. I didnt realise that i still had a small piece of code in the beforeInsert event. So we're all good :)

So it appears as though my code still isnt working for this duplicate check. What I am getting is "Runtime error 2467: The expression you entered refers to an object that is closed or does not exist." My table is called tblEmployeeDaily with fields... DailyDate (date) Emp_ID (number) and 5...

I actually just set the settings to modal on and got rid of the close box and menubar

I had never thought of that but thats an ingenious idea. lol off to make a form and have it do a do open command :-p

Ok quick question. I have looked up on the internet and found nothing about it but is there a way in a prompt box using VBA code to set a drop down menu instead of a string field input?