I need to write an MS Access Report which, for a given supplier record, first lists all invoice records for that supplier and then lists all branch records for...

Hi I have a form with a list box and a sub form. The list box is bound to a query. The query uses a field from the sub form in its selection criteria. The...

I have a 'find record' command button on a form. How do I make it open the 'find' popup with 'Lookin' set to the whole database (rather than the field that...

Anyone know how to dynamically reduce the font size of text within a textbox so that all text within a field will always be printed on one line? I'm not...

I've just started using access so forgive this really basic question :-) I am trying to create a database that has 1 main table and 4 other tables (and forms...

Hi, what I would like to do is selectively hide or make invisible certain controls on a continuous form, i.e on one detail line the control would be visible...

Hello! Say, I believe that a 'tab control' allows hotkeys (i.e., &Page1, P&age2, etc...). But is there a 'trick' to doing this? I set mine up (in the Page...

Almost had finished building a set simple data entry forms when everything turned to custard! help! brief structure description- 10 tables linked by a single...

I have upgraded a small local app from Access 2003 to 2007. I have a menu that calls a few forms. On the first form I tried to open from the menu, I've...

I just added a new tab to a tabbed control and put 3 subforms on the tab. Whenever I run the application and select the tab, I get a MS Access message window...

I am looking to create a database using Access 2003 that has a number of forms each being a checklist. Against the list of headings I would like a box with...

I have read through all of the past posts about auto-updating a combo box by using the NotInList event, but for some reason I can't wrap my head around it. I...

This message popped up when i tried accessing data in tables. This was an attempt made using the datasheet view. First time this happened! - Tried compacting...

Anyone have any advice regarding the following? I created a little MDB file with the following 3 tables and records (using Access 2003...

I want to find a record by using a text box. The user starts typing the name of the person they are looking for in the box, and the box suggests possible...

I have developed a form, based on a query and set it to datasheet view mode. What I'd like to do is use the form to search through records and then be able...

Hi All, does anybody know the colour code for the (blue) background MDI (A2K7) - i am trying to make a form look transparent? TIA Keers

how can I, while one form, open a second form, and then, while leaving the 2nd open, be able to go back to the 1st form and work on it. thanks in...

I've been struggling for about ten hours now and my local colleagues don't know either. I have a table called Awards. It holds twenty-odd fields related to...

gtre czxrev vtzer