Search results

Like I said, hold down shift when opening the Database. This is a sample DB and so isn't split into FE/BE -all tables, queries, forms etc are in the one file

So you don't force a custom save? All the Exit button does is send an email then close the form, you don't force a save in there anywhere, instead rely on Access to do it for you - not a good idea. I would force a custom save BEFORE the email is sent and include my code and any other...

Shift open the attached Database and open the frmChangeRequests form in design view. Look at the code I use behind the 'Add Attachment' button. Basically, it opens up the browser window to allow the user to navigate to the directory where the file to be attached is currently held. When they...

That should solve it. If not, please also show me the code behind the save button.

Have you also placed the code in your save button's OnClick event?

With my code?

You are missing the "Me." identifiers in front of your controls. You should also use the Len(Nz function to test for null or empty string. Here is the amended code:- Private Sub Form_BeforeUpdate(Cancel As Integer) ' Check mandatory field Summary If Len(Nz(Me.Summary_Cause,"")) = 0 Then...

Something along the lines of:- If Me.Final = "No" Then If Me.CurrentDate > Me.DueDate Then Me.OnTime = "No" Else Me.OnTime = "Yes" End If End If The problem is deciding where to place the code to set the value of the OnTime control. I am assuming that the...

Try this:- http://vbcity.com/forums/p/1506/7841.aspx

See my post (#10) in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?p=923411#post923411 To install CDO, go to Start>Settings>Control Panel>Add or Remove programs. With "Change or Remove Programs" selected, scroll down the list of currently installed programs, highlight...

I had similar difficulties a while back in this thread:- http://www.access-programmers.co.uk/forums/showthread.php?t=178769 I ended up exporting the source query/table used for the crosstab query and using array formulae (Ctrl-Shift-Enter) in Excel to reconstruct the crosstab

Please confirm my understanding of your problem. You have 2 tables:- COA Active stores bank account number, description and status COA Entry stores bank account number (foreign key) and expense details You wish to place a sub form on your main form (which is based on the COA Active table, or a...

http://support.microsoft.com/kb/160502 http://www.fabalou.com/Access/General/appointment_outlook.asp http://www.bigresource.com/Tracker/Track-ms_access-gN35c01A/ I'm sure one of these will give you what you're after, with a little modification of course

No probs, just ask if you need any more help.

Can you zip up your db and upload it here, minus any sensitive data?

Check out the edit note on my last post

Then drop the DoCmd.GoToRecord , , acNewRec EDIT - what happens if you perform the filter first and then go to a new record? i.e. DoCmd.OpenForm "tbljobs main" DoCmd.ApplyFilter "jobs form search, , ," DoCmd.GoToRecord , , acNewRec

As boblarson has already said, if you are opening to a new record then you should not be trying to apply a filter as well. You need to drop either the DoCmd.GoToRecord , , acNewRec or the DoCmd.ApplyFilter "jobs form search, , ," Both are performing different filters which is why you...

Can you not just use the RecordCount property to check how many records there are???

Look at the 2nd post in this thread - http://www.pcreview.co.uk/forums/thread-1700057.php