Search results

  1. E

    Open pop-up form based on selection

    :eek: moving around in that reworked db file crashed ms access 2000 on my pc! it caused an error in vbe6.dll. It was when i clicked any option in the some combo boxes.
  2. E

    #Error? message when using function

    Thanks Pat, it worked! I would not have figured it out myself.
  3. E

    #Error? message when using function

    I'm trying to use the UCase() function to change my text field on my report to all upper case. The text field has both letters and numbers (such as ph13301). On the report, I want it to display as PH13301. But when I employ the UCase() or UCase$() function, #Error? is printed instead of the...
  4. E

    Error Messages.

    And I've been wondering how to do this... Thanks, Tim!
  5. E

    Insert/Append Data to a Table

    I'm kinda new to Access, but you could put a DoCmd.RunSQL in an OnClick Event Procedure attached to your button. I actually am working on a db that will move records from one table to another on the click of a button. But in your case, you would just take the values of the text boxes and...
  6. E

    Table reference in VB Code

    Thanks, Not sure what the option does, but maybe I should start reading up on what some words mean. I fixed the typo too. Thanks a lot!
  7. E

    Table reference in VB Code

    Keep in mind, I'm trying to wing it here with limited resources. What I want to do is popup a message box saying there is no records if the table [Committed Data] is empty. But if there are records, then open the form "areyousure". When I click the Export button, nothing is happening...
  8. E

    Table reference in VB Code

    How does one reference a table in VB code/event procedure? What I want to do is have a Message Box popup when a button is clicked saying that there are no records if a certain table has no rows. (In a previous post, I mentioned that the form would be blank if the control source table had no...
  9. E

    Modal Pop-up Form Problem

    Still the same problem; the form is totally blank if there are no rows in the table. Thanks anyway, I'll just have to find another way to deal with this.
  10. E

    Modal Pop-up Form Problem

    I'm kinda new here, I've been getting into Access primarily for work, and have this database that I'm working to actually use as an export tool to automate some things in my department. I work with Access 97. Anyway, I have a form popup when my "export" button is clicked (through a macro)...
View older results
Back
Top Bottom