Search results

  1. M

    Help with Relationships and Linking

    I've got an issue I can't seem to get around. I've got a linked table from an ODBC (tbl_1). I then have a make-table query (qry_1) that takes the fields, formats them, and creates a static table (tbl_2). I then have a one-to-many relationship between tbl_2 and another table (tbl_3). When I try...
  2. M

    How to export unbound form to excel with all formatting

    Access 2003 Hello. Hope this makes sense. I have an unbound form with unbound fields/values. This form is a calculator created in vb and I have no tables or queries associated with any of the data entered etc. When the user enters data into the various fields, I want them to be able to click a...
  3. M

    Need help on Logic & Code for Grid

    Hello all, I'm stumped on this one. Hoping someone can provide logic and/or code for the attatched grid. I have two text boxes (txtWeeklyPts1 & txtPotentialPayout1) on a form in Access 2003..... all unbound. fyi: The entire calculator is coded in VB This is how the calculator should work: ie...
  4. M

    How to sum a series of unbound text boxes on a form

    I have a question..... hopefully a simple one. How do you Sum a series of unbound text boxes on a form without manually having to enter each textbox name etc. Example: I have a series of text boxes::: txtTBASS1bonus, txtTBASS2bonus, txtTBASS3bonus... through 25 txtRTF1bonus, txtRTF2bonus...
  5. M

    Need help with Access VB nested If Statement

    I'll admit I'm a newb.....any help is much appreciated. I'm getting "else without if" errors. I know this is self explanitory, but I'm still not getting it after trying multiple variations. txtTBASS1 is a text box on a form (frmService) txtTBASS1pts is a text box on a form (frmService) Here...
  6. M

    Need Help w/Nested IF Statements

    I've tried to setup a nested if statement with no results. Any help is much appreciated. Here is how it works: If Me.txtTBASS is < 44.5, than Me.txtTBASSpts = 0 If Me.txtTBASS is >= 44.5 And <52, than Me.txtTBASSpts = 40 If Me.txtTBASS is >= 52 And <60, than Me.txtTBASSpts = 70 If Me.txtTBASS...
Back
Top Bottom