Search results for query: *

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

Hi: My setup is as follows: I have a Main form which has a listbox (List33) from which I (on selection of an item) want to populate another listbox (List11) on a sub-form of a sub-form of the main form. My code on the main form is: Private Sub List33_AfterUpdate() Dim stDocName As String...

What is the code in the main Form please. I want to change the Row Source of a field in a sub-form of a sub-form (of the main form)? Thanks in advance.

Thanks. If I have both Program_id and Program_description in a single listbox how does it know to only take the Program_id part which is required in the form to update a table that the form is being used for.

Hi: I have two list boxes on a form- one called List12 and the other Program_id. What I want to do is that when the user selects Program_description in List12, the Program_id List box should be populated with Program_id. It does it but only after I get a "Enter Parameter value" prompt and I...

How do I "split" the database (mdb file) from the front end things? What I'm trying to do is have multiple users access the MS-Access database on a server using a java front-end in an html page, ie I want multiple users to access the database over the internet. However I am not able to define...