Search results

I would use this notation Forms!frmGeneralEnquiries!frmEnquirerSubformPrimary4!txtcomments assuming that the container for the subform (on the mainform) has the same name as the form

I assume you mean query. Select the column, right click and enter the number format of your choice.

There are techniques in DAO that are not in ADO and so some code will require re-developing. The ability to a lock a table comes to mind. DAO being specifically taylored to JET is more efficient that ADO for accessing Access dbs.

Events do not fire if the control is updated via VBA, only when a users types something in. So explicitly call the code required to run.

Access dbs cannot be converted to .exes. You can hide the database window, click tools / startup to see all options. You can compile you db to a MDC or other formats with later versions of access. But you stll require the Access runtime.

Alc, Every Which Way but Loose was the movie. It was my 30th Birthday, never been back to the cinema since then. Strange how you suddenly stop doing something you have done for years. Then before you know it 20 years have passed. I went to the Alps in 1991 on an Alpine climbing course with the...

I have never watched Oscars or any other self-serving prize giving ceremony. But then again I've not watched a movie since 6th July 1980.

Create two empty db, Import the tables into one (backend) , import everything else into the other (Frontend). Then LINK the tables from the Backend to the Frontend. Less 5 mins work.

I've seen something like this before and this is a wild guess but the [4-needed] may be interpreted as 4 minus the value in a colum called needed, If the Outer square brackets are stripped off.

You assign a variable to the value in the Control or use the value in an expression, The menthod you are using is T SQL and will not work in Access MyVariable = Forms!Comparison!Run IF Forms!Comparison!Run = something Then .......................... End IF

In Access you can use what is called a 'Pass Through' query. Using this method you can construct an SQL query to be executed on the SQL server using SQL Server Code , Otherwise If you had a linked SQL table you would have to convert the above to Jet SQL thereby losing the functionality of the...

Although it is possible to start an auto number from any value, it does not guarantee to generate consectutive numbers only unique. If this number is to be exposed to the users then the best way forward is to gnerate your own numbers. The question is answered at least once per week on this...

you will receive a security level error the first time you open the db, so goto macros/security and set the level to low.

to refer to an open form from the report use, set a text box recordsource to =Forms!YourForm!YourControlName

You may have a Lookup (combo box ) specified at table level, which is not pointing to the correct records anymore. If so remove it and retain you combo box on the form.

I've seen this style before and it is a right pain, but essentially you can open the form in the on open event of the report. Far, far better to create a form for gathering criteria and open the report from the form.

you can specify any number of 'fixed columns' that always appear in a crosstab. You can enter this in the columns prperty of the xtab.

If I remember rightly (Not done this since 1999) use the report detail on print event to perform your totaling.

Use the crosstab query as the record source for a make table query, See if the Calculation are in the table, if so then export from there.

you require Left Join in your query. Ensure the link is 'Include all records from Your StaffTable and only those records from yourOtherTable where the key is equal'