Recent content by Winterwolf73

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

To answer your questions, 1. There will only be one invoice per project. 2. it all depend. But, more than likely not.

So it would be better if I went from tblCustInfo to tblInvoices(1 - Many) as each customer could have multiple invoices. I could eliminate tblProjects as this would be covered by the invoices table.

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.

To everyone that responded to this post, I want to say thank you. All of you have been of great help. Even though my question was not directly answered, through both the discussion and the information provided I was able to figure it out.

HOLY CRAP guys. When you give information, you GIVE information. I love it. All of the info y'all have given me is great. However, it still does not answer my question. Let me try asking it a different way. If I am understanding this correctly, the Join Type button in the Edit...

now I am even more confused. I am not doing this in a query, but setting up the relationship between tables. Once I drag invoice number, for example, from the customer table to the invoice table the same window pops up.

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

Thank you Moke123. You and Bob are life savers. However, I do have just one question. I noticed you are searching by name. How can we change that to searching by account number. I know that some of the criteria in the query does not return any results. I did that on purpose so that I...

Here is a copy of what I have built so far. I have not made any changes to it though. Also as an FYI, when you open the Customer Management form, tab 3(Update Customer) disregard the cmbbox and button on the tab. I have them disabled. I have been working strictly with the subform. Sorry...

Ok that makes sense. Bob, I checked out the example you provided. You are right. I think I am making this harder than usual. I think this stems from my inexperience and ignorance with the inner workings of access. However, I have added the code you provided and it will not...

here is a completely newbie side question for you. I have noticed that all of the code i am working with is all in the same window in VBA. Is this ok or should the code for each command be in a separate window?

minty. that is what I am trying to keep from happening. lol The only thing this query does is search the Customer Table for the account number and feeds that to the bound subform on the page.

Moke is this to keep the query from opening in data sheet view?

Wow do I feel like an idiot now. I fixed issue number 2 with a simple Me.Refresh call. Now to my remaining issue. How would I go about fixing issue one. When I click the Find Account button and the query runs, it opens in datasheet mode. How would I keep that from happening?