Search results

Wow, I didn't release how obvious that was. Thank you. Alright, everything is working now. What would be the best way to have the date be updated each day in the static table? I plan on making a form based on the table. The form would then have a macro that runs every time the button for the...

This was the issue. My bad. I have never made an append query before. It only makes 24 records at a time now. It also inserts the day. My last issue with this entire thing is this: How do I get it to insert the hours in each of the 24 new records? Another append query? How would this look in...

NOW WE'RE TALKING! I just made the append query and static table as you suggested. Everything is working as I want it to, the only problem is that when I ran the append query to test it, it made 600 new records instead of 24. It's as if it repeated itself 25 times and I definitely only clicked...

I apologize if this is horribly wrong, but as I was telling Gizmo, my coding skills are definitely lacking, extensively. I am fairly certain that I need an INSERT INTO statement in the DoCmd.RunSQL expression. However, I am a little unsure how to type the WHERE statement. Would it be "WHERE...

I believe that the 3rd video in that playlist (video 2) shows some code that is very close to what I want to do. However, I am pretty new to VBA and coding in general. It is very difficult for me to keep up with the video, especially when I can only see pieces of the code at a time. Is there a...

Thank you, Gizmo. I will begin watching that playlist shortly. Plog, I understand that Access is not Excel; however, we have a massive pile of separate files that we will never be able to easily compare/run reports on. This is a problem. We also need this standalone database done within the...

Hello, I currently have a continuous form in my database that has 24 records in it. every record is blank except for a time (I will post a screenshot) Our employees are instructed to enter various information every hour in this form. I am looking for help in coding a button that, when clicked...

That seems to have done the trick! So far, it does not look like it will cause any issues down the line. It is important that we keep track of what lines each line item is ran on so that we can go back and look and/or print a report on it in the future. After removing the controlsource from...

Hello, I have a form on my database called frmFloorRun in which a user inputs a line number on the main form, and then in the subform they enter what will be running on that line for that given day. Everything seems to work beautifully except that when a user clicks on a line other than line...

Thank you so much. Thankfully, we are a small company in the US so that solution works for us. I have tested various holidays/transit days/etc well into the year 2018 and everything seems to work perfectly. You have been an immense help! Cheers, Bryan

Edit: Originally, I thought your latest edition to the code made everything work perfectly; however, a co-worker has brought it to my attention that your code allows the scheduled ship date to fall on a holiday as defined by my holidays table. I would like it so that a scheduledshipdate can NOT...

Boy, that's embarrassing. I was positive that I changed that line of code when you posted it originally because you even said to. Obviously I did not change it like I thought I had. I changed it to the name of the transitdays control and it still works; however, it is still not bringing up the...

We are so very close to having exactly what I am asking for. I just have a question about your code In the line that says "ElseIf Weekday(tdate, vbSaturday) < 3 Then" What exactly does the < 3 mean? Does it mean that the minimum transit days MUST be 3? I wanted to get clarification on this...

Hopefully I uploaded this correctly. My cursor is in the control that I want the result to be in. It is called [txtScheduledShipDate] EDIT: It just occured to me that cursors do not appear when you use the print screen function. The control [txtScheduledShipDate] is directly to the right of the...

I could definitely be incorrect on this assumption, but I am going to speculate that part of my issue lies in the fact that I have 2 controls on the same form that I want to put OnGotFocus event procedures on. Everything in the form worked correctly before I pasted your code into it; however...

Hello Solo712, I am not knowledgeable enough in VBA to look at a function and see precisely what it is going to do; however, that definitely does look like what I am looking for! How exactly would I go about integrating this into my database? Ideally, I would like for it to run after a user...

All purchase orders include a due date. Our order entry person inputs this date. We want to have the database tell us the date that the order should ship based on two criteria: 1) number of days that it takes in transit to the customer and 2) the addition of holidays to the "transit" days if...

Are you looking for something like this? Input: DueDate: This value is entered by the end user in the [DueDate] control Transit Days: This value is specific to each customer and is automatically filled in via an event procedure when the user enters a value in the [DueDate] control Holidays...

The problem with that solution is that I am trying to get the "end date" to be automated. I only want the user to have to enter the DueDate on the PO. VBA would take care of everything else. In other words, it appears that your code needs 2 dates as an input, whereas I would like to only be...

Yes, everything you posted is correct. I have not attempted any VBA yet other than a module that I found online. It is along the same lines of what I am looking for; however, this module returns a number of days rather than a date. I believe that everything you asked for is in this file that I...