Search results

anyone? Im really stuck

Hi there. I am working on a bit of database development and I would like to have a form where I can fill out some textboxes and comboboxes to query my table and return the records that match ALL criteria. I have a found a really similar example at http://allenbrowne.com/ser-62code.html I...

I have found this is a better way to limit the number of responses a user can give and clean up the data. I am currently the only person using this database. (dev stage). I know for a fact that incomplete records are not being saved. As the messages that specify which info is missing work...

I seem to get blank records even when there are no errors in the entry, so I think there must be a different cause to the problem.

Would that clear the form and send the user back to the main page? Thats no good really.

Hi there. I have build a form for data entry. It works just fine, but when I check the table to see what is new there are always lots of blank records interspersed beterrn the correctly filled ones. Im pretty sure that it isnt happening when I click the button on the splash page that sends...

Yes the form closes and sends the user back to the main page.

Gah! I figured it out! 'clear all objects Me.rmENCON.Value = "" Me.rmDate.Value = "" Me.rmName.Value = "" Me.rmInjury.Value = "" Me.rmComments.Value = "" Me.Med_Risk.Value = "" Me.rmMedication.Value = "" Me.rmLocation.Value = "" Me.rmVictimstatus.Value = "" Me.rmType.Value = ""...

Data Entry is already set as "yes".

I am building a new form, Im fairly new to form development. The idea is that there is a main splash page form where the user can hit a button to "add a new record" (code below): Private Sub Command0_Click() On Error GoTo Err_Command0_Click DoCmd.OpenForm "Enter_New_Incident" DoCmd.GoToRecord...