Search results

Thank you CJ_London, It ended up working perfectly. I definitely have to learn more about the mod function.

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

That worked perfectly. As always your help/guidance is so very much appreciated. Thank you!!

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

Thank you so much theDBguy!! It worked perfectly.

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

Sure, It currently has no data, but here's the data structure.

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

Wow, Thanks that worked great!!!:D

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

You're right, I don't really want to build it like this. But i'm putting together a quick and dirty database for this office which will show the users an Industry name as a convienance while i build the final more comprehensive Database. Until i can get the additional tables,forms, query's and...

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

Nevermind, :D I got it to work.