Search results

Customer Info not updating! Hi, I did make these 2 tables related using a common field - customer number. I created a query - using these 2 tables displaying all fields in both tables. I did make form control's record source property as this query. The problem is I have a combo box that...

Hi, I have a main form " createquote". I want some of the fields' record source to be one table - quoteheader and some other fields' record source to be customer table. Right now I make the entire form's record source as quoteheader table. How can I do this? I would appreciate any ideas...

Hi, I have 2 main forms - create quote & revise quote form. When I go to create quote form I have the quotenumber as an autonumber datatype. So Using this form, I have a new autonumber generated everyti me I create a quote, with this, I enter all the other information on the form, and store...

Hi, I have a email button - on clicking of which I would like to open our default email client - MS Outlook with a report attached as a word document Im using DoCmd.SendObject .... Problems Im facing: 1. I want to use the to: email address from the textbox input in the form. How can I do...

Subform Update! Hi This is in relation to my thread! Now I have a combobox which gets updated with RevisionNumbers for the corresponding quotenumber I type in. I have a subform with lineitem information for a given quotenumber & rev number When I pick the quotenumber & revnumber, the...

Thanks! Thanks Fofa!! That worked! I appreciate your help :)

Hi, I have a main form - displaying a quote header info and subform - displaying related line items info. When I open this form, I want to have a quotenumber textbox and a combobox - revision number When I enter a valid quotenumber, the combo box should automatically list all the...

changing autonumber type Thanks again for your input. I had something similar in mind. To create a function that would increment the quote number. Unfortunately, the project that Im working on was already started by someone else, and now to patch that up with so many changes is a pain. Im...

Thanks so much for your response! I have 3 similar forms - Quote , ReviseQuote & LookUpQuote forms which have same set of fields to be displayed. WHen I go to Quote form to create a quote - say I get quotenumber auto generated as 433 When Im done with quoting, go to ReviseQuote form, enter...

Hi, Is there a way to change the datatype of a field now from autonumber to number? When I try changin this, it asks me to remove any relationships the table might be involved in . I did delete all the relationships, but too not able to change the data type from autonumber to number Would...

Hi, I have a main quote form with a quotenumber text box and revision number text box and some other fields from a quote header table. I have a subform with fields from quotelineitem table which displays the different items quoted with this quote number - their unit price, quantity & total...

copy records! Hi, Thanks for your input. Actually im aware of this way of copying records( field by field from form to the actual table by assigning each and every field) Since I have like 20 + fields, Im trying to find an easier way to copy all the fields as a new record - duplicating that...

Hi, Have a couple of questions! I have a mainform - revisequoteform displaying details of a quote (like customer info, revision number etc) Within this mainform - have a revisesubform with all item details for that quote. I can create a quote with any number of items in it. This subform...