Search results

I have a logon screen where user select there name and login. ( data is feed from Employee table). From the logon screen to the main screen i use Set Temp Var which takes the EmployeeID of the person logon and display it on the main form.Is there any way i can have that main form pull addition...

pbaldy and arnelgp thank you for your help, and the field was text instead of date/time

pbaldy I did try that at the bottom at the report, but when it came for the date, it does not sort it properly. For example it will list it , 7/5/2007,7/17/1997,7/11/2011. When i would like it to be listed, 7/17/1997,7/5/2007,7/11/2011. thanks for your help.

i would like to have a report that i would like to perform two sorts , to arrange employee names. One i would like it to look at how many request they made (requestmade), and then it will look at their date of hire(DOH) to list their names from first to last. I have a query that delieves all the...

Trevor G, thank you very muchs , works the way i need it to :)

Hello Tevor ,Thanks for responding. My form has combo box for each question for an employee survey. For each question i can select from 1 to 9. I would like if the user selects a range between 1 to 4, for any question an addition box ( i believe a check box will work) will appear asking the...

I have a form that collects a survey where the user selects between 1 to 9. I was wondering if the user selects a certain range, for example between 1 to 4 a yes/no dialog appears. If the user selects a range from 5 to 9 , they get no dialog box. Thank You.

I created a vehicle database that includes a sevice subform to track service history. The main form is bound to the vehicle table that tracks the vehicles we have. (Vehicle_ID). The service history has its own table that stores its history and is link to the vehicles table. I created a report...

JHB and Uncle Gizmo thank you for the information,

I am creating a form that has a bunch of yes/no box for daily task. Is there a way for access to record which user selects yes/no. For example yes/no box1 - user 1 completed this task yes/no box2 - user 2 completed this task and so on So when i look back i can see which user complete...

vbaInet , yes that is what i am trying to do.

vbaInet, i just realize that i am using the code wrong. The code right now is set to run when i am closing a dirty form, i think i need to set it where a command button runs the code, then closes the form.

Thank You for responding, the code i am using on the before_update is If Me.Dirty Then If MsgBox("Submit Contract Form? Clicking No Log You Off", vbYesNo, "JFK-CONTRACTS") = vbNo Then Me.Undo Cancel = True End If End If End Sub this code works perfect when the user...

Is if possible having a me.dirty event in the before_update field,and when you click no, it does not close the current form. If Me.Dirty Then If MsgBox("would you like to continue", vbYesNo, "JFK-CONTRACT FORM") = vbNo Then After the "=vbNo" what can i put for it to just close the msg...

Hello Chris and welcome, i am also a newbie to access

GinaWhipp Thank You very much, i use an After_Update event, works perfect

I am a bit new to vba, I wanted to have my form only save a record after a user enter all data and select a submit button ( which just command the form to close.) I saw i can use this code in the Before_Update event - If Me.Dirty Then If MsgBox("Do you want to Submit this Contract...

Gina Whipp, thank for your reply. i try that but when i run the form,i get "Runtime error 2115: The Macro of function set to the BeforeUpdate or ValidationRule property for this field is preventing MS Access from saving the date in the field." When i debug it highlighters the new code...

Good Day, I have a form that when a user fills out the information and select a submit button. It brings up that record in reports in print preview for them to print. The issue i am having when the user enter the information, the report does not show any data until i refresh it. I tried include...

hello from ny