Search results

Hi, First .. "I have been told I need to convert all my macros to Vb code modules, for error handling." You don't really need to do this. Second .. No you cannot use the Filter by form functionality correctly using Access Runtime. You can however, create an initial search form to find the...

What is the error? Can you please tell me what the error message is.

Do a query as normal that gives you the Main info. Then reference this query in a second query as if it was a table.

It sounds basic, but have you tried holding down the Shift Key when entering into the Database? Failing that, try clicking on Window in the Menu Bar and click on Unhide. If that fails, you might be opening the database with a runtime version of Access or have /runtime in the Command line of...

Before you open the form, are you passing a value into the name1 field. If not, then it will ask for the value when you open the form. If the value is being passed, then check the control name of the field it is being passed too. Is it called Field1? Why are you setting the compl dimension...

Try changing the link on the query to show all records from 1 table and only the matching records from the other. If this doesn't give the info required, you might have to do a query within a query to get the Main information like Company & Date and then link on these for the query.

When you call the form to load after entering the User ID, you need something like : If Me.cboEmployeeLogOn = <Manager UserID> then docmd.openform <Managers Form> else docmd.openform <Employees Form> end if For the second question, you need to set the UserID to be able to be...

Try using single. I had a similar problem for adding up values and there was a discrepancy of either .01 or .02. I changed the table field properties to single and this resolved the issue.

A couple of questions spring to mind. 1. Will any other event be on at the venue at the same time. 2. Do you have the capacity for each venue held within the database. If the answers to these are No and Yes respectively, then you could do a link to that venues capacity. If yes and yes, then...

All error hadling is trapped, No error occurs when using full version on another PC. Can't try on another PC with XP and Runtime, as this is the only PC available. I have compared libraries and other files and these are all OK.

I have checked the screen resolution, Win XP SP2 is installed with latest updates. Our desktop guys reckon it's access so won't look into it. TYPICAL.

I would suggest having JUST the DATA TABLES on the Server. That way, any processing will be done through the client and not going through links to the server. Give it a try and let us know.

Sorry .. No recordsets are in use within the db. Runtime does not allow access into the code.

The procedures are writing to a .tmp file held in your temp directory. When this gets close to 2Gb then the db will think that the disk is full. 2Gb is the current limit for Access 2000, 1Gb for Access 97. If this is the case, try revising your queries as this seems a lot of processing to get...

We use a mix of Win98 & XP builds here and we don't seem to have that much of a problem with our client \ Server databases. What memory is in the W98 pc's? It might be worth while considering a SQL Server box if the data in the database is going to grow to a large amount.

Yes, i have done a compact and repair. Also, this works OK with my full version (on XP) and my copy of runtime (on 98). It just seems to be this machine that we are testing it on.

All the records are saved automatically upon exiting the work form. This does happen if you open the db and then close it immediately.

Combo's Try using one of these examples.

Have you tried getting another copy of the Access 2000 Runtime files for installation??

Upon closing a database using Access 2000 Runtime, I am getting the following error: - Microsoft Access for Windows has encountered a problem and needs to close. This happens just as I am closing the database down and not at any other time. It also only happens on Access Runtime. Can anybody...