Search results

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

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

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

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

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.

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

I would like to put a simple password protection on part of my database. As the database is networked I don't want to use the offical route as it could cause all kinds of problems. Has anyone got some simple code that asks for a password input before opening a form? Thanks in advance for your...

How can you continue code within a module on a new line?

in the code below how can i make "Regards Roly" start on a new line. DoCmd.SendObject , "", "", "mkingscote@stanmar.co.uk", "", "", "Forecast Required", "Please forecast part number " & Forms![stanmarfrm]![part number] & " " & Forms![stanmarfrm]![DESCRIPTION] & " on order " &...