Hi all
Has anyone got any experience with Access DBs that need to be compliant with the Food & Drug Administration Electronic Records regs (CFR 21 part 11)? and if so do you know of any code or add-ins that can deal with output of all or selected records from a table in either XML or SAS...
Dear Crystalguru
Just reading this thread and noticed the following in your code;
For Each varItem In Lst.ItemsSelected
strSLQWhere = strSQLWhere & "sft_software='" & Lst.Column(0, varItem) & "'OR"
Next varItem
You need a space after the single quote (before OR) and...
You didn't say what units you want for the "0.166"
Don't forget that when the report is printed there is a non-printable region on all printers that varys depending on the manufacturer/model. If the margins you set are inside this, they will be reset to the minimum allowed by the...
You could try creating a Macro command 'RunApp' with the path and file name of the PDF document only (eg c:\mydocs\mydoc.pdf)
Acrobat or Acrobat reader usually automatically associates to pdf extensions and so load Acrobat (or Acrobat Reader) with the requested .pdf file
The Macro would have...
I assume that the 1 to many relationships exist between the 'Customer job data' table and the 'labour costs data' table and also between the 'Customer job data' table and table 'material costs data' table. In this case tyou could get away with 2 sub-reports (1 for Labour costs and 1 for...
You've missed the single quotes around the DatabaseName variable. The line should read;
...applicationname = '" & DatabaseName & "' and ...
Cheers
Andy
Thanks Michael but I'd need to to get the User's logon ID before calling the Access app using the command line args approach. The other 'complication' is that the Users' are forced to change their logon password every so many days and they expect the Access DB logon password to be...
I wouldn't recommend mixing client front ends at all. A lot depends on how the 'front' end has been designed. If the Acc2000 don't convert then they won't be able to make changes to the front end but that might be ok. The other thing is that you don't mention a workgroup file being used -...
Assuming your using a single MDB file for data tables/forms/queries etc, both the MDB and the workroup MDW file would sit on the network share.
You then need a shortcut on the users machine with something like the following properties;
Please note these should be entered as a single line...
Hi all
Does anyone know how, or even if its possible, to prevent the logon window of a secured database? Up to now all DBs I've developed use the typical FE/BE split DBs with a custom workgroup MDW to determine the User's privileges. The DBs are used on a NT/Win2K network and all Users need...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.