Search results

  1. T

    Solved Query no longer recognizes calculated field selected from a text box on a form

    I have a few queries that no longer seem to recognize the info selected from a text box on a form . Here is the way I had it set up. It's an append query to add the info to a table to be used later in a report. They worked well for over a year and suddenly this week when I run the query these...
  2. T

    Solved Report prints from RunReport command in Macro/turned into module

    I added a RunReport cmd to a macro I used to create the report from a button on a form. Recently when I had a problem with "duplicate previoud record" all my macros were converted to modules so code could be added to fix. I not too well verse in VBA and not sure why the report gets created but...
  3. T

    Solved Update Query question

    Can an update query be designed to perform a calculation on a table column(currency) then append that result to the same table in a new row that the becomes part of the total for that column. I want to sum the Customer Rate column then multiply by the 23% (FSC row) then append(or update) the...
  4. T

    Solved Sub Report data dissapears when trying to publish pdf or print

    I created a Report with a sub report using queries with parameters (one is a combo box for a name the other is a date range). The reports appear together when run and look great. When I try to export as a pdf or print locally the parameter boxes reappear and request input. Re-entering the...
  5. T

    How to Disable a button on a form

    Hello, Is there a way to disable a form button at a fixed time every day? I want to prevent multiple users from creating activity past 3:00 PM each day. Thanks JB
  6. T

    Daily file import timestamp shift

    :confused: I have a daily file to import. If I hard code the entire file name my code works. My problem is getting around the daily name change of the file. The owner has an automated process that creates the file so the name every day is slightly different due to the timestamp. Here's an...
  7. T

    Input box set focus

    I have a module that opens an Attachmate Session, then prompt the user for input to continue the logon process. The problem is the Input box opens behind the Attachmate window. Is there code to bring the Input box forward? Here's the part of the module that opens the Inputbox. when I step thru...
  8. T

    Append to Text File is wrong format

    I found this code that appends new data into an existing text file. But I need the format to be Tab Delimited instead of CSV. Any help would be greatly appreciated. Here is a sample. The first line was in the table. The second was appended. line 1 PR 08974 0008180 0836783 PIERCE 26 110 8540395...
  9. T

    Can you verify sorting order?

    In my table I have one column that lists part usage (number) in descending order. I have a second column with an auto number for ranking. So my highest used part ranks as number one. Is there any way to verify the sort order on my usage column is descending as my rank number increases? The...
  10. T

    Make Table Query Mis Sorts Numbers

    Hello, I have a simple make table query that occasionally mis sorts on a number column. SELECT Usage, Sell, [Service Unit Number], TechID, Current], INTO Rank FROM tblCombined_Final ORDER BY Usage DESC , Sell; The data type is double and I have the sort as descending...
Top Bottom