Search results

Ok guys I finally got the chance to try out the tips that were given to me and wow it was so easy doing it the way ypma suggested making a query with both tables in it and then using that query to make the form. I then just had to slightly modify my existing queries for my reports and everything...

Hi, Unfortunately I haven't had a chance to go back in and do any testing yet. I just moved house and it's been too busy at work for me to get some quiet time to work on this, but I have every intention of trying it out as soon as I can. I'll be sure to let everyone know how it goes. I'm hoping...

Thanks very much for your reply YPMA I will have a look into this tomorrow or next week when I have a chance and I'll get back to you. It sounds like it might work to me.

Ok if I keep the combo box lookups then I now have to figure out how to get the same information to display in my reports. I thought I could probably do a Dlookup but I keep coming up with an error. This is the code I'm using...

Lol ok rain thanks for the lesson. I appreciate the help but I'm just doing this to help my boss and I'm doing the best I can. No need for the lecture just because I'm not a pro at it or whatever. I will stick with how it is, and try and get this all to work using the primary key. It's just...

What's the PK?

Ok I tried to enter the code and it's coming up with a message saying error "method or data member not found" and it highlights this line: Private Sub Combo281_AfterUpdate() Any thoughts?

Thanks I'll try that code today and see if it works. As for just linking the two tables I need to generate invoices and quotes using this information, as well as final purchasing paperwork if they decide to buy the camper so I really need to store the information on what camper a person...

um thanks but I mean understand the code. My problem is I can't get the code to work. I'm not sure I'm placing it into the SQL box properly.

Not sure what you mean but what I want is for the salesperson to select the VIN of a camper being purchased from the combo box and that will then auto populate the Year, Make, Model, Type and Color fields. I want the auto-populated data to be saved in my table so that it can be used for...

Hi, Me again. Stuck on yet another part of my database. I had it all up and running and this is an update request made by one of my other staff members. I'm trying to get some auto fills going to make things faster for the sales team. However they are auto fills that need to save so that the...

That foreign table stuff is a going over my head. I'm not that advanced in formula knowledge. But I'll see if I can figure it out

If you give me an email I'll send it to you sure. I appreciate the help.

Yes that's the data field names. Unit type will tell whether it's a park model or other type of camper

this is what I have in the control box =getTaxAmount([Out of State Deal],[Sales Price],[Tow Equipment Price],[Trade In Allowance],[Unit Type]) And this is what I have in the "build event" code builder Option Compare Database Function getTaxAmount(OutOfState, SalesPrice, TowEquipmentPrice...

Hmm ok not sure what I'm doing wrong but when I go to print preview or report view etc it comes up with a pop-up box saying enter parameter value for getTaxAmount. Any ideas what I might have done there? Cheers, Lis

Thanks so very much for your help! I will try this when I get a moment today and see how it goes!

Hi Everyone, Since I had help here previously I'm hoping someone will be able to help me with a formula I'm stuck on. I have create a report which will be an invoice to print out. On the report I am trying to get a field to have a correct formula to automatically calculate the sales tax on a...

I just found some more instructions that have helped me a HEAP! I think I've got it finally by golly lol thank god! Thanks so much for the help I think we can consider the case closed.

Ugh ok I am still at square one. I don't understand what I need to put for the Combo.name and what column to select because I don't know what the combo is. I just confused as all hell. Thinking I'm just going to have to give up on the whole idea I just don't get it. I got as far as entering the...