Search results for query: *

I tried to post this in the forms section and in the general questions but have not received any feedback to help me. Therefore, I am trying to post in reports section. I have several reports that use a startdate, enddate and a market field from a form. In my report I refer to the form to...

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...

I have a form with one sub-form. This form is set to open on startup. When I compact and repair the database, the sub-form blanks out. Any ideas? Thanks!!!!! Fred

I am sorry to post this again but looking for help - I have queries that use a form with a tab control as the filter - for some reason, I get a message that access can't find the field 'forms' referred to in my expression" The problem is that the button will work several times and then I will...

I am creating a database in access 2000 - infrequently, I am getting the error: Microsoft Access can't find the field 'forms' referred to in your expression I get this error message when I click a button to run a report - The queries do have filters that refer to the selection on the form...

I have a backend datbase and seperate front ends all on a shared drive. When one of the users is entering records, the other users cannot see the records unless they exit out of the form and then go back in. We have recently changed the version of access from 97 to 2000. Does anyone have any...

I have a form with a sub-form - how do I make the background color different for the form that has focus? I realize I probably need to use the got "on got focus" and "on lost focus" but I am having a hard time figuring out the code ? Any help would be greatly appreciated!!! Thanks!! Fred

I have used access 97 for a while but now our company is moving to 2000. With 97 I had setup the database to not allow the users to see the main objects in the database - However, now with 2000, when you open the database, you get one window with the switchboard that I have setup to open but...

I have a report where I want to show the detail but I also want to have a field that only totals the groups that have a specific checkbox (named "complete) selected - I was thinking I would put some code in the onprint event but am lost? Any help would be greatly appreciated!!!! Fred

I have a sub-form - the primary key is the main group number nad effective date - when someone adds a record that already exists, I want to use my own message but I also want to cancel out the record they were adding. I know how to isolate the error, however, how do I cancel the record when...

I have a main form and sub form - the sub form is linked to the main form with two fiels - one is group number, the second is effective date - When a user enters a new record with a group number of a record that is already out there (there can be several records with the same group number) the...

I have a sub-form that holds associated data to the main form. There are about 15 check boxes with erros along with a check box that is to be selected if there are no errors. I put some very basic code in the on click event of the save button - just two if statements that say if the checkbox...

I have an access 2000 database - I just created a form - when I exited the database and then went back in I was unable to open this form - I can open everything else except this form ? Any ideas on why this would happen? thanks!!! Fred

I have a word document that is mail-merged with an excel file - the fields that are from excel are larger than the font in the letter - I have tried to change the font of the fields but when I move to another record, it goes back to being larger. Any help would be greatly appreciated...

I have a database that I have used for over 4 years without problem - I just created a new report and for some reason, when I try to print it, I get garbage and the pages just keep spitting out. I tried to repair and compact, then I deleted the report and re-created ??? The other reports still...

I am getting the following error when I try to compact my database: Record(s) can't be read; no read permission on T:/file name.mdb The database is on a shared drive - whe I copy the database to my own computer, I get the same error? Any help would be greatly appreciated!!!! Thanks!!! Fred

I did find a thread that was archived that advised how to stop the warning messages by clicking Tools - Options - Edit/Find Tab. In the Confirm section, uncheck Action queries. However, this stops them for all - I just want to supress them for one database. I have a database that uses several...

I have a database that is used for approval letters for our company - Every once in a while, I have to update. The database is copied to the users computer and links to a SQL database to pull in general information to populate some of the fields on a form. The user searches for the record they...

I have a database with about 8 users. There are times when someone starts to save a record and does not finish - this locks everyone else from saving. First question is... is there something I can/should be doing to eliminate this - I did not think so. My second question: Is there a way to...

I am tryingto compact an access 97 database - I get the following error: Record(s) can't be read; no read persmission on 'c:\docume\database.mdb' Any ideas? thanks!!! Fred