Search results

yes, if its placed on a form. reference it from the query =Forms!yourForm!YourControl

Re: Ho to Save password while connecting Database from MS access & how to shedule que You can automatically run any code in Access by calling a function in a macro called 'autoexec' or you can do it from a hidden form opened at startup. The function will essentially consist of docmd.OpenQuery...

Re: Ho to Save password while connecting Database from MS access & how to shedule que Open you query for design, then depending on your version of Access specify that the query is pass-through. On my system it is found on the query menu, a wizard will then guide you through connecting to an...

If the data is entered through a form then you should validate in the before update event for the year and quarter. But, you could create a unique compound key consisting of year and quarter, and let Access trap the duplicate.

Re: Ho to Save password while connecting Database from MS access & how to shedule que 1) Are your tables linked 2) with 'pass-through' queries you can specify what the server is, user and password.

There are two ways to do this. An unbound field may have its control source set to either 1) a domain aggregate/lookup 2) a function that returns a scalar

another problem you will encounter is when an existing key is changed so it is a duplicate of another key. So you need to enhance your code to cater for new records. then when checking duplicates for existing records you will need to exclude the current record. here is an example checking for...

add an autonumber column and set it as the primary key.

Also there are datatypes that Access does not recognise, E.G. linking SQL tables with BigInt datatype can cause problems, but you can get around it by linking to a view/stored procedure that retrieves and converts the fields in question.

there will be a missing reference. Open a code module and select tools, references, it may show those that are missing. I think Date() is in VBA for Access, but I may be wrong.

The criteria should be entered via a form, that way you can 1) validate the criteria 2) being on a form the values can be referred to in a query, a report or any other object so long as the form is open. 3) another reason for doing this, is when you close the report the form with the criteria...

go to tools, options, and somewhere amongst the myrid of options is one for automatcally creating indexes on fields that are integer or fields that have 'code', or 'ID' in the name.

one thing Access may have done is to automatically apply indexes. Don't forget a string of say 10 characters requires 10 characters plus an integer for the length.

are both passwords the same case, if a password has been set as ruby, and you are entering Ruby, then this will fail.

Access comes with a link table manager, found on the tools menu.

there are ways around this using double quotes or the CHR() function.

Users can use combo boxes BUT place them on a form. Maxim. Tables are for storing raw data. Forms are for entering data.

can't see anything. But the way to do this is to create a criteria form for all the users responses. Then alter the query so it refers to the values on the form.

you need to copy both frontend and backend to a seperate development area. Then re-link the tables from the fdevelopment rontend to the development backend.

Why not combine them as all you appear to be doing is getting booking types AWOL and Paid Holiday ((qry2CountOfAllBookedSlots.Booking_Type)=IN("AWOL",Paid Holiday") )