Search results for query: *

AWESOME! I knew I was making this more complicated than it actually was. Looks like I need to go through Northwind again, to get the rust off! Thanks for your assistance once again!

http://www.boywonderdesigns.com/tek/jobs1d.mdb OK check it out now and see if I am on the right track...something is still off...what did I screw up now? LOL thanks for your assistance Remou

here's a link to what I have, might make it easier for you to see what I mean...pull up a record on FORM_Order_Entry then hit the Print Report button and it should pull up the data on the current form to the report format http://www.boywonderdesigns.com/tek/jobs1d.mdb Thanks!

ok, so will I need to actually display the key fields to use for the subreports? I guess I am confused on how to use the form data to limit what is displayed on the report...previously (before I restructured the whole thing) I had the report filtering to the OrderID that matches the form...

Hi, I have a single form built from 2 tables (Order and Contact). Each Order has 3 contacts (deliver, billing, and pickup)...after the record is entered (contacts are selected from listboxes for each of the 3 types) I have a Print button that should bring up a report of what is on the current...

OK, update...got the form working to perfection...thanks for everyone's help! I have a question on the report now..will ask in a separate thread

I guess the question is does your statement you had me put in need to have another parameter to have it go to a new record for entry i also get the feeling I will need an edit button where they can select a person then hit edit to bring that person up to make edits...shouldn't be difficult...

one last question, and I think I am home free... I need the new contact form to open on a new, blank record so they can just enter and close it out... is this just a matter of adding a parameter to the existing statement? I tried adding a DoCmd...acNewRecord on the next line, but that didn't...

AWESOME! Man, I'm moving on now! Thanks for everyone's help so far! Hopefully this will get me on my way. Happy holidays to everyone! JB

this is what's currently on the Event Procedure: stDocName = "FRMContact subform" DoCmd.OpenForm stDocName, , , stLinkCriteria do I need to replace that with your line for acFormAdd? or is your line in addition to the lines I pasted above?

ok PHV, let me make sure I am clear: DoCmd.OpenForm "NewContactForm", , , , acFormAdd, acDialog (the above is what is already under Click event for opening the form to add a new record, right?) DoEvents Me![combo name].Requery Just cut and paste this below the DoCmd line and change it to my...

Hi dogg, yes that part I got, but the trick is that refreshes the current form...it's the underlying form (the main form, not the add-contact form that just popped up) that needs to be refreshed...I assume it can be done from the Event Procedure coding, by just telling it the underlying form...

OK I assume I have to add some coding to the Event Procedure to refresh the table data after adding the new record, right? Any words of wisdom on that? Thanks...I can see it coming together now, thanks for your guidance!

ok, got it..and on the button, I can have it just launch a little mini form for the new contact info entry..they enter the new one, close it and the new records should show up in the list now, right?

http://www.boywonderdesigns.com/tek/jobs1d.mdb when trying to enter a new set of form data, getting an error saying a record doesn't exist (blah blah blah)..what have I screwed up now?? should I not be using subforms on the main form for the 3 contact info sets? sorry for all the NEWBIE type...

ahh! Ok didn't know you could do that

ok may need some help with that...I haven't done any SQL coding before So I don't need to set up any relationships in the Relationships window in Access on my 2 tables?

also, since we now have 3 foreign ID keys, how do I relate Orders to the ContactID? I think I am overthinking this way too much...thanks for helping an old rusty programmer!

ok so thinking ahead using that 2-table approach...how will this effect the form? How will they enter the 3 different sets of contact info? I'm just trying to think it out first before I start the redesign

Ahhh Leslie, I think that was the way I was trying to go with it...I knew I hadn't set something up right though. I think I will try the latter approach you mentioned: WorkOrders WorkOrderID PickUpID (FK - ContactID) DeliverId (FK - ContactID) BillingID (FK - ContactID) Contacts ContactID...