Database Problems

[fredk]

I created a new (simple) database that has only two main tables - tblGroups and tblActivity.

I created a data input form which is linked to tblGroups - there is a sub-form on the form linked to tblactivity and there is a "maingroupnumber" field that links the tables and form/sub-form.

I have one additional form named frmreports which has a tab control so I can section out the types of reports - There are three shared fields (startdate, enddate and market)these fields show on each tab. Additionally, there is a field named "acctcons1" that only appears on tab1

I have been experiencing three problems with this database. They are as follows:

1. as I was creating the buttons to run reports using the wizard, occasionally, the wizard would be blank. I would have to close out and reopen to get the wizard to work

2. the sub-form would appear blank within the main form - this happened a few times when I compacted and repaired and also happened after issue #1 happened

3. occasionally, when I am running a report, I get an error that access can't find the field 'forms' - There was not one specific report nor was there a pattern. It just happened every so often. Also, when I did get this error, I could run a different report and then go back to the button that gave me a problem and it was ok.

I was hoping someone had some advice on what could be goin on?? thanks!!!!!

 

[Ed2020]

I'd start by importing all the database objects into a new MDB file on the off-chance it's a corruption of the database file.

When this as failed (I think it almost certainly will) I'd then reinstall Office as I suspect a dodgy installation.

Ed Metcalfe.

Please do not feed the trolls.....