Replies

No I tested it sending to my Outlook express but no image showed up.

Ok got that and now I get the veiw I want but the background image doesn’t send with the email

How can I make word not be used in Outlook as the email editor? and stay that way?

Thanks.

John you are a lifesaver…… this does everything I want….. Is there a way from within the vendors form that I can add a sales rep on the fly just like from the sales rep form I can add a vendor on the fly? And maybe it would be nice that when in the sales rep form that when adding a a new vendor instead of it popping up a box that asks about adding a new vendor it could pop up the vendor form to add the complete details of the new vendor. Also can I change the vendor subform safely to a list instead of combo?

Thank you so much for your help.

“Did you do what I suggested? Use the wizard to make a command button. If it works OK, then transfer the code to a double click event?”

Yeah I tried a cmd button and then copied the code but must be screwing something up since it brings up a query window………. I will change the salesrep subform to tabular instead of datasheet…….. I attached the latest attemp to the last post I made…….

Thanks

OK getting closer…….. Got the buttons to new record thanks……… I like the list box with double click I just cant make it work………Also I made a Sales Rep subform for the vendors form but I can’t enter a new associated sales rep there and is there a way to not show the column header?

Man I tell you when I did this all the time it was easy I guess my brain has forgotten so much in the years I have been away from it.

Yes I looked at the db posted but what I need it to look and act like is what I created…… I know there is a way to just pick a name in the drop down menu and it should open up without the use of a button. And I tried to add the sales rep subform in the vendors form but it wouldn’t work. I hae since that post created the command for the Add New Vendor Button and Add New Sales Rep Button but I can’t open the forms to a blank record they open to the first record.

Still working on everything….. I am sure I need a query to open to a specific record and I have that created also but I need the combo box to pull that query after update.

Thanks

Either my relationships are wrong or I created the forms wrong because I can’t seem to get reps associated with vendors correctly

Main Page…… There is a dropdown list with Rep Name and a button to add rep. If I click the button I would like to go to a blank record to add the rep name and the vendors they are associated with. If I pick a rep name from the dropdown I want the rep details to open up showing the Rep name and all associated vendors in a list. If I click a vendor on the list in the rep details then the Vendors form Details would open up.

Main Page…… There is a dropdown with Vendor Name and a button to add a vendor. If I click the add a vendor button I would like to open up to a blank record to add the vendor, associated rep or reps and products carried and comments if nessecary so the vendor detail form I think will work fine for that just need to add the associated rep so that we don’t have to return to the rep screen to do it. If I pick a vendor from the dropdown list I would like the vendor detail form to open up to that record.

I think I have explained it right. I have created the forms in the uploaded file but not correctly.

Thanks for all the help.

Ok I have created forms like I want them but not funtional completely. I guess what I am looking to do is from the main page pick a Rep and it will open a sales rep detail page Showing the rep and the vendors associated with that rep. Also in the same form I would like to be able to add a new rep and the Vendors that are associated with that rep. Also to be able to pick from a dropdown a vendor and then the vendor details form would open up. Then from the main form I would like to be able to pick a vendor from the drop down and the vendor form open up and would like to be able to add a vendor and associated sales rep from there. On Main form I would like each button to open to a blank record to add the rep or vendor depending on which button is pressed.

Hopefully I explained it enough.

I am attaching the file.

Got it…….. I am attaching the database……. Here is the table structure now and relationships. Oh yeah when veiwing the Sales Rep form not created yet I would like to be able to add vendors on the fly including their information.

OK I have the tables setup exactly as you laid them out I have 1 to many relationships and I checked all 3 boxes in the edit relationships dialog.

Now I need to create a form that I can pull up from a drop down on a Main form that would open a form showing the sales rep and all the vendors for that rep. Then I want to pick a vendor on the form and have it open another form to show the vendor information Name, Phone, Ext, Fax, Alt Contact and the Products they carry and see if they warehouse or store checkbox. Then on that same form below the products I want to see the comments for that vendor sorted by date of last contact.

I think I need one more table a Vendor Comments table so I can have multiple comments appearing with date of contact and comments for that date. I created a VendorComments Table with the fields Vendor_ID(Number and Primary Key) Comments (Memo) and Contact Date(Date) and I created a relationship from the Vendors Table to the VendorsComments table from Vendor_ID to Vendor_ID but it only creates a 1 to 1 relationship……. Is that correct?

How do I get the file small enough to upload? I have nothing really setup except the tables right now but the file size is ove 100k

Thanks everyone for all the help……. I have attached an image.

So I would create a relationship from the Sales_RepID field in the Sales Rep table to the linking table which is a table with 2 fields Sales_RepID(Number) and Vendor_ID(Number) both defined as primary keys. One to many from Sales_RepID to Sales_RepID and then One to Many from Vendor_ID to Vendor_ID in the Vendors table? That didn’t seem to work.

I knew it was something easy thank you very much.

I knew it was something easy thank you very much.

I tried putting that code in for the sub form and also tried it in the customer form for the code for the one filed and I also tried it in the subcintractor form and it does not work for me when I double click nothing happens now. It does open a blank form to enter the new sub but when you close the form you still have to select the new sub from the list. What I am trying to ge is that new sub in that field after the add.

I just noticed the way it is set not for double click just type it in. That works great.
Thanks