Search results

If your list of items are fields then you need to add your fields to the report's Sorting and Grouping in the order you want them, with Group Header and Footer both = No. If your list is the items that can appear in a single field, then you need to introduce a sort order. This can be done in...

I'd guess that you have either an OnOpen event or an OnCurrent event that tries to save or requery your record. If the form opens up on a new record then you may get an error because the primary key field is blank for that record. Have a look at your form in design view and see what events...

The syntax is CurrentProject.AllForms("FormName").IsLoaded. I think that as far as the AllForms collection is concerned, the FormName is still just frmTracks, and not frmUnbound!frmTracks. Otherwise, to reference the subform you would need to use frmUnbound!frmTracks.Form anyway. Without...

Alternatively... Private Sub cbox_AfterUpdate() Me!ListX.Visible = (Me!cbox="X") Me!ListY.Visible = (Me!cbox="Y") End Sub So ListX becomes visible whenever cbox="X" and becomes invisble whenever it doesn't, etc.

I think you need to reference your combo boxes by going through the main form, so it looks like: WHERE [Table].[Field]=forms![Main form name]![Subform control name].form![Control name] You find the control through the route Forms Collection > Main Form > Subform Control on Main Form >...

Glad I could help :-) As David says, switching between versions for development is not always a good idea. I don't know about Access, but Word and Excel 2007 don't play too nicely with the earlier versions.

I don't know about the Macro problem, might be worth trying a compact and repair. As for your other problem, have you set any of the items to be hidden? If so then check your Options to see if Hidden Objects are visible. If you have Modules that are invisible, then go into the VB code, go to...

In Access 2003, you can click on the label and cut it without the control being cut too, then click on the section you want the label in (detail/header/etc) and paste - even if it's in the same section as the control, the two should now be permanently unlinked. If you are on a control when you...

It sounds like you might need to open the database through a shortcut. You do this if you have created an .mdw file when setting up your security, and it allows you to have multiple usernames with different settings for each. The easiest way to do this is to start from a shortcut to Access (if...