Wow thanks theDBguy, tried it immediately and it worked exactly as expected. However, it highlighted and issue with my previous week code. My code is calculating 10 days as 2 weeks and 4 days as 1 week for some reason.
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...
I'm sorry, I can't wrap my brain around where the IIF statement would go. I've tried adding it around the code you provided me, i've tried it around the Nz(Me.AddCarrierNo), 0) and I get errors either way.
Hey theDBguy, thank you for your help again. It appears when I try to enter information for a new carrier (one not currently in the table) a new Carrier ID No. is giving me the "Please enter Carrier No" error. I wanted that error to only show if the user left the filed blank.
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...
Great!! Thank you Gasman, Thank you theDBguy!! I knew I was over complicating it and that it was something that simple. After trying it a couple times I thought it didn't work, then I saw a ton of stuff on my printer. LOL So I played around with it a little bit to display the report how I want...
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...
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...
I created the form layout in the first pic believing that that might be the most efficient way for a user to enter in multiple case files without having to reenter the batch details over and over again. i am completely open to any alternative methods that would produce an efficient outcome...
You're right, i didn't think about just making the existing autonumber ID field as the unique id for the batches. I also forgot to change the data type for the FileGroupID in the CaseFile Tbl to number.
After those changes, how would i get the 25 different case file numbers to create new...
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]...