Search results

Thank you Tim, I have used the following code: Dim x, p As Integer Dim trays As Integer x = 0 trays = Forms!workorderdetails!NumberofTrays Forms!workorderdetails!TrayDetails1.SetFocus For x = 0 To trays x = x + 1...

Set Focus Thank you Rich, but if I try and set the focus to that subform with the code:Forms!workorderdetails!TrayDetails1!Total.SetFocus I get an error message box: Out worker database can't move the focus to the control Total any ideas?

Hi, I want to click a button on my main form and for it to create as many records as there are tray numbers. The main form is called WorkOrderDetails and the sub form is TrayDetails1 The code I have tried using is:Dim x As Integer x = 0 For x = 0 To...

Hello, I want to be able to add an item if it's not in my combo list, but if I try this it comes up with a message saying I have to select one from the list :((( is there a way I can just enter something if it's not in the list? Thank you Mike

I am having a hard time with datatypes :( all I want to do is store a subtotal value from a form textbox and store in in my table for history reference. I use the code: Me.subtotal2 = Me.Total Total is the name of the textbox on the form and subtotal2 is a field in my products table set to...

Mail Merge help I can't help you but maybe you can find some good advice and help from this link: http://www.helenfeddema.com/access.htm there are two mail merge examples on her page: ftp://ftp.helenfeddema.com/pub/accarch92.zip and ftp://ftp.helenfeddema.com/pub/accarch43.zip Hope this...

Ok Forms!Customer!Key is Autonumber the rest are just Number Long int. I have a customer file, The key is giving them a unique identifier. From the customer file I generate quotations so I want to link the quotations by a key that will relate to that customer unseen by the user. All the user...

Under Data control source it says "Key" it a autonumber field in my Customer table. the other one is in my quotations table and is a number value same as autonumber Long integer.

Why don't this work? Me.Key = Forms!Customer!Key Key is Number "Long Integer" and Customer!Key is "Autonumber, Long integer" I get an error message saying: "You can't assign a value to this object" Can anyone help me?

I have this code to open a form from a form with the following code: DoCmd.OpenForm "Special", , , "

Thank you Jerid, But the problem is it's not the report that opens but the created report in acrobat reader. It's the PDF distiller it auto opens the file. Thank you for your advice & help But looks like I am still stuck

Yes my friend that line creates the file but it also opens the file after it creates the PDF I don't want that to happen

Can someone help me or know of a command to pause before I send a document. I run a command to create a PDF file with Acrobat distiller but the second part tries to send before the file has been created: DoCmd.OpenReport "QuotationEmail", acNormal, "", "

Thank you Rich, It should be: Me.Markup.Format = "£#,##;0.00" works fine now, I don't really know what I did wrong. But it is working fine now. Thank you for your time. Mike

I have a form that you select a currency and the whole quotation changes for that currency but I want to show the correct currency symbol after I sellect the currency, I have this procedure but I don't think my code is correct because it doe's not work Private Sub SubTotal_AfterUpdate() If...

Thank you Rich, problem now is "Object doesn't support this property or method" ?? I have no idea

Yes thank you, I have checked it several times but it seem to be just number Single formatted to 3 decimals

I have a problem, I want to click a button and the form to write to another form to select currency. but I keep getting the error: "The value you entered isn't valid for this field" I have the code: Forms!Quotation!quotecurrency = Me.GBP and both the fields are the same type: Single...

Anyone know the name of the event that controls the mouse scroll button? I need to apply refresh after change Regards Mike

I have a form where I select a product via a combo box and it returns a field reference label, e.g. prod1, prod2 etc. there are field names from prod1 to prod68 Now I want to write some code that will do a search for any customers that have a tick in the boxes under what product group I select...