Recent content by Jhitch

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