Search results

I have some code that is puzzling me. Dim iCycle as Long Dim iStep as Integer iStep = 10 more code ... If iCycle >= 10 * 60 * 1000 / iStep then 'Do something end if I get a Error 6 overflow on the IF line of code. If iCycle >= 10 * 60 * (1000 / iStep) then I don't understand as 10*60*1000...

I have the following code that in itself works fine. If CurrentProject.AllForms(myForm).IsLoaded = True Then Forms![F-Enquiry].[SF-Actions].Form.Requery ' *** this is the problem line End If BUT in the line marked *** I need to replace the form name F-Enquiry with a variable name [myForm]...

There have been several threads relating to what I have found to be a complex subject. I have 2 reports, called in succession but one needs to go to a standard printer, the other to a PDF file I do not want to chose the printer for each report by having to select a printer via a dialog box; I...

I have a main form that opens another in acDialog mode in order to get two input pieces of data for use in a subsequent Action query. In order to keep these two pieces of data availble rather than closing the "acDialog" form, I have a button to hide it [ me.visible = false ] However, when the...

I use the Docmd.open form with acDialog parameter as I need to interrupt the code for the user to select some information before proceeding. Is there anyway to control the size of the dialog box as currently in a continuous form format, it only shows 3-4 records. The screen is large enough to...

I have what should be a simple problem but cannot get a simply DoLookUp to work. I have spent the last hour running through your searches but jsy can't fix it. I have a table of Unique Part Nos and just want to do a simple user message to prevent any duplicates being entered. I know the table...

I have a for where the field has a Lost Focus event that checks the content of the field. For some reason, when the form opens and the cursor is flashing to await information, after about 20 seconds it triggers the lost focus event. Can't see why the field does not remain with the focus until...

Docmd.ApplyFilter, "Field = 6" finds the record where the data equals 6. BUT. Docmd.ApplyFilter, "Field = intVariable" fails. I have tried all sorts of other syntax. Help please. Thanks Ted

I want to Create a NotePad or WordPad object. I know the VBA code to create a Word Document but as my file must be a .txt file, I need to use NotePad or WordPad. The usual Word Code I have use is: Set WordObj = CreateObject("Word.Application") changing this to...

I would like to use a form button to open a word document in the My Docs folder. Whar VBA code should I use behind the button? Many thanks:rolleyes: