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 Rhinorhino 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: *

  • Users: TZyk2003
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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...
  4. 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
  5. 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...
  6. 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(...
  7. 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...
  8. 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...
  9. TZyk2003

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

    Hello all...this board is fantastic! What a great tool it is for me... Okay, i'll explain my problem a little better than in the title. I have a subform with say 2 fields. The first field is "Pass" which is the primary key and cannot have duplicate values. The second field is...
  10. TZyk2003

    Using LIKE SQL syntax with a Form Value

    Hey guys! Great board! I have a form with only have one field that loads a query based off that one field. Simple. However, here is what I have: SELECT BTN.BTN, BTN.HIERARCHY_ID FROM Customer WHERE BTN.BTN LIKE '[Forms]![BTN Search]![Text0]'; Now, in the form I want to be able to use a %...
  11. TZyk2003

    Same Subreport Repeated 100 Times

    Hello everyone! I have created a report with ONE subreport. The subreport has it's own query and no fields are linked between the main and sub report. Now, when I go into the subreport and do a Print Preview the correct 1 page report is shown. However, if I go back to the main form and...
  12. TZyk2003

    Getting the #Num! Error

    Good afternoon everyone! I have this as a control source in my access report. =([Test_Cond_Cycle_0_Comp]+[Test_Cond_Cycle_1_Comp]+[Test_Cond_Cycle_2_Comp])/([Test_Cond_Cycle_0_Plan]+[Test_Cond_Cycle_1_Plan]+[Test_Cond_Cycle_2_Plan]) It works great EXCEPT when it ends up with 0 / 0 which...
  13. TZyk2003

    Question about Seek Function

    Good morning everyone! I am trying to change some code around a bit in order to work without 2 previous parameters. The main idea is the code has to check if a tuple is already in the database. Here is the old version (with the two values I don't want): Set rstTable1 =...
  14. TZyk2003

    Problem with Access List Boxes in SQL

    Hey everyone. It's good to be on the board. I have a question. I am trying to take a list box with the values ('A', 'B', 'C') and then run a query based on what is chosen in the list box. I have the list box set to "MultiSelect: Extended" since you can pick more than on letter. The...

Part and Inventory Search

Back
Top