Search results

Alright, i completed a previous database that did this: I set the field to be required in the table, then enabled custom error checking so that it would catch it if you tried to move on and i set focus back to the text box so that the user wouldnt have to click on it. ________ Vino 125

OR as Mile's taught me.... :D DoCmd.Close acForm, Me.Name OR DoCmd.Close acForm, "frmName" ________ White widow seeds

We'll normally in a program, ctrl+f starts the search, and then f3 continues looking for that "word" you entered when you started with ctrl+f ________ Toyota h engine history

What about F3 ? ________ DIXI

As long as your forms/reports were all modals And you disabled the control box for each form/report there would be no way to access the database window. (If on start you opened a form) ________ EXTREME VAPORIZER REVIEW

Format(DateAdd("m", 6, [Hepatitis A Taken]), dd mmm yy) I'm not too sure about that one, may have to look it up, bit its along those lines. :D ________ Alaska Dispensary

Form_BeforeUpdate That works for me, whats the difference in using "Call"

Fire him, keep a regular backup, fire the next person that does it. :D j/k. Did you create a MDE? (question in a question) Can VBA be changed in a MDE? ________ Athon

I beleve your talking about is a "bookmark". This post should have been in the general section, this section is for code that already exists, but it is quite simple to direct a page to a bookmark. http://www.yoursite.com/illustration2/#anchor_13804 That would be the hyperlink. ________ Sativa...

Have you tried commenting the on exit, and see how the code runs? What exactly did you put down there, if that is the culprit? ________ MICHIGAN MARIJUANA DISPENSARIES

Are you sure you got your relationships right? :confused: ________ DC MEDICAL MARIJUANA DISPENSARY

I concur! :D ________ Marijuana Vaporizers

Try quotes "3325" ________ Medical marijuana

What Is An LDB File? What Is An LDB File? Whenever you open an Access database, a file with the same name as the database and an extension of LDB will be opened automatically. For example if you open Northwind.mdb in the samples directory of your Access/Office installation, a file called...

Make sure: You have 2 text boxes.... Text field; txtPlateNum , where the plate number will be entered. Text field; txtPlateType , this displays "New Plate" or "Old Plate" should You would put this in the AfterUpdate of txtPlateNum. ________ Box vaporizer

You probably could run an append query that updates null values to "0" :confused: ________ Nash-Healey Specifications

Me!startdate = "#3/1/" & Me.cboYear & "#" Me!enddate = "#3/31/" & Me.cboYear & "#" Me.cboYear would be a combo box that would have a drop down of all the years. ________ SUZUKI GRAND VITARA

Dim strPlateNum As String Dim strPlateCode As String strPlateNum = Right(Left(Me.txtPlateNum, 4), 2) strPlateCode = Left(Me.txtPlateNum, 1) If strPlateNum = "01" Then Select Case strPlateCode Case "0" Me.txtPlateType = "New Plate" Case "5"...

Or you could actually set the form properties to data entry, so if you have multiple places that opens the form AND its only used for data entry; then that would be your best bet. ________ Dodge Ram Van History

Something is probably wrong with your sql statement if it crashes, and to display the results; you would want to set up a listbox that is linked to that query. But post your sql, and we'll take a look at it. ________ BUY VAPIR OXYGEN