Search results

Loading image dialog box crashes access I have many reports with linked images. When the report opens a quick dialog box comes up saying "Loading image". Since i have converted to Access 2003 something weird happens when the database window is open and the reports tab is selected: If the mouse...

I have an unbound form with 3 listboxes. The second listbox is bound to a query that gets a parameter from the first listboxs value list. It works fine. If i close the form from the "X" close buton or choose File - Close from the menubar it closes normally. I have a command button on the form...

I have a Recent Records combo box where the row source is updated every time the record is changed. I want to keep the row source text as it is at the end of the session - when the form is closed. I have tried all sorts of saving methods in form view and design view and am getting nowhere...

Is there anything wrong with having the same subform open in different forms at the same time?

I was quite pleased with this bit of code! It adds pairs of values to an unbound combobox on a form as you browse the records. I added it to the forms oncurrent event and a controls afterupdate. It adds the id number and name of the current record to the combobox but doesnt duplicate any Id...

How can i repeat a page in a report including the page header, detail, footer etc. I have code that will repeat the detail of a report but it doesnt work for the whole page. i have a report of 50 students, 1 per page. if the student needs a duplicate report i want to just repeat that students...

Parents can have one or more children. I want to return the youngest child of those parents with more than one child. I have [QryParent&children] that returns all the parents and all the children. I have used this as a sub query in [QryParents>1child]. This uses "In (SELECT [ParentsId] FROM...

I have a report that prints the front covers of all the pupils report. If the child needs two copies of the report i want that childs front cover to be duplicated. I have a field that is true if duplicate is needed but can't think how to implement this. Ideas?

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

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.

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

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

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

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.

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

Is it possible to make the Access Zoom box any bigger?

Interesting! paste from word table When I copy text from within a Word TABLE that contains paragraph marks into a textbox (memo type) in a form it loses the hard returns completely. Not even a symbol to show where they were. If the text is not in a table the hard returns appear as normal. Any...