Search results

  1. T

    Calculate number of Weeks and days between dates

    I have an access query that contains two dates (Period Start, Period End) and I am looking to calculate/display the the total number of weeks and the remaining days, ex. (10/1/2020 thru 10/17/2020 = 2 weeks, 3 days). I have been able to calculate the weeks but it doesn't show the remaining days...
  2. T

    DLookup with If Else and error messages

    Looking for help with DLookup function VBA using If Else conditions. I have a form for adding new carriers to an existing carrier table. Because I know these users :banghead:, I would like for it to: 1. If the ID No. field is left blank - show an error message in an unbound text box. 2. If...
  3. T

    Report filtering by Logged in User

    I'm looking to filter a report according to the user that opens the report (by command button). I have setup in a data entry form for the DB to capture the logged in username and add it to each record (using a mod I found that uses Environ() ). I've created a report, now I would like for the...
  4. T

    Reassignment Update/Replace Query

    I was forced to reassign record numbers in one table to new record numbers and i'm now attempting to update/replace those numbers in another table (Table A). The table being updated (Table A), the record numbers can show up multiple times. I have another table with the Old record number...
  5. T

    Enter Multiple Records From One Form

    I am attempting to setup a database and need some assistance/direction in setting up a form that captures/enters multiple records from one form. We have batches of case files consisting of 25 folders each. I would like to setup the form where the user only has to enter the [User]...
  6. T

    DLookup Error

    Hello Everyone, I am trying to get this code to work and would like and suggestions. I have a form InvestigatorDE with an unbound text field named Industry and a bound textbox named IndustryCode were users enter the industry code. I also have another table named 2012IndustryCode which contains...
  7. T

    Populate value from value entered in another field

    Hello, I am wondering what would be the best approach to automatically populate the value of a field [Industry] in a table after a user has entered the value in another field [IndustryCode] in the same table. The [IndustryCode] and "Industry" are stored in a separated table...
  8. T

    Question Database that searches the values between two columns

    Hello, I'm new to Access programming. I am wondering if anyone can point me in the right direction to go. I want to setup an Archiving/Storage Database which contains data of boxes with folders in it. The data would be the box number, begining folder, ending folder and box description (See...
Top Bottom