Recent content by Futures_Bright

Sorry the 'pause the code' bit came from reading something that suggested the code after opening the form would stop until the user closed the Dialog window before continuing - this I interpreted as 'pausing' but haven't fully tested myself because the Dialog windows aren't practical for this...

@DBguy/vba_php: I had to give myself a refresher on the difference between dialog, modal and pop up. This could help others (as it looks like dialog should pause the code until the window is closed, and modal should force the focus) but unfortunately for my situation there are occasions the user...

Hi all, I have a problem that has taken me quite a while to try and understand and how to resolve it... I think I understand what the problem is and have an idea of how to fix it - but since I'm not confident about it and the solution will be a ballache I want to get a second opinion: The...

Hi MarkK, I'm getting an "Argument is not optional" and the debugger is highlighting "GetRecordOfRecordsText" in the private sub. Not an error I've come across yet, and unfortunately this is a database design I've inherited so I'm not entirely sure where to start looking! I notice that Option...

I've got this in a text box on a sub form; how do I go about updating it whenever the parent form record changes? At the moment it always shows 1 of 1 when I first jump to a record and nothing I seem to do works for this. I've got closest by setting the field on the top form - it works when...

Thanks for your help Gemma, the multiple users using the same front end did appear to be the issue. We resolved it by replacing the citrix shortcut with a .bat file that copied the front end to the user's "my documents" folder (without prompt if replacing) and opened from there. Added bonus -...

Thank you for the suggestion llkhoutx (P.S. "Newly Registered User" + join date Feb 2001!?). I'm not sure I completely understand the record locking - would this error also occur if people use different front end's? I thought it would. Also the first forms that users are guided to are unbound...

I'm not an expert by any means, but If all the machines that will use the database have Access installed I would go for Access Full version myself. If I remember/understand it correctly the run-time is useful when it is to be downloaded and used by a multitude of users who may not have access...

Hi all, I've designed and built a database for my company and launched it recently. Unfortunately users have started complaining about an error message appearing stating "The database has been placed in a state of admin by...". Even after reading several forum threads on similar faults, I'm at...

Hi all, I'm struggling with a bit of SQL code in my VBA when opening a report. I've defined a string in my code called strSQLQuery which is added to depending on how many criteria a user has defined on a form (all works so far where the criteria are drop down boxes). The problem is that I...

You might want to look at the securities on the network drive, I had something similar - I believe you will need to allow Read and Write permissions - Modify you can leave off for general users (so they can't delete it!)

Hi Gemma, To answer your questions: Firstly (just to clarify - in case this has some input to the solution) 'users' can only see reports (and only navigation forms which there is no need to protect printing of). They need to be able to see the data. The contents of my database are revision...

Apologies for my lack of comment on this thread - found a few more bugs to squish before I sort this feature out! Would making an onkeypress event for Ctrl+P overrule the office default? I'll test these out when I get a chance (which could be next week or next month at the moment!), thanks...

Hi all, I've been asked to make sure only certain users in my database are able to print anything (i.e. Administrators). Is there any option/property to do this? I have already built in User Access controls using the ctl.Tag property. The only way I can think off the top of my head is when a...

Hi Cronk, Thanks for your response. I've had a look at the code and unfortunately not been able to narrow it down. It happens correctly probably 99% of the time, but on those rare occasions where it doesn't seem to work pressing 'Undo', closing the form and then pressing the button again (i.e...