Search results

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

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

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

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

Hi I have a form with the following code Private Sub Form_BeforeInsert(Cancel As Integer) NUMERO = Nz(DMax("NUMERO", "CAB SOLICITUD")) + 1 End Sub I need the Before Insert event to set another value to another field, the expression of the value is as follows: "SP" & "-" & [LINEA NEGOCIO]...

Hi I have a db to manage order processing My orders are identified with 2 letters (which the user inputs first thing as they insert a record, a 2-digit number and the current year. I would need Access to provide an incremental number that takes into account numbers used only with the same 2...