Search results

To say I am a newbie would be an understatement. I am still learning the ins and outs of access. I have a DB that I am using to track some things for my fire department. I have a form that I can select the person which then shows their rank. There is a sub form in the form that lists all...

Ok all, I have no idea what I did. But I got the relationships set up. However, now when I add the customer number, I get the following error. Cannot perform cascading operation. It would result in a duplicate key in table. I have attached a copy of the DB for reference.

Ok all. As most of you have already figured out I am pretty new to building a database from scratch. From the advice (which was a bit of a slap in the face but well needed) I have received here, I did a bit more research and have cleaned up what I have built so far. One of the things I found...

I have a form with a sub form. On the main form is an unbound text box where the user can input an account number. When the user clicks the "Find Account" button the following should occur. 1. Runs a query to search the customer table for the result. 2. Display the results on a...

I am creating a form where the user can add new customers to the table. As I was creating the form, I realized there is no was to know what the next available account number will be. I initially tried the "go to last record" macro. Well I quickly learned that is not going to work without the...

I have a form that pulls various data from my Customer Table. This form has three tab pages. Page 1 - Customer Info: is simply a search option to see if a person has any entries. There is an unbound text field that I can enter the persons last name and it will pull all of the entries with...

Ok everyone. I am going to apologize now. I am extremely new to VBA coding. I have gotten to the point of banging my head off a brick wall. I found this bit of code that I think will work to get to my end goal. I have a number of unbound user defined text boxes. Here is what I am trying to...