Recent content by sroot

That works like a charm. Thank you!

I have a query that i need to pull all records from Monday through today. I figured out how to do most of it. i tried this ">Date()-Weekday(Date()-2)" The problem i come across is when i try to run it on Monday it pulls from last Monday and i would like it to only pull today. Is there any way to...

Thanks for the help guys!

Hello everyone! i have a table in my database that is pulled from an automated excel sheet that gets pulled online for our supplies. The issue i have is that the table has each header as one of the supplies so it will have 6x6 box then it will have 8x8 box etc... and have the qtys under them. I...

Good morning! I am trying to get something done in a database and i am stuck on one part that i am hoping someone can help with. The part i am stuck on is basicly i have a form with 2 text boxes, they need to scan in the first and last work ticket into them and then dump anything in between the...

This is what i can use to make it work, but i don't want to have the date in there because then i have to change it every day... i would like to make it as easy as possible for everyone. I know i can use Date() instead of the actual date but then i can't figure out how to add 6:00 AM after it...

Hello everyone! I have a query that i am trying to use the datediff function to get the hours between one point of time and today at 6:00AM and also one that shows between the same point of time and tomorrow at 6:00AM. Having that 6AM is throwing it off and i can't seem to figure it out. Thanks...

You are correct... i cant believe i didn't think about that. Thank you so much!

I have an inputbox that a user needs to put in a date, but for some reason the date is not working, every date shows in the table as 12/30/1899... What am i doing wrong? Here is what i have. strDt = InputBox("Enter date of double") CurrentDb.Execute "INSERT INTO tblDate([TheDate]) VALUES(" &...

Thanks guys. I changed it to a DCount and it worked perfect. I just thought i could use a Dlookup since i did that with something else... not sure if that worked because it was numbers and this is text. But thanks for the help!

That is how i had it originally but i thought i had it wrong because when i do it that was it goes to the else part and tells me the code is not valid... so i am not sure why that isn't working

i only posted the line that is failing... the whole code is Private Sub Text4_AfterUpdate() If DLookup("loc_code", "SOSLOCS", "loc_code = Text4") Then Call DoCmd.OpenQuery("SOSAppend") DoCmd.RunSQL "DELETE * FROM SOSInput;" Me.Requery Call DoCmd.OpenQuery("SOSAppend") DoCmd.RunSQL "DELETE *...

I am having an issue using a Dlookup this is the line that it is failing on. If DLookup("loc_code", "SOSLOCS", "loc_code = Text4") ThenIt seems to be doing what i want if the code i put in doesn't match, but if it does match whats in the SOSLOCS query then it gives me a type mismatch error. Any...

yeah i have a ton of queries that use them. They are an automatic date and time field

They are both filled in