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

    Query results into existing Excel worksheet

    I spent quite a bit of time yesterday finding a solution to a problem, and I did get it to work, but I feel sure there is a much easier way to accomplish it. I welcome any ideas on making this work better. I have a Union query that returns 48 rows (theoretically this number is consistent...
  2. JSchumacher

    How do I read properties on Text files?

    Thank you! It worked like a charm.
  3. JSchumacher

    How do I read properties on Text files?

    I am trying to find the "last saved date" from a group of files. One is an Excel file and the others are .txt files. I was able to find the correct date for the Excel file using BuiltInDocumentProperties after using GetObject, but GetObject is not working on the text files. Do I...
  4. JSchumacher

    Using tab to toggle

    It sounds like a Tab Control was used. You can have a number of different pages displayed, each by pressing a button. The default Style is a Tab, so if you want buttons, you will need to go to the properties sheet for the Tab Control and change Style to be Buttons.
  5. JSchumacher

    Help!! Problems with updating table fields through my form

    Stefan, If this calculation will be used by more than one form, you should create a Module for it. Click on the Modules Tab (next to the Macros Tab), and click on New. If this will OLNY be used in this form, you can place the code in the module that belongs to this form. If you create a new...
  6. JSchumacher

    Help!! Problems with updating table fields through my form

    Stefan, You need to create a function like: Private Function VerifyData as Boolean If txtJanuary >1 and txtJanaury <15 then VerifyData=True Exit Function You would modify the If..Then to check for your desired information - including weather or not the value results in your reliant...
  7. JSchumacher

    HOW CAN I RECORD DATE AND USERS NAME AUTO!!!!

    Are you trying to write history to a table regarding who is opening and closing forms and when? Assuming this is the table to store the desired information: tblFormHistory ------------- FormHistoryID EndUserID FormName DateOpened DateClosed Create these functions in a module: Public...
  8. JSchumacher

    Help!! Problems with updating table fields through my form

    Then all you need is one line to save the changes: If Dirty = True Then Dirty = False However, if what the user entered isn't valid for that field (ex. it's a number field - what happens if they enter text?), they will get an error.
  9. JSchumacher

    Help!! Problems with updating table fields through my form

    Open your form in Design view and open the properties sheet. Click once on your text box to select it. On the On Exit line use the drop down box to choose [Event Procedure] or click to the right of the drop down box on the Builder Button (...) and choose Code Builder. It will place the first...
  10. JSchumacher

    Help!! Problems with updating table fields through my form

    Stefan, How about checking each text box as you leave it and writing the data to the tables if it is valid. Something like this: Private Sub txtJanaury_Exit(Cancel As Integer) If Dirty = True Then If VerifyData = True Then Dirty = False Else MsgBox...
  11. JSchumacher

    Combo box error after conversion to 2000

    In trying to figure this out, I'm checking out various properties. I notice that the ColTyp on the combo box I'm using doesn't change in Access 97 (where this works), but in 2000 it does. On load it is 0, then when the RowSource is set the first time it becomes an 8 when fraReportType is 1 or...
  12. JSchumacher

    Combo box error after conversion to 2000

    Here is the code that modifies the RowSource. At the end of the code I Null out the value of the Combo box and set two other Combo boxes to have the same RowSource. Private Sub fraReportType_AfterUpdate() Select Case fraReportType Case 1, 2 lblPeriodCurrent.Caption =...
  13. JSchumacher

    Combo box error after conversion to 2000

    I'm still unable to get this to work - any ideas anyone??? Thanks.
  14. JSchumacher

    ADO STATEMENT DOES NOT QUERY TEXT

    Compucop, I think your problem has to do with the data type of your field Number in your table Table1. If the field has a data type of number then your statement is looking for: ...WHERE Number=7... If your field Number is a text field then your statement is looking for: ...WHERE Number...
  15. JSchumacher

    Combo box error after conversion to 2000

    Hi, I recently converted a db from 97 to 2k. I have a combo box with the RowSource modified in the code as different option groups are changed. One of the statements returns a Short Date and another returns the Year using a DatePart function to find it. The combo box worked fine in 97, but...
  16. JSchumacher

    OPEN NEW SUBFORM IN WINDOW (II)

    What about using a Tab Control? Each page would contain a different subform that you need. Set the OnClick for the Next button to move the value of the Tab Control. I'm currently working on a similar issue and that's the solution I'm using. I haven't completed it yet, but it appears to be...
  17. JSchumacher

    Continuous Form - List box in Access97

    I see that this question was never answered. It's exactly the question I came in here looking for the answer to. In my instance I have two tables: tblPaymentSet SetID PersonID SetDate SetStatus tblPaymentPlan PlanID SetID PlanDate PlanAmt PaymentTypeID tblPaymentSet will have a handful of...
  18. JSchumacher

    When to store data using Tab Control

    I am creating a form for setting up a new account. The form is a tab control with 4 tabs. Tab 1 collects the name of each customer on the account. Tab 2 collects address and phone information for each of those customers. Tab 3 collects information regarding each piece of collateral on the...
  19. JSchumacher

    Can I look up a Time Zone?

    I would like to add a feature to a form so that after the user enters a client's address or perhaps phone number, the client's Time Zone would display. I assume a lookup could occur based on ZIP code or Area Code, but I couldn't find anything in Help or a Keyword search that seemed to address...
  20. JSchumacher

    Form Validation

    I couldn't get this to work the way you wrote it. Then I realized that I wanted to test the data that was entered, not just avoid a Null. When I changed the IsNull (txtLogID)= True to a different test, len(txtLogID)<>6, and I entered data in the field, it worked fine. It still dosen't allow...

Part and Inventory Search

Back
Top