Search results

Hi, I have 2 tables quoteheader and quotetable. I have few fields whose data needs to be copied/imported from quotetable to quote header. I have quotenumber, quotedate,territory, product & csr field data to be copied to quoteheader table(which has the same fields too) When I try copy and...

Hi all, I have a a quote system DB in access developed which is about 10.5 MB in size. I have a main switchboard with 6 different buttons - taking to different forms. EVerytime I click on a button on the switchboard it takes a very long time before it opens the form. Is this because of the...

Hi all, Can I alter the different fields that I want to be displayed on the report depending on a particular field? Like- Say I have 2 records(1 & 2) and 4 fields - A,B,C & D (columns) Record 1 has field A as green and record 2 has field a as red if field A is green, I want to display only...

Hi all, I have a report that has a header , footer and a detail section The detail section has a subreport. The header and footer of the report pulls the data from a quote header table with quote number, cust info etc. For every quotenumber, there might be mroe than one line items. The...

Hi I want to have a commmand button on a form , which when I click , should open an excel spreadsheet that I already have. Once I do some calculations on the spreadsheet, can I grab those values to textboxes in the form and use it for calculations? Im not sure how to go about with this I...

Hi , I have a report with a lot of text boxes displaying data from table. Problem 1: I have this one line Certs: COM MIL CMS9090 OV% 25 on the report where "Certs:" and "OV%" are both labels and others text boxes. Even though I have the Can shrink of all the text boxes to Yes - its not...

Hi, On my main form, I have a button which opens a report in print preview mode with values. Problem: 1. Is there a way I can go and edit my report? Like remove spaces etc. 2. Is theer a way to print the report of multiple pages as one single page report? Thanks in advance for any input

Hi, In relation to my previous posts, Right now, when I double click a record in my subform, it opens a new form without any values being populated. I tried creating a query to see if that can select the record Im trying to populate in my new form DoCmd.OpenForm "ChangeNomexQuote", , , "...

Hi, Im having a subform which displays a couple of records. When I try double clicking on one record, I want to open a new form with record details - bound so that when I make changes to any field, I automatically update the table. I did write a query and made that the control source of my new...

Hi, My report in access has 2 jpegs in them, but to send these reports( these are quotes) via email, I convert them to rtf. WHen I convert them, both the jppegs do not appear in the word doc created. Why is this? Is there a better way to email access reports in their format? or is there a...

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

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

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

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