Recent content by joeblow3

Thanks dhookom!

Hi: I have a report based on a query, say Query1. Now I want to include in the report, a field (SumofQuantity) based on a second query, say Query2. Both Query1 and Query2 have the same parameter needed to run them. Is this possible? Initially I used the expression builder to say...

Thanks dhookom.

I am doing a "group-by" query. There is one field - a date field - which I want to appear in my query because it's tied to parameter conditions. But I don't want it as a group-by field because it gives me duplicate records. However, I get an error message if I don't put group-by in the total...

Thanks PH. I realize that it makes a compact and repair when doing a backup.

Hi: I need help in finding out how to make a backup of my database. When I look at the size of the file of my backend (database) it is about 10 MB. However, when I go to Tools|Database Utilities|Backup Database, it only creates a file of about 1 MB. This is causing me to wonder if using the...

Thanks.

Hi: Could someone tell me please what is the difference between backing up the database via the menus (Tools|Database Utilities|Back Up Database) and simply copying and pasting the database file? Thanks in advance.

Hi: I recently split my application (myapplication.mdb) into the database and the front-end. I put the database (myapplication_be.mdb) in a shared folder. I also made an mde (myapplication.mde) from myapplication.mdb My question is: how do I make changes to the database table...

Hi:(Access 2003) I split my application into the database part and the front-end. Then I made an mde out of my front-end. Now, when I look at the database window (when I open the mde): for the Forms and Reports the "Design" and "New" icons are greyed out. However this is not so for Tables and...

Hi: I have a listbox which has a Select statement( which returns two columns) as its Row Source. Now, when I change the listbox to a combo box it works fine except that the dropdown choices show both the columns but when I select a choice, it only finally shows the first column. The Combo...

many thanks for your help.

Hi: I am having a problem with saving data entered in a sub-form. I put a command button on the sub-form and used the wizard as follows: I chose "Record Operations", and "Save Record". It filled in code: DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 But this does not...

Thanks a lot to both of you guys. I got it to work by putting in the form name, omitting the 'Column(0)', and putting it in my click event.

The field I am talking about is a List Box. thanks