Search results

I dont want to get into an arguement, this is for the good of everyone. I learnt user-level security basically through making ALOT of mistakes and I know for a fact that when you delete the system.mdw file, Access will still start, and it just creates a new one, and joins you to it. Ive done...

hey, just a quick thought... Dynamically building a form in this way shouldn't be too difficult. Try looping through a recordset of the query before the subform binds and creating a control and setting its control source for each rst.field Its prob easier to display the form continuously...

I have a similar system where you want the date on the letter to stay the same, that is, the date it was sent. Therefore, this date should be stored in a field in the database, not on the merge doc. For each letter i send, when the merge is complete, i run an update query which updates the...

If you choose n-numbers, for 0<n<=10, are you always selecting combinations of (n-1)-numbers? I havn't given this a hell of a lot of thought but im sure it can be done in vba. The above question may not matter upon further investigation but you never know...

When she 'inadvertantly' ran access security she changed the system.mdw security file to which she was joined. Assuming she didn't adjust any permissions on the db, follow the instructions. Steps to resolve the problem... 1. Find the system.mdw file (which has been changed) 2. Delete it 3...

Try this function, except replace the CurrentDB to the db you want to re-enable the shift key Public Function ap_EnableShift() 'This function will enable the shift key at startup causing 'the Autoexec macro and Startup properties to be bypassed 'if the user holds down the shift key when opening...

Heres some code i use in my error handlers The log_Error(err.number, err.description) is a public sub used to insert the error number, description and also the user into the error log table. It also presents an error msg telling the user to take a screen shot if possible and send to the...

if your table has its primary key as an incremental autonumber of some description then its gonna be the largest number in that field. So... SELECT MAX(primarykeyfield) FROM table But that seems to simple, so i have a feeling your primary key field is something descriptive or cant be used in...

Ive got a couple of things to say 1. Client needs and wants 2. Speed of development With regard to the first, some clients don't want tabbed forms and fancy searching buttons etc and are quite happy looking at 'datasheet' With regard to the second, wizards do a geat job of saving a developer...

Could anyone point me in the direction of some code that checks the nullness of fields in a form? Id like it to work in conjunction with the Required property in the table design. Heres one attempt by myself: Public Function check_FieldNullity(frmName As Form) check_FieldNullity = 0 If...

The antibody usage details need to be in a subform on the form your trying to open. The recordsource of the main form should just be the Antibody list table, that houses the manufacturer names. Have a command button on the popup form that opens the main form and find a record ie applys a...