Search results

Post the complete statement.

Only difference that I can make out that is copy the database to the selected location, and compacts and repairs it aswell.

AfterUpdate on the chkbox should do this. Private Sub Payment_AfterUpdate() Me.Amount_Outstanding = 0 End Sub But I think the =[Total Price] would mess it up somewhere.

I'm pretty sure this feature can be disabled in Acrobat options. Something like "Open PDF after Print".

From memory, so it might be wrong... On the navigation bar on the left hand side of the screen, near the top of it. There is a "<<" control. Click it to show a drop down menu. The option should be in there!

After you make your selection in the combo box on the popup form. Use the AfterUpdate event to close that form and open the report.

Yeaaah I had that too. Look at Namliam hoggin all the rep. Tut tut :D

Yes it can. TimeDiff: [dtmTimeOut] - [dtmTimeIn] Although you might need to tell it to select the first and last values in each respective record.

I guess the first step would be to split the database in Front-End and Back-End. There's a tool that will do this for you (in the options menu).

I don't. It's the End User I have to think like. Alot of them use the scroll wheel to naivgate records and/or PgDown/PgUp and/or the new record symbol (=>*) as a "sign" of saving/completing edit of a record. I have now disabled the creation of new records in frmFinance. The Cycle property is...

You need cascading combo boxes mate. Search for em, lots of threads on this, and even more samples.

Ahhhh, just had a brainwave. Saw a post of John's and it inspired me. I've got it working using this... Private Sub Form_Current() If IsNull(Me.txtSUCharge) Then Me.txtSUCharge = IIf([txtLanguage] = "BSL", 70, 50) End If End Sub If anyone has a better way, please let me know!

I think what you want is cascading combo boxes. Do a search. There's literally hundreds of threads on this topic, and even more samples to learn from.

Yeah I didn't explain myself very well did i? Ok here it goes. tblBookings and tblFinance are linked in relationship manager. frmBookings is directly based off tblBookings. Where as frmFinance is based on qryFinance which pulls together selected fields from both tblBookings & tblFinance. The...

Yeah that's what I thought. I did try putting it in OnCurrent, but then it assumes I am filling in a record, and won't let me move to the next record without me filling in the specified PK. That only happens when I click =>| or =>*. Is this more hassle than it's worth? It's not for me, it's...

:confused: It doesn't work. Does it have anything to do with the fact that whatever is in [Language] isn't inputted by the end user on the frmFinance. It's pulled from tblBookings. The value (language field) is inputted by the end user on the frmBookings. So whenever frmFinance is opened...

Oh god. I feel like a right plonker now. Thanks dude :D

I need my form – frmFinance – to automatically select between two different values depending on what value is in another txt box. However, sometimes this value needs to be manually edited (in very rare cases, say less than 5% of the time). frmFinance is based on a qry; qryFinance. This pulls...

Yeah thats what I thought. Thanks for confirming :)

Mafia (PC), ET:QW (PC), Shadow of the Colossus (PS2), World of Goo (PC), NFS:MW (PC) are pretty much my all time favs. I don't buy bad games period. I always try the demo first, and I know within a couple of levels if I'll like it or not.