Search results

Ops yea my bad - if the code for the opening 2 form was first then that code (that better :p ) thats a better order - thanks for the brain nudge :D

don't exactly know if this is what your looking for but couldn't you use the Private sub After update_click() DoCmd.Close acForm, "Form" 'to close form 1 --then your command to open the second form end sub but if you've got it on a subform - then i'm afraid i don't know HTH Cam :D

What would cause this?? Hi all After writing my DB to a CD i find that i am unable to open (in view mode) one of the forms. (The form in question is the background colour (no cbo or txt boxes)) Before I burned the CD I did the compact and repair - should I have done anything else...

excellent - just where its meant to go Thanks FoFa mousemat sorry if that answer appeared short - wasn't meant to! :o

.visible won't work as this will hide the button, i want to disable it (grey out the text on the button) FoFa - i'll try the on current and see what happens! Tx

Quick question (and probably very simple :D ) on a form how can i disable a button when i move to another record. ie. the button is named btnName the function of it is to execute the command DoCmd.GoToRecord , , acNewRec obviously this opens another record but the button is still enabled...

thanks for the pointers - got it to work so if anybody's looking for a booking database........

Too few parameters?!? Can anyone check this code and tell me where i've gone wrong....please! VBA code is: code:--------------------------------------------------------------------- Private Sub ConfirmBooking_Click() Dim DB As DAO.Database Dim rst As DAO.Recordset Set DB =...

Me.something, the Me is the name of the form that your text box is on. the Me can be deleted and it shouldn't affect your code HTH Cam :D

Cinders/ Boblarson thanks for the reply, I've added a composite key as suggested, however my command DoCmd.GoToRecord , , acNewRec no longer works. and when i try to move to the next file i get the error message saying that i need to change data to prevent duplication. this is exactly what i...

Hi there :D First time posting here so please be gentle! I am creating a booking form for a private flying club. so far i've managed to do everything except 'prevent duplicate bookings' from being stored in booking table. how can i go about preventing bookings from being duplicated (i've...