Recent content by mlozano

Hi all I am using Access 2010 and need some help I have a table called "Client" with client data I have a table called "header" with order headers data The "Header" table I have fields for Client data, such as name, address etc. In my Orders form (which is based on the Header table) I need to...

Hi I am using Access 2010 I want to email orders (report)to suppliers via a button on the order form. What I am unable to do is name the PDF export of the report using the order number and the supplier number. Is this at all possible? Thanks

Check the relationship between the tables that are used in the query.

Hi again Thanks for all your help I can't believe Things are actually almost working! I have a problem. The data which are retrieved directly from controls in the current form are displayer OK in the email. However, the data which is taken from tables is wrong, for some reason the code does...

Thanks a lot! i have put it to work and it does open a message window!. Further questions How do I specify the table and field where it has to get the values from? I am totally clueless with VBA syntax... For instance, the email address wouldn't be in the form, it would be in the table...

Hi guys I am using Access 2010 I have a form to register deliveries to customers ui would like to be able to do the following 1.- Have Access open an Outlook message window 2.- Popuilate the To: field with the shipping agency's email address (can be different shipping agencies, in each...

Hi I have a form called frmPO based on a table called tblPO One of the fields in tblPO is linked to the field idAddress in the table tblAddresses The following fields exist in both tblAddresses and tblPO Company Address1 Address2 City ZP State The form contains controls for these fields on...

Oops sorry Dave, I just read about your dog :)

Gemma I think the problem may relate to the paragraph breaks - I worte the text in a txt file and then copied and pasted it into the "Default value" property of the memo field in Table Design view. Is there a way to "write" paragraph braks that will enable me to paste the entire text ? Thanks

Hi In my table "quote" I have a memo field which contains the general terms of sale. Of course this includes a few paragraphs such as: - VAT not included in sale price. - Delivery time: 15 days after order confirmation - Delivery in one point is included in price. - Order cancellations will not...

Hi I have a table with two fields NUMERO: which is a numeric field LINEA: a text field to specify the line of business, such as RE, DA, MO, MF NUMSP: a text field which is the primary key for this table.- I also have a data entry form for this table, where the user first inputs the LINEA data...

Many thanks Paul, it worked perectly!

Hi I have a form and a report, both based on the same query. I have placed a button on the form to open the report to show only the current report, with the following code DoCmd.OpenReport stDocName, acPreview, , "NUMERO = " & Me.NUMERO Now, I want to change the field to filter from NUMERO...

Hi guys I have a little problem with a filtered report. OK I have a table with 3 fields, SERIE is a text field related to another table's primary key NUMBERis a numeric field and NUMSP is a text field and the primary key. I have a data entry form on which a user inputs the SERIE value with...

Thanks guys, question solved and more importantly 2 great pieces of advice towards a more solid app! When does the BeforeUpdate event insert the data in the target field? a) when the user tabs to the next field? or b) when the user changes to a different record? As a newbie in such depths of...