Help
in [Access]
|
Filter on a date working on one PC not not another Access 2003 SP3 I have a form with a couple of date/time fields On one PC I can do a filter by form and enter *17/03/2010* and the filter will display records where the date is 17/03/2010 (regardles of the time part) which is what I want. However, on two other PCs if I try and filter on the same textbox with... 31 May 2010 05:25
trying to put 2 lines into 1 I have a query that has Var1 VAR2 VAR3 VAR4 in the output each row is based on var4 having a 6 or a 12 and they variables are all there. But in a std report they would have something like bob 1 2 3 6mo bob 2 3 4 12mo I need to get bob 1 2 3 6mo 2 3 4 12... 26 May 2010 18:02
user level security alternative in 2007 I have a 2000 database that users ULS for restricting access to forms and reports. What is the best, or any, solution for restricting access to forms and reports in 2007 which doesn't support ULS? ... 31 May 2010 15:15
Splitting Access 2007 dB on Citrix network I'm creating an Access 2007 dB which will have several users (no more than 10). I've never split a dB before or worked with a split dB. What is the best way to split the dB for a Citrix network? We have shared folders on the network server, and each user has their own 'Home' folder that only they have access to. ... 26 May 2010 15:47
Access 2010 With Previous Versions? Can anyone confirm that Access 2010 will coexist peacefully on the same machine with previous versions in the same way that Access 2007 does? ... 28 May 2010 22:31
Specify Different Workgroup File Hello all. I'm not sure if this is possible or not, so if anyone could tell me definitively, that would be great. I want to create an unsecured Microsoft Access database to access a secured Microsoft Access database. My thought was that the unsecured database would do some sort of validation and then create lin... 25 May 2010 21:14
How do you make a control button to copy a record to another table? Please help, a clear answer is needed! If the code below copies the record to the same table... How do you copy it to another table? I would be happy with this, but next how would you asign a numeric value in a field of the new record that the id of another table that is the focus of the main form. The other t... 23 May 2010 19:02
date fields when upgrading from Access 97 to 2007 Just upgraded from Access 97 to 2007 and all working well except I used a popup calendar using mscal.ocx in 97. But in access 2007, none of the fields using a date formula now don't work. Exactly the same thing happenend last year when I had to replace my computer and reinstal 97, but that was easily fixed by reins... 21 May 2010 01:55
Click on cell in PivotTable form view and open another form for related record Using MS Access 2007 I have a PivotTable form (created via Create- Forms-MoreForms-PivotTable) and I want to be able to open another form by clicking on a cell in the PivotTable form view, and the form needs to be linked to the record ID for the cell. If I add a macro to the On Dbl Click Event for a field via the... 21 May 2010 08:23
Preventing colon behind field name Whenever I add a table's field to a form, a colon is automatically added after the fieldname. Is there a way to prevent that from happening? I only want the field name. Thanks, Lars ... 19 May 2010 11:32 |