Search results

It is not. Maybe I am setting it up wrong? I created a Macro to run after exit of the first combo box that the user would be selecting from to "RunCommand" "Refresh". As soon as I exit that field however, it says "You must enter a value in the 'WorkOrders.Assignor' field, which is the next...

Gary, that is a good idea. However, I need some of the fields that are farther down on that form to have input in them, and the refresh causes a problem there.

This is exactly what I would like to do, however, my issue would be that I need the person entering the data to be able to see this number for their reference as well. Is there a way to show them this number through a different form or something that could be triggered though the button I have...

I have a form that users fill out for data entry, and I need the form to show the users an ID# for their reference. I have it set up now so that this number is generated on the forms "before insert" command, and then displays for them on the form. However, it is possible that if 2 users are...

Ok, so I got it work now. On the form, I have Before Insert as: Me.[WorkOrder#] = Nz(DMax("[WorkOrder#]", "WorkOrders", "[Year] = " & CLng(DatePart("yyyy", Date))), 0) + 1 So now it will start at 2007-0001, and so on. I just want to make sure that this will reset to 2008-0001 once it gets to...

Ok, I tried that, but anytime I try and launch the form with this, it crashes access.

Hi, I've been searching around a bit on the site trying to find an answer, but I believe I will need someone to hold my hand on this one. I have a table called "WorkOrders". In this table there is a field called "WorkOrder#" which is a 4 digit number that I would like to start at 0001. I...

Well the macro is set, but it doesn't seem to know to check the field still. The condition is: forms![formname]![UP Billing Flag]="UP-02" but even if I select UP-03, it is still opening up the UP-02 form.

Thanks for your help. Sorry, I am pretty new to access and these macros, so I am still having problems. Can you give me the exact Condition I would need to enter if I give you more info? For example. The form I am using is called "WorkOrder". There is a button on this page that I want, when...

Hi, I am looking for a way in Access 2007 to have a button on one of my forms, when it it clicked on, look to check data in one field, and to open another form based on what data is entered. Hope that is clear enough. Please let me know if you need any more information. Thanks a lot!