Search results

It's not something that can be easily explained, but here goes: Your basic problem seems to be that when you close the "service use" form the underlying form is being requeried/refreshed, therefore sorting alphabetically and moving back to the top. The code that I have given you is to obtain the...

This could be achieved by grabbing the ID of the field you are working on when the page is opened. When you close the page you could then go to the record with that ID in the scrolled form. e.g. 'Get the record number Dim lngrecordnum As Long lngrecordnum = frm.CurrentRecord 'Go to the...

You would need to make the query read values from each combo/text box if they contain data: SELECT [Projekt].* FROM [Projekt] WHERE (((IIf([Forms]![SearchForm]![Sektion] Is Null,([Projekt].[Sektion]) Is Not Null,([Projekt].[Sektion]))) Like "*" & [Forms]![SearchForm]![Sektion] & "*"));

Resolved Thanks, I used the Nz() function when looping through the registry.

The table does accept null values, but I think the query only inserts a record if all the fields have a value.

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

All the macros are doing is calling a Function in a module, which does have error checking.

Right Click (RESOLVED) Thanks, I have sorted the problem now by creating a shortcut menubar and using macros for the commands.

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

It's hard to say without analysing the tables in more detail, but take at look at this page, which describes the relationships and when they should be used: Simply Access . I think basically, unless you have more than 255 fields or the data is being duplicated, then it should stay in one table.

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

Thank you very much, that has resolved the error. It's always something so simple.

I mean have you checked that the lookup queries actually run on their own (maybe a stupid question, but you never know)? Can you upload the database, then I can take a proper look.

I am using Windows XP, office XP and eistream Imaging which is the same as the one that was previously bundled with Windows. I have the checked the links, both databases are the same and they bring up the same errors.

There is most likely a problem in your query, which is making it too difficult for access to run and therefore it cannot create a form based on the query. Have you tested the query?

Upload the database and I'll take a look.

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

Enter the input mask at form level as well and the data will be shown in the correct format.

That shouldn't make any difference. Can you post the database so that I have have a look at it?

Right Click on the control and select properties. Go to the data tab and click in the input mask field. Click on the button to the right of this field and follow the instructions in my previous post.