Search results

You got it wrong by puting the code into the button event. You must put this code into a standard module. Than, call it from your button event.

Yes, you are right again. With this code "If DCount( "*", "Table", "WhereCondition") = 0 Then". You may get away with it. But I'll never take any chances. I'll also test on my end. The "=0" did not work on my end because I have added a same record "Jeremy" with date and time matching. It skip...

Yes, Paul, you are right. Accord to the code "Dcount(.....) > 0", where the OP's intentions of searching for a empty record. But the IfThen statement reads the "Dcount" as "-1". This is where the confusion lies. The more appropriate code would be: Dim Cnt as Long Cnt = DCount( "*", "Table"...

When you said, “As I switch to "form B" from "form A"”. Do you mean by mouse clicking on the “formB”? So far, the OnActivate Event works on A2K version. In my test, the OnActivate fires up nicely in the event. Unless I misunderstood, please clarify how would you want the data to be transferd...

Because the Dcount output value is always "-1". Meaning, the IfThen will always be True.

Let’s just say this, if the main form has button to open a PopUp message, you’ll have no problem with the OnActivate Event. But if you’ll open another form from the Database window, the OnActivate will not work on the previous form because the form is or may not be in focus. So, generally...

Here's from Help.

I think you’re confused about the IfThen statement. In your code, the IFThen is always True. Thus, the message always appears. First thing you need to do is the controls naming convention. You had renamed the Field/Column your Table, that’s a start. But you have not rename your controls. I...

If the database is over a network and if you’re using the wireless to connect to it. Don’t! Wireless is prone to cause corruption. Here’s a good site about database corruption by Allen Browne. http://allenbrowne.com/ser-47.html And while you still can access to the database, use the Database...

These are two different things. SetWarnings is a "Warning Message Dialog Box" where as Error Message is the "Error-Message Dialog Box". SetWarnings Example. DoCmd.RunSQL “Insert Into Table” will popup a Warning Message Dialog.

A pretty old post, but worth a read thru.

If you're talking about printer hardware issues like memory errors, no paper where the printer keeps running, etc., there's nothing to stop your code or cause your application from running. So far, I have never come across a printer that can communicates with an application before. You might...

Maybe the confusion is the code with the nested IFThenELse? If Me.SFVINFen.ListCount = 0 Then If MsgBox("VIN Does Not Exist! Would You Like To Continue With The New Order?", vbQuestion + vbYesNo, "VIN NOT FOUND!") = vbNo Then Exit Sub Else Dim stDocName As String...

Hi Fen, That's is very confusing. The event "SFVINFen_GotFocus()" code is in the form "frmNewOrdeVINVerify"? You wanted to close this form right? The code I gave is to Minimized this current form "frmNewOrdeVINVerify" then use the current form's (frmNewOrdeVINVerify) Timer Interval and the...

Hi, Closing the current form will not work with this event. Period! There is two ways of doing this. 1. Use Macros - bind it to the lost focus property field. 2. Use the form's timer event and interval. Note: Personally, I do not like this method myself. But it work.

It appears that you have installed the runtime additions into the same folders as the Office Enterprise Addition. Runtime addition will override the files for Access, thus you are now running the runtime version. Developer Extension will not work with the runtime version.

Any chance that she is using a runtime edition of Access? Sometimes you can never know.

Hi, Here's a site for beginners Start Here Hope it will help you along the way.

Hi Walter, This a the usual case of insufficient information to built a database. A common one indeed. Start by asking "What is Document?" and "What is People?" Then, "What does each column in the table represent?" Here's a Link for a start. Try the Student Assessment Model.

We know this already. See the sample in the attached file where the code I have added to AutoFill the Facility Combo box. Contradition here, if you want to AutoFill the Facility combo box, Customers with a Facility will show up the Facility Combo box and Customer without Facilty will not...