Search results

  1. F

    Screen.ActiveForm returning wrong form

    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...
  2. F

    Screen.ActiveForm returning wrong form

    @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...
  3. F

    Screen.ActiveForm returning wrong form

    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...
  4. F

    current record count and total record count on form

    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...
  5. F

    current record count and total record count on form

    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...
  6. F

    "The database has been placed in a state of admin by..."

    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 -...
  7. F

    "The database has been placed in a state of admin by..."

    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...
  8. F

    Access full version or Access Runtime version for deploying the front-end?

    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...
  9. F

    "The database has been placed in a state of admin by..."

    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...
  10. F

    Open report where text contains (SQL question)

    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...
  11. F

    Split Database

    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!)
  12. F

    Restrict Print Rights to users

    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...
  13. F

    Restrict Print Rights to users

    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...
  14. F

    Restrict Print Rights to users

    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...
  15. F

    Open Form, acFormAdd occasionally replaces record

    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...
  16. F

    Open Form, acFormAdd occasionally replaces record

    Hi all, I've noticed a little problem in my database and can't quite work out what causes it. I've noticed that occasionally when pressing a button I've made to 'create a review record', it will overwrite the very first 'review' in the table even though it should be opening in the form...
  17. F

    Report to show differences between two records

    Okay, I've finally got around to taking some time with this report and it does work where the Clause Numbers are the same. I've tried using 'Sub Category' as the link instead and this works better (meaning a different order can be used) however it isn't a perfect solution due to the fact that 1...
  18. F

    Find/GoTo first record where [Field] is blank

    Hi all, I've created a report grouping items into categories; to aid the navigation I've included unbound textboxes with a count of each category at the top of the report and allowed the user to click to find the first of each category (filtering was not allowed as part of the design criteria...
  19. F

    Report containing Contact Info

    Hi all, I have a query from a colleague for their database. They have a report which lists a name and contact info - at the moment this is set in the report. However noone has the ability to edit the report outside of developer mode (hence why I'm being asked!). This information will change...
  20. F

    Click Locked/Disabled controls, prompt for variable

    Hi all, I have a form for reviews ("Review") which locks and disables almost all controls when the review is verified. On this form is a sub -form ("ReviewDocSubForm") which shows related documents to the review in a continuous format; all controls on this form are locked/disabled by default...
Top Bottom