Search results

Dear All, What is the line of VB code for opening the switchboard so it appears on the screen instead of having to scroll to the top to see it again, to be included in the following ? Private Sub Command194_Click() On Error GoTo Err_Command194_Click DoCmd.DoMenuItem acFormBar...

Dear All, This is very frustrating. On my PC at work my database works fine with no 'invalid use of null' errors reported on my forms. BUT, when i get home and run the exact same database i get this 'invalid use of null' error and it's driving me crazy ! HELP !!!!!!!!!!! Thankyou in advance...

Dear All, I am getting an 'invalid use of null' error on clicking the button with the following underlying code. What is the problem here ? Private Sub accidentreport_Click() On Error GoTo Err_accidentreport_Click Dim stDocName As String Dim stLinkCriteria As String Dim c, d As...

Dear All, I am getting an 'invalid use of null' error on clicking the button with the following underlying code. What is the problem here ? Private Sub accidentreport_Click() On Error GoTo Err_accidentreport_Click Dim stDocName As String Dim stLinkCriteria As String Dim c, d As...

Dear All, where in the following code and what is the actual code for closing the form that this code resides in. The form to close is TREATMENT FORM. Your help would be most appreciated. I know the code isn't the most effiecient way of doing this but for now all i want is my question above...

Dear All, I know this is a bit long winded but it might be the best way to express the problem. I need a button that will save the current data, close the form, print a report and goto to another form. I have the code for all three in seperate buttons but need to combine them into one. Here is...

Dear All, Is there a way to customise the in-built Access warning when a user input data in a field in the wrong format ? Thankyou in advance, Anthony

Dear All, I am somewhat new to Access 2000. Basically I have one form with various details that a user enters. At the end of that form there is a button that takes you to another form. I would like the details of for example, name and date of birth that have been entered to be taken to the new...

Dear All, I have a multi-list box that i have set to simple. The problem is that it is fine when select items when holding CTRL and clicking on the items you want but after I have finished and gone to the next form those same items I clicked on are displayed. Also when viewing the form as a...

Dear All, On my form I have placed a button to print that record in report form, but on hitting this button it proceeds to print the whole database ! I only want to print the ONE report from the current form. Help ! Thankyou in advance for your help. Anthony Evans

Dear All, Is is possible for me to have a combo where a user can select and tick various items and for the items ticked to then be displayed in my report with all the other entered data ? Thankyou in advance to anyone that may be able to help me, Anthony

Dear All, When deleting records the AutoNumber for my first field does not reset to the last number of the last field. i.e. it still reads 6 even though i have deleted 5 records. How can I have this field reset to the last record number that exists. Thankyou in advance for your help...

I would like a form to automatically capitilize the first letter of a chosen field, such as a persons first name when a user enters this data. Is there an input mask that will do this for me ? Thankyou in advance for your kind help. Anthony