Search results

I am trying to run an insert query using the following code: DoCmd.RunSQL "INSERT INTO Software ( PCID, Name, Version ) VALUES ( '" & Me.txtPCID & "', '" & CStr(lngSoftware) & "', '" & CStr(lngVersion) & "');" The program loops through the registry extracting software information and runs the...

Right Click Menu (RESLOVED) Does anyone know how to create a right-click menu in access 2002. In VB you can trap the right click like this: Private Sub lstdocs_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) If Button = vbRightButton Then 'Code for Menu End If Any...

Does anyone have examples of code to use the Adobe Acrobat Control? i.e. Scanning, Printing, Saving, browsing etc. Thanks

I am trying to use an access (2002) database with Imaging software to scan. I have the Kodak Image Scan Control on the form and I am trying to reference the select scanner property using 'Me![ctlScan].ShowSelectScanner' (where ctlscan is the name of the control). This brings up the error 'Object...

I have a listbox on my form which shows a list of filenames that have been added from another listbox. The filenames can be quite long and contain commas in them. When the filenames are added, they split onto separate lines because of the commas. Is there a way around this?

I would like the following statement to take an entered value unless it is null. If there is no value entered, I would like to use the * operator to show everything from that field. IIf([Forms]![SearchForm]![txtinvestment] Is Null,Like "*",[Forms]![SearchForm]![txtinvestment]) Why does this...

I am using the keypress event of a textbox to run some code instead of having to click a button. The problem I am getting is that when the enter key is pressed, the control simply moves to another text box. I believe that this has something to do with the Enter key behaviour event, but I have...

Is there any way to check the version number of a file from access? I am currently deploying Office XP Service Pack 2 across the network and need to check whether the updates have worked or not. The easiest way to do this is to check the version number of the excel.exe file. Doing this...

I have used the Microsoft Create a Stopwatch Form in Access 2002 article: Link to Article I have used the stopwatch as part of a timesheet system to bill time spent on user Support projects. The Text Box is bound to a field, so that when the clock is stopped, the value is entered into the...

I have several List Boxes on my Form, which take their value from Count Queries. Each list box shows the number of occurances of a particular name in the main table. The problem comes when I try to add the values together from the list boxes, they are all null although they do show the correct...