Search results

Can anyone tell me why i would be getting a compile error on the below code, i really cant work it out. Option Compare Database Private Sub GreenFilter_Click() On Error GoTo err_Handler DoCmd.OpenForm "FrmMissingData", acNormal, , , acFormEdit, acWindowNormal DoCmd.Close acForm, "From1"...

The dcount seems a good solution. I did want to expand my code aswell to do a filter and its probably the filter which would produce the zero. So can I apply a filter on the closed query then count the records

Hi all im trying to do what i thought was an easy task, but i keep getting an error. All i want to do is on a button click open a new form and close the form im on, the form i open is for a query that could have no data, so instead of getting the run time error i just want a little message box...

Hi all, id like to make my form look a little better when it comes to missing data, basically once you enter your data you click a button and that saves the record and emails the details off, but if you forget to say imput the person first name you would get a warning message box saying, you...

That was exactly it, all working now.

Hi all, im sure this is something very simple but i cant work out whats wrong. I am very new to access, i have a form that on Load runs the GoToRecord macro and selects new which should mean im ready to enter a record, at the end is a button to email that record to whichever department needs...

it just comes back as Option Compare Database Private Sub Vehicle_Reg_AfterUpdate() End Sub

yes it is sorry i realised it was more of a macro question so i posted in this section, i dont think is was clear as there is only one table structure concerned being the tech_vehicle table, i have a tech_vehicle form which is where all vehicle changes are done, so if on the form you put a reg...

Hi currently i have a table for which i assigned an engineer a vehicle, what i want is a way of not being able to assign a tech a vehicle that is already assigned field names Tech_Vehicle_ID Date_Assigned_To_Tech Date_Returned Vehicle_Reg Assigned_To_Tech so if the date_returned was blank...

is there a way of doing it with the macro builder say once ive input the information there was a before update macro that would search and check and then pop up a the record if the vehicle was with somelse

Thank you for the reply, to be honest i dont know how to do that. ive never used access before. I want to try and do as much of this myself as possible even if its people telling me how to do it then me copying it, as i really am intrested in learning this programme. I know exactly what i...

Hi currently i have a table for which i assigned an engineer a vehicle, what i want is a way of not being able to assign a tech a vehicle that is already assigned field names Tech_Vehicle_ID Date_Assigned_To_Tech Date_Returned Vehicle_Reg Assigned_To_Tech so if the date_returned was blank...