Search results

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

How to write a macro.... Hi, If you look at the following thread, this may help you with what you need: http://www.access-programmers.co.uk/forums/showthread.php?t=67385&highlight=wildcard+query Cheers rat_b76.

Hi All, I have learnt VBA in access 2000, and am now working in a place which uses access 97. I am having some trouble in creating a new record, by memory all I used to have to do is; forms!frmMaster.recordset.addnew However, this does not seem to work within 97? Can someone point me in...

Database Hi Richard, I have attached a copy of your database with an example pop-up form. Here are just a few points which may help you understand the code a little better; In the Product MasterList Form Private Sub Form_Load() On Error GoTo 10 DoCmd.OpenForm "Partial Delivery Status...

Hi Richard, The reason why your comboboxes will not allow selections is that the form is set to not allow edits, which prevents all changes on the form. You need to change this to 'Enable Edits' to Yes in the form properties. In regards to your pop-up form, what I have done in the past is put...

frmViews If you set the form open method in Visual Basic to the following, it should work; DoCmd.OpenForm "Your Form",acformDS Cheers & Beers