Recent content by BMag

I need to print an Access report from an Excel workbook using VBA. Is this possible?

This is a one time fix.

I have a table [QUANTITY] with the following fields: CatNum, LocID, MinQty, LocStored CatNum is the foreign key to another table. Each CatNum needs to be listed 4 times with the following different LocID fields:3S, 3R, 2C, 2S Example #1: [CatNum] [LocID] [MinQty] [LocStored] 888...

Are you able to add a field to the table directly? Or is the data coming from a source other than access?

If I open a form based on a query that returns no records, the form is completely blank. No controls, nothing. Is there any way to capture if the query is empty? I was thinking I could check in the form's OnOpen or OnLoad event. I just have no idea what property to check for. Thanks for any...

The data is not related The data is not related. LocStored2C has 16 records while LocStored3S has 25 records and LocStored3R has 5 records LocStored tables are storage locations in various areas.

I have searched this forum and FAQ's for cascading combobox and have not come across something to assist me with this version of cascading combo boxes. Any thoughts would be apreciated. I have 2 combo boxes and 4 tables to deal with. Combo boxes: cboQtyLocID and cboQtyLocation Tables...

I have a database that is similar to the Access supplied sample address database. I am attempting to modify it to suit my needs. I have two tables, Household - primarykey householdID, and Members - primarykey memberID. They have a one to many relationship on the field named HouseholdId in both...

I have a combo box that selects the record to be viewed on a form. That works fine. However if I use record selectors or use the wheel on the mouse to go to other records, the combo box does not change to reflect the current record. How do I make the combo box update automatically if the...