Search results

Thanks for your help, I will give it a go.

:eek: Please can somebody help me I need the output from this code to be output to file on the C:, what addtional code is requried to do this as part of the program. Thanks for your help. Const RIGHT_DS_DELETE = &H10000 Const RIGHT_DS_READ = &H20000 Const RIGHT_DS_CHANGE = &H40000 Const...

Please help, the attached code works fine in Windows XP but twhen run on a Windows 2000 pc it fails on the create object, any ideas? Function GetXmlFilename() Dim objDialog GetXmlFilename = "" Set objDialog = CreateObject("UserAccounts.CommonDialog") objDialog.Filter = "XML Files|*.xml|All...

Please help, the attached code works fine in Windows XP but twhen run on a Windows 2000 pc it fails on the create object, any ideas? Function GetXmlFilename() Dim objDialog GetXmlFilename = "" Set objDialog = CreateObject("UserAccounts.CommonDialog") objDialog.Filter = "XML...

I am trying to add a button into a word document that will increase a specific text box counter by 1 each time it is clicked. Anybody got simple code or an example document please? Thanks

Please can someone help me, I am trying to create a button in an exisiting word ducument that will increase the document number by 1 each time. Nice easy one for the New Year!

HELP me please. I have a field named <> as part of an output from a crosstab query. The field needs to be there in order for the report to output correctly but once the data is written to a new table I would like to then delete that field in its entirety form the new table. Can anybody help...

Rounding up Thanks everyone for you help I'll test it out.;) ;)

I have the following expression in a query. This gets the order due date takes away todays date then goes through a series of calculations to work out the period in terms of a number of months (Assuming they are all 4 weeks, wrong I know) ((((([Blanket_One]![Due Date]-Date())/7))*5)/20) My...

Help for hiding password in input box To GHUDSON. I think you answer is very good if Iwanted to hide the shift key but how do Iuse this to hide the key strokes in a input box??????:rolleyes:

Can anyone help to tell me what needs to be entered in this code to enable xxxxx to appear into the enter password box so people cannot view what there typing in. Private Sub New_Order_Click() Dim strInput As String Dim strMsg As String Beep strMsg = "Please enter your...

Thanks for your help I will give it a go.

The combo box is built of a select query which in turn references a table with no null fields. (Except the additional record add at the bottom of all tables)

I have a combo box on a form, this combo box by the use of a select query shows all the relevant values in the drop down box from a table:mad. My major problem appears to be that records that are selected in the combo box by way of the slect query seem to be disappearing from the table or part...

Bob. I said it was easy if you know how, excellent works a treat thanks for the help. Judo:) :)

DoCmd.SendObject , "", "", Me![Text369] ???? Me.[Text371], "", "etc ......... I am now using the above code to send an email using text boxes on the form populated with the relevant recipients email addresses. The problem I have got is I don't know how to separate the code for each email...

Please see the attached code, won't work when going from 2003 - 2004. Previous code examples have been implemented but make no difference. Please advise, but not by zip file as we can't open them due to security settings.

Thanks Thanks for you help. I live in hope of seeing a bright light at the end of the tunnel.

Printing Problems The code you attached doesn't cover the function we require, sorry. Any other ideas I need it to go into print setup to select printers/pages as it does when you print a document in Word or Excel. Any other ideas??

Dim stDocName As String stDocName = "SupplierTbl03rpt" DoCmd.OpenReport stDocName, acViewPreview, "", True In a runtime version of a database I have the above code linked to a button on a form. Is it possible by altering or replacing the above code to make the system go into print...