Recent content by rat_b76

If you do a search on "global variables" it will come up with many results in regards to what you are after.

Perhaps storing the ClassID in a Global Variable may help, this way you wouldn't be relying on an open form to obtain the ClassID?

Try holding the 'Shift' key down whilst opening the database.

Look in the properties of the combo box, specifically the Data tab.

You could use a loop, where your instr start number is the position +1 of the previous vbcr.

Hi All, I have a report based upon a query, which returns data based upon a financial year. I have, in the query, included a month ranking from 1 to 12 to allow it to display July to June correctly in order, however, I have created a Chart Report and I am unable to get it to sort by the month...

Hi, What you can use is something like, at the start of your event On Error Goto 10 <<All your code goes here as normal>> Exit Sub 10 MsgBox "There are no records",Vbokonly+vbinformation,"No Records" Exit Sub The Exit Sub at the end of your code stops it from progressing to your error code...

Hi, Post the code you have associated to your button, this will give people more of an idea about what is happening with the Button Click event. Cheers rat_b76

Hi, Searching for 'Error Trapping' should bring up plenty of posts which will deal with the problem that you describe - hopefully anyway. Cheers Rat_b76

Hi, If you want to validate a cells contents then you are using the incorrect VBA code, as what you are instructing Excel to do is to change the cell value to: ">0", is it that you want to validate that cell C7 is >0, if this is the case then you may wish to try something like: if...

Excel Issue Hi, Firstly, are your security settings at such a level to enable macros? Secondly, I ran a similar code through Excel, using a drop down box with 2 options and did not have a problem. The issue that I noticed with your code is that you are entering a cell value, but then you are...

Connection Error Hi, Try going to the following link: http://support.microsoft.com/default.aspx?scid=kb;en-us;306132&Product=acc It often helps to search the web, typing the error message in a search engine often provides plenty of responses. Cheers

Hi, Firstly, the correct syntax is 'Forms' not 'Form', additionally you will need to open the form first before trying to gather information from the specific form. Basically before you request the information, open the form in its hidden state, once you have got the value in the required text...

Shrew, You are getting closer, on the 'Unlock' button, alter the code for the 'password is correct' statement to something like: EncryptedBox.InputMask = "" You will see this reveals, once the correct password has been entered, the text underlying, you could also create a new button which...

Hi Shrew, By the use of VBA code you could do the following: 1. On click of the button have an Inputbox prompt for the password 2. If the password is correct then alter the Input Mask of the text field from "PASSWORD" to "" 3. If the password is incorrect then do nothing It all comes down...