Search results

I've included my tables, input data, output data and sql. As you will notice the self join introduces errors in numbers in both Expr1 and Expr3. I hope someone can see what is introducing the errors and how to fix it. Thanks

Can anyone please suggest something to read regarding the way Access nests joins in the "from" clause- all that amount of bracketing etc. Especially self joins. Thanks.

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...

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 as the dates are all different . However, I get an error message if I...

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...

How do I declare and use variables in the expression builder? Thanks

Hi: I have the following situation: I have a form called Events(based on an Events table) and a subform called Participant_line(based on a Participant_line table). The Events form has a field Event_id while the Participant_line form has an Event_id and Participant_id fields.The two forms are...

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...

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...

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.

In a form that updates a table, it seems that I have to click on (select) each of the fields in list boxes for Access to accept the fields and update the table. Otherwise it complains that a related record is required. (I am --through code--populating the list boxes so I am not explicitly...

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...