Search results

thanks for that info. I have been trying for ages to figure it out. I changed the font to arial first and it worked for a while but then went weird again. I am trying baltic now - it works lets hope it keeps working.:)

From 2000 to 2003. It does it on all computers. I have disabled the dialog box in the registry now but it is still doing the process as you can see the mouse pointer changing to timer as it hovers over the report icon

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

parameter incorrect fix We started having this problem after we reinstalled our remote desktop server. If there was more than one user in the database all other remote desktops would get the above error message. I found this fix from another forum which has done the trick for us - although i do...

Still confused. Do you want to apply more than one filter to the listbox - if so is it an AND or an OR filter? ie Select fldName = Bella AND fldAge = 12 AND fldcolor = brown OR fldweight > 29

if you are trying to show the total of the items in the subform on the FORM footer i should put the calculated textbox on the sub form footer (hide it if you wanT). Then set the record source of the textbox on the main form to the textbox calculating the value on the subform. Make sure you use...

looking at the example i should search the forum for "cascading combo box" there are plenty of examples for this which would probally be a better solution to your form/sub form example.

have you tried stepping through the sub in debug mode to see when this mystery call to the domenuitem is occuring?

do you mean filter a listbox by choosing a criteria from another listbox? or fltering it by the user typing in a criteria?

Bind the combobox to the table to show the possible values to filter on. In the query build a parameter based on the selected value from the listbox. Use the onchange event of the combobox to requery the form - this will run the query using the filter selected from the combobox and refresh the...

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

Yes thanks Tony. I have used the table option which works ok. I would still like to understand why it sometimes saves something in the row source.

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

i dont think i have explained this very well. I dont need to filter the report. The report prints out a page for each student. Each page has a group header, detail containg exam grades and group footer. I have a field on the report that indicates if the student needs two copies of the same page...

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

And me I am trying to solve this problem particularly as the message appears for every contact the code is emailing ie 10 contacts 10 messages! So far i have only found this knowledge base article which seem sto suggest there is noy really an easy way roud it. Read it and let me know if you can...

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?