Recent content by spidermman

Hi I have a form in access which contains a 6 x 4 table and some instructions (text) on loading of products. I would like to create an email based on the template of this form. How do you create tables in emails using VBA in access? DoCmd.SendObject thanks

I have a recordset(“lifting program”) which contains 60 fields of data. Between the fields of 25 to 40, it contains the quantity of products which are being sold to the customer. However, in these fields, it only contains records of those products that are required by the customers. For those...

gemma, have 2 versions of the print, one linked to the specific printer, and one using the default how do u link to the specific printer? For A97, there is no printers object and cannot dim variable as printer. thanks.

I am using Access 97 to print out the form. I would like to have one command button whereby it can specify a canon printer to print the form and another command to use Microsoft office document image writer to save the same form as an image. Private Sub Print_Click() ‘using canon printer to...

I would like to create a 5 by 5 table array as in the above in the email message. How do you write the code to create the gridlines for the 5 by 5 table array?

pbaldy, thanks. it worked.

for each form, there is a checklist whereby the user will tick the checkbox against the procedure that has been completed. Afterwhich, the user will save the form. When i reopen the form, i would assign the check1 in the saved form to the recordset value. However the forms!abc.check1 does...

Private Sub Command13_Click() Dim abc as string abc = Combo10.Value … … … forms!abc.Check1 = rst![name] ‘assign check1 to one recordset value DoCmd.OpenForm abc, acNormal End Sub This command 13 button will open a form according to the combo10.value which the user chooses. I have...

hi, i have a form named "sales order form" in my access database. i would like to have a command button which upon click will create another form of the same template in "sales order form". i tried this: Private Sub Command2_Click() Dim frm As Form Set frm = CreateForm(, "sales...

i have changed to Dim myRecordSet As New ADODB.Recordset but it also couldnt work. i created some new code but it couldnt work also due to an invalid object error. this is my new code: Private Sub Command11_Click() Dim cnobject As ADODB.Connection Dim rsobject As ADODB.Recordset Set...

This is the new code that I created: Private Sub Command132_Click() Dim cnn As ADODB.Connection Set cnn = CurrentProject.Connection Dim myRecordSet As New ADODB.Connection myRecordSet.ActiveConnection = cnn Dim mySQL As String mySQL = "SELECT [lifting program].Shipment_Number...

thanks for all ur help... i will try to work on it but if there are any problems then i will come back to guys again. btw do i need to have a new primary key or can i assign the shipment number as the primary key?

I have attached an image of the form that I would like to send out in an email. In this form, I have a command button (“Email”) which upon click will send out this form in html format. However, the email does not look like the form which I had created. Instead the email shows a table which...

Thanks for ur reply. Is it possible that I have a textbox that requires the user to input the shipment number? When the shipment number is keyed in, I would have another two list box which will show the values of the two products. For example, if 100005 is the shipment number, then one...

For example, in Excel, cells(2,3) refers to range“B2”. However, for Access how do you refer to a field (column 3) and row 2? This is my code for excel: Sub extract_tool() file_name = Range("C1") worksheet_name = Range("C3") shipment_number = Range("C5") Workbooks(file_name).Activate...