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

    Counter Not Starting From Zero?

    That worked. THANKS!
  2. TZyk2003

    Counter Not Starting From Zero?

    Thanks for the reply! I don't see that option in Access 97 - maybe that's my problem. For an autonumber, there are two Field Properties tabs - General and Lookup. General has 5 rows, 1.) Field Size, 2.) New Values, 3.) Format, 4.) Caption, and 5.) Indexed. The lookup tab is blank. So I...
  3. TZyk2003

    Counter Not Starting From Zero?

    Hey everyone - great to be here! I'm trying to do something that seems relatively easy. I have a bound form that is tied to a record set. I have a primary key of Order ID and I'd like each time you click the "new record" button a new Order ID is automatically populated with the current order...
  4. TZyk2003

    Enable Mouse Wheel in Dropdown in Access 97

    Good afternoon everyone! I love this site...it's helped me soo much with my Access coding! My problem (well, not really a problem): I have a dropdown which is populated through a query on the main form in my access database. Unfortunetly, the mouse wheel will NOT scroll through the dropdown...
  5. TZyk2003

    Versioning in MS Access?

    Good afternoon all, At my company, we are having problems with our users going into the access database and changing things without telling anyone. My question is, there anyway to version an access database? Or, I know there is a way to force a login/password. But is there a way to record...
  6. TZyk2003

    Using the 'Like' Command in Visual Basic

    Thanks! I'll try that! -Tim
  7. TZyk2003

    Using the 'Like' Command in Visual Basic

    Good morning! I have a field that I'd like to suppress if it contains certains text values. The problem is it may contain one text value or many text values seperated by commas. What is the syntax for doing a "Like" command (like in SQL) in Visual Basic?? I can't simply do an "=". THANKS! -Tim
  8. TZyk2003

    Supress Report Footer on Certain Values in Field

    Hmm...maybe you didn't understand my question. I'm using VB code for on "On Open" option for the report. The footer name is [Defect Impacted Center]. There's a field called "Impacted Center" in the footer body. How do I reference the "Visible" option for the FOOTER (NOT the field) in VB...
  9. TZyk2003

    Supress Report Footer on Certain Values in Field

    Good morning all! It's good to be back on this site! Here's my question. I have a report footer with only ONE field in it. I need to set the 'Visible' property of the Report Footer to 'No' if any 1 of a certain 5 values appears in the field in the footer. What is the VB code to reference...
  10. TZyk2003

    "#Error" for some reason!

    Ahh....that works.....just take of the [qry] part. Thanks! -Tim
  11. TZyk2003

    "#Error" for some reason!

    Hey CosmoKramer...thanks for the reply. Yes, [qry]![Test_Cond_Cycle_1_Plan_eBAT_REG_CLA] is the correct name. They are each individual fields in the tables. Any ideas??? I'm stuck! Thanks! -Tim
  12. TZyk2003

    "#Error" for some reason!

    Actually guys: When I insert ONLY this I still get an #Error. Sum([qry]![Test_Cond_Cycle_1_Plan_eBAT_REG_CLA]+[qry]![Test_Cond_Cycle_1_Plan_eBAT]+[qry]![Test_Cond_Cycle_1_Plan_eBAT_REG_ENT]+[qry]![Test_Cond_Cycle_1_Plan_eBAT_REG_FUNC]) Why does this cause an error??? Why can't it sum those...
  13. TZyk2003

    "#Error" for some reason!

    Hey everyone...good morning! Anyone know why this control source gives me an "#Error"...doesn't make sense...I checked all the "("s and ")"s and it looks right. The fields are all perfectly accurate - the query is correct. I added the spaces to make it easy to read for ya. =IIf(...
  14. TZyk2003

    Good afternoon all! Ok, I need o

    How about a follow up question for a star (or two)? Ok, for the same database. I have to do seperate queries for each pass since there is a report for each pass. So, ALL the PMT_No's are in Project but they MAY OR MAY NOT be in "Project_Test_CB" Table or "Project_Test_BDR&quot...
  15. TZyk2003

    Good afternoon all! Ok, I need o

    It worked!! Thanks a million! -Tim
  16. TZyk2003

    Good afternoon all! Ok, I need o

    Sorry about the topic! It won't let me edit my post after I sent it!
  17. TZyk2003

    Good afternoon all! Ok, I need o

    Good afternoon all! Ok, I need one query to do something rather complicated. Break out your SQL skills! I have 3 tables. Table 1 = Project Table 2 = Project_Test_CB Table 3 = Project_Test_BDR The 'Project' table has a primary key named "PMT_No". Tables 2 and 3 have further...
  18. TZyk2003

    Eliminate (not make invisible) a subreport with No Data

    Good morning all! Here's my question, hopefully it's easy: I have a Report with 6 subreports. They are all located in the Details section and are placed 1 at the very top of the details section then the remaining 5 beneath one other. Now, some reports will have data and some won't. If one...
  19. TZyk2003

    Auto-Populate Fields in 2 Subforms with 1st Subform Data

    Okay, but how does that help me? If rs.BOF is TRUE and rs.EOF is TRUE then there is no current record and the same error occurs saying "There is on Current Record". There will NEVER be a current record until the user clicks out of the subform. So what can I do? Many thanks! -Tim
  20. TZyk2003

    Auto-Populate Fields in 2 Subforms with 1st Subform Data

    Thanks so much for the e-mail Rolliee...your code worked great (after tweaking it a bit) except for one small problem. When there is no "Current Record" then it gets an error. (saying there is no Current Record). I added a button that once clicked fills in the Pass 2 and Pass 3 stuff...

Part and Inventory Search

Back
Top