I have 2 tables : Invoice and Cancellation. They have referential integrity but not cascade update or cascade delete. But surprisingly when i delete record...

Dear All I have fileds like Emp no, Name, Grade etc. in my Master table. I also have a transaction table 'TADA' having the same fileds. The form is based...

"Two guys in a truck." One is on the job, the other is riding along with a check list evaluating how the other guy is doing his job. I cannot find a template...

I have two tables of concern; the lookup table lists work codes by year, the master table lists projects with associated work codes. HOWEVER, I have the same...

On a form I have a command button. I want to create a msgbox that lets the user enter a password to go to the next form or just quit if not correct 3 times...

I want to use access to creat a DB for my church. It is necessary to embed a photo as the plan is to print directories of the membership. I recently...

I'm new, I've searched the archives, and I think I'm missing something fairly obvious but I can't find a solution. I have a form that I use to enter data into...

I'm trying to create a report that counts numbers of records. E.g., I have records in 4 categories: A, B, C, D I want a report to look like this: A 4...

Hi - I'm working with Access 97 and I was wondering if anyone knows of a feature in Access that doesn't allow duplicates or finds matches for a record? If so,...

Hi, Wonder if anyone could help with one. I am currently providing support and development for a client who uses an Access adp/ SQL server setup,...

We have an Access canned program that keeps the tables on the server and everything else resident on each local computer. I have updated some reports and when...

I have a field in my main form that is a combo box with "Original" and "Credit Adjustment" as the options. When "Credit Adjustment" (default value is CA) is...

I don't exactly know how I did it, but I designed a form in a database into which I can input my data and at the end of the last form entry another Enter saves...

I have a field on my form "Result" with two choices: Satisfactory and Unsatisfactory If Satisfactory is chosen, the next field "Action Taken" is not required...

I have a database that only has one form. The form opens when the database is opened and the Data Entry property is set to Yes so that each use of...

I want to group like I would on a report, only on a form: Something similar to the below. The dept number and amounts are in a table and then the...

I have a form that has a combo box based on a query of a couple tables. When you select a field from the drop down list the form shows all the data for that...

I created a switchboard using the wizard. However, somewhere along the line the buttons to other switchboards for additional menu do not function. I tried to...

I been trying to set up a form filter to find where is the same as Start_Date (currently being displayed) Filter = " = #" & Start_Date & "#" but it just...

Hello! It is possible to set an icon for an Access database and the same icon for all its forms. But is it possible to set an different icon for each...