Search results

I do the same as Pat. I usually buy books when I need to solve a problem and I can't find it in online forums or just need a general resource that gives lots of info in an area of software I am weak in. The reason I recommend Alison Balter's book is she takes from beginner to advanced and all...

Sounds like you are trying to do two different things: Append data where it does not exist Update data where it does exist and needs changed If this is the case you need to first check to see if data exists and then depending on whether it is, either update or append. I am working on an...

Absolutely! So, assuming user security has been set so the user has no rights to view the table: this is a workaround that allows the user access to non confidential fields in that table. Frozbie

Hi, Just had to share this... Been reading Alison Balter's Mastering Access 2000 Development - fantastic book and highly recommended. She shares a trick on how to give users access to fields within tables without giving them access to other confidential fields within tables. User is not...

(Using Access 2003 with file saved as Access 2000) Hi, I have a form to display the hours worked by employees for a given four week period and hours carried forward under a flex time system. Under the system I have created, users can save the hours worked and balance carried forward to a...

Works perfectly! Thanks GHudson! I searched the forum having found myself in exactly the same situation. I followed your instructions and now both my front end application and back end database are secured using the same workgroup file. It seems to me that to further secure the back end...

Thanks! Thanks for your reply Rich. I spent all Friday working on the query to calculate premiums for Monday through Thursday and found I just couldn't cope with all those nested iif statements. I guess it is all experience and I'm glad I was able to produce such a complex query that worked...

Hi, I am looking for some advice on whether to continue using a query or change to a query which uses a function to deal with the hard parts of the calculation. I am creating a rota/shift management system. The database is fully normalised and is now working to the extent that shifts can be...

The client is always right! Except when you can persuade them otherwise Hi everyone, Thanks for your responses. I'm at home now but will try these out tomorrow. To answer your questions Rich and SJ, if there is a better/simpler way to deal with the form I would like to use it, any suggestions...

Hi, Is it possible to simulate a control array in MS Access? I’m using a restricted version of Access 2000. I can use all normal features but some Active X controls are not licensed and it will not be possible to licence them in time I have available for my project. I have a form which has 14...

Fixed it! Hi, I created a VBA sub that pulled the data into an array, sorted it and then placed the data in an unnormalised table that I'm using to display a weeks worth of data at a time. I suspect an SQL query to do all this would be hideously complicated but I still don't consider myself...

Hi, This is my first forum post. I am developing a schedule/rota system in Access 2000. For security reasons Access is locked down tight and I am not able to use controls like the MS FlexGrid etc. I have normalised my data and created several tables, one of which holds shifts: tbl_shifts...