Search results

At its simplest use insert a page break from the toolbox after the fields in the detail section.

Did you also register the references? Same menu-bar item, next choice down from "References ..." I havent got a register option on my toolbar! - Access 2000

When using the help file in the vb editor i cannot get any topics on ADO or ADOX. I can see them in the index but there no related help topic appears. I have reinstalled all files from the Office CD, addded any references that look like they might have something to do with ADO but still no luck...

The DB is FE/BE both on the server. Part of our site is connected to the server by a radio link. The link can often timeout, sometimes for just a few tenths of a second. When this happens clients using the DB on the remote site will often experience usually fatal problems, ie Disk or Network...

not a warning The importing picture bar is not a access warning message. I guess it is part of the class that implements the control.

Every record in my DB has a path to a jpeg. As i move from record to record it loads the picture on to the form, (this being the prefered way). Can i hide or disable the "Importing Picture" bar that appears every time? This is not a warning or error message so docmd.warning etc does not work.

Still the question is.... Thanks for the reply but it doesnt answer my question; how can i stop a user even accessing the record that an other user is in?

I have read an awful lot about the record locking stratagies. What i would like is for a user to be told they cannot access a record because it is already locked by someone else. NOT a confusing message about clipboards, dropping changes or overwriting which nobody understands and which appears...

Language setting crashes Access This is a reply to my own post of last year as the same thing happened again. I had installed a number of different language apps as we are an Internation school. I had added the Hebrew keyboard in SetLanguages which is NOT supported in Win98. For some bizzare...

A combobox filters the records on a form by date with the help of some month buttons. ie choose 2004 from the combo and Jan from a button and my code sets the filter property of the form. It works well until the case when there are no records found in which case the text in the combo box...

You need to refer specifically to the subform control on your mainform in your sql ie =[forms]![frmexample]![Mainchildsub].[Form]![cboParent]. Mainchildsub is the name of the control on your mainform. Sometimes you can get away without the .[Form] bit as well.

weapons of mass

I posted this question two years ago and couldnt get an answer. I am still having the same problem - perhaps someone can help now? When I import data and there is an error I always used to get a paste error table (access 97). Since i have switched to access 2000 I get the error message "You do...

It worked, thanks Thank you for that - it put me on the right track. I had to make a variable to construct the string in the format you showed and it works fine. Here is what i did. Thanks once again. Dim UserName, StringCall As String UserName = Forms!frmlogon!List0.Value StringCall =...

I have a secured database with 4 users ie admin, office, guest etc. I would like the user to be able to select from a list of the above and then automatically open the secured datebase with the selected user ie "/user office". I have gone someway towards it with a seperate dbase containing a...

How can you enter a tab character in a memo field. I thought it was ctrl/tab but this does not seem to work now (if it ever did). Also any ideas on how to keep tab characters when copied from Word? At the moment any tabs pasted into memo field is just a wierd character.

Thanks for the ideas MrTibbs. I tried most of your suggestions. It was a problem for all databases opened from my station and with all postscript printer drivers for any make of printer. I reinstalled office, i reinstalled windows but to no avail. as i needed to work urgently from my workstation...

Access on my computer has suddenly decided to crash whenever any db needs to go to a print preview or print action. If i select a different printer, ie deskjet it is fine. I have tried installing different printers and it only seems to crash with postscript printers - early laserjets or inkjets...

I have a student grades report that has two group levels. The first group header contains a subreport which gives a summary of grades for each student. The detail of the main report then contains the text comments for each pupil. So the report is printed as a summary page followed by two or...

Thank you for your help i have used a combination of both solutions.