Search results

Have you tried compacting it after clearing out all the records?

Just post an empty copy of it.

Can you post your db so I can have a look?

Is the information updated if you close the forms and open them again?

No problem. :)

These tables are normally hidden, but do exist in all your ms access databases. They are system tables. Take a look at Tools -> Options then 'View' tab. Take the tick out of System Objects.

Do the fields you mention (on your subforms) populate when you enter the details on your subforms? There would be little point having them populate before you enter any details as that would essentially be creating blank records.

I've knocked together a quick example of what you might use. It's not very well written and my naming conventions are non-existent. Unfortunately I haven't got time to tidy it up. Just open up one of the forms and use the command button to swap to the other form and back. The click time and form...

I've not used this feature before but have just tried it out. When I tried it it did use Outlook instead of Outlook Express. I'm guessing it will use whatever your default e-mail programme is? (look in control panel -> internet options -> Programs tab)

You need a key for your test conditions (an autonumber field will do). Then you need a foreign key in your test results. You can then link all your test results to the test conditions. i.e. TblConditions PK Test_Condition 1 Condition1 2 Condition2 TblResults FK Test_Result 1...

I'm using docmd.transferspreadsheet to import data from a spreadsheet into my database. I need to check that the spreadsheet being imported hasn't got an autofilter on it though, before it is imported. Is it possible to do this from access? I know in Excel it is possible to check using vba but I...

Yes. Presumably you currently have a continuous form listing the employees. You need to design another form (single form, not continuous) with all the details you want showing. Then all you need to do is add a command button to the detail section of your form to open your new form showing the...

Just found a potential problem with that though. It also prevents you using backspaces etc. If you adjust the if statement though I guess you can get around it.

I had a look at using a keypress event and it wouldn't have to be too complicated. Something like If (KeyAscii >= 48 And KeyAscii <= 57) Then Else MsgBox "Please enter only numeric characters" DoCmd.CancelEvent End If would probably do the trick.

Try changing the format to General Number.

Looks ok to me. Does it work?

ComboValueField is the name of the field in your table where you store the value chosen in the combobox for each record i.e. the control source of the combobox on your form, not the name of the combobox. If you are still struggling, if you post your database I'll be able to write the query with...

That'll do fine.

What version of windows are you on? I think the later ones have zip (or create compressed file or something similar) on the menu when you right click on a file. If you don't have that option, you need to get a copy of winzip. You can download a trial version at www.winzip.com. Alternatively, if...

You can't attach .mdb files. You'll need to zip it up first.