Search results

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

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

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

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

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

Hi all, I'm currently working on a report to show the differences between two records (in this case, Documents). Each Document contains a number of paragraphs which are separate objects within my database. The purpose of this is to narrow down which paragraphs require reading (i.e...

Hi all, I've just added a button to a form to open a report (to show other similar objects - filters in the report at the moment but might change to the WHERE condition for opening this report). The code I have for the button is simply: DoCmd.OpenReport "Similar Clauses" However testing this...

Just a quick question (to which I'm guessing the answer is no), is it possible for a Header in a Report to always appear at the top of the screen - i.e. even when you scroll down the report? I have a few buttons at the top of my report (viewable on-screen only) and would like them to remain at...

Hi all, I'm developing a form to link a clause to one of a selection of internal documents from drop down boxes (of which there are a lot and hence looking for ways to make it more manageable to find). Now the setup of the internal documents is unfortunately beyond my control (separate...

Hi all, I'm now trying to speed up data entry within my database and have hit a brick wall with one part. Basically, this is within a form (for 'clauses') of which there is a one-to-one relationship with 'the Applicability' table (a series of fields with 'Yes/No' values for each and a related...

Hi all, I originally used a 'multi-valued combobox' to store applicability but ran into a headache or two (!) trying to get it to work. As a result I'm now using a table with a 1-1 relationship to record yes/no values for each type of company/particular time each record in the parent table...

Hi all, I've just tried splitting my database and the error message 'Subscript out of Range' came up. This is my first experience of splitting a database, but everything looks okay to me - the back end is saved okay, and the Front End (the original file) is still in place and links to the data...

Hi all, Firstly, I'm aware it's bad practice to use multi-valued comboboxes, but for the fields I use them it is a much nicer/cleaner input for the user to use. The problem comes when copying to a similar record (for updated records I create a copy of the previous except for the change - this...

Hi all, I've had a look around but can't find anything to suggest this is possible, but it seems like a feature that probably exists. Is it possible to save 'Watch List's so that you don't need to add a list of variables whenever you re-open a database?

Hi all, Is there a way to add a Watch for where the code will jump to On Error? Kind regards, Michael

[Solved] Collection - For Each loop doesn't appear to work Hi all, Another day, another problem with my database design it seems. I decided to test the User Permissions module in my database today and unfortunately it didn't work as I expected. The code is below with the problem area...

[Solved]: Sort separated numbers in a text field Hi all, In my database, one of the key records is identified by it's "Clause Number" as it appears in the document. Common convention is to number these as in the title example (7.15.1.2) however the number of levels of numbering changes even...