Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. joeblow3

    a second query in a report using the same parameter

    Thanks dhookom!
  2. joeblow3

    a second query in a report using the same parameter

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

    Group By query

    Thanks dhookom.
  4. joeblow3

    Group By query

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

    Database backup

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

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

    difference between backup and copy/paste

    Thanks.
  8. joeblow3

    difference between backup and copy/paste

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

    making changes after deployment

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

    deployment problems

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

    listbox vs. combobox

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

    saving data in a subform

    many thanks for your help.
  13. joeblow3

    saving data in a subform

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

    Enter parameter value

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

    field in sub-form of a sub-form

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

    Enter parameter value

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

    field in sub-form of a sub-form

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

    Enter parameter value

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

    Enter parameter value

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

    spliting MS Acess database from forms,queries and reports

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

Part and Inventory Search

Back
Top