Search results

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

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

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

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(" &...

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

Im thinking i have been looking at the computer too long today... I keep getting runtime error 3061 when i open this report. I didnt build this but i was told it use to work. Any thoughts? Thanks in advance! Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer)...

I have a form that a user has to type in a number in a text box. The number has to be 12 or 14 digits, so is there any way that if it is anything but 12 or 14 that a message box pops up and tells them to check the number and re-enter it? Thanks for any help!!!

I have a query that i can type in an item number and it Sums all the locations and tells me how many i have in the building. If i do not have any in the building then there is no record of it in the table and comes back blank. How do i make it show a show 0 instead of blank if there is no...

Maybe someone out here can help. I do not know if it is possible but i figured the geniuses out here would know better than me! I have a database that gathers data and the user has to type all of it in excel for the current date... Is there any code i can get to export the info from the table to...

Hi Guys. I have this module that works great. all it does is tell me if whatever Microsoft office program is open. The problem i get is that when i add the reference Microsoft outlook 14.0 object library i get a compile error "ByRef argument type mismatch" How can i fix this? Thanks! Option...

I have this code here that sends an email out with all the needed info. The problem i ran into was that for my field "item" it is in a table called "test" and there can be more than one record in there. I just can't get it to loop and show me all of the records. Right now it shows me only the...

Hi guys. I have a database that pulls information from a query puts it in a form and then emails it to whoever needs it. everything works fine on it except i cannot get it to work with a continuous form. it only emails the top row. I cant figure out what to do to make it pull all the records...

Hello. I have a form that users put in information and then it updates to a table. It works fine but i would like to add something. Right now there is a text box called item that the user puts in the item number. The problem is that sometimes they put in a wrong number. What i would like to do...

I have a simple database that a user records the work they have done for the day. They are required to fill out the form with the item number, date, qty etc... the problem is some people are fat fingering things and i am not getting the right item numbers... I have a table called dbo_item with...

Hello. I have to do something and i am not sure if it can even be done. i have 2 tables that i need to get information from. from table one i have a list of dates and i need to get the next available date from table 2... so if table 1 has 5/17/2014 19:47 and the closest date on table 2 is...

I have a report that prints off a bar-code for the user to be able to scan it to the system. It works great except one issue the bar-code has to be 9 digits long (a R followed by 8 numbers) the problem is that the user types in whatever number they have, it could be 8 or it could be 7. I need to...

I have a database that shows how many minutes pass between an employees scans works well... the problem is that they can start multiple ones at the same time. So i need the table to sort by the start and stop times so it can accurately measure the gap between scan times. Any thoughts on what...

I have a database that a user puts in the information in a form and it exports to an excel sheet. The problem is i am using the DoCmd.transferspreadsheet to put the contents on the table to the excel sheet, i just do not want it to overwrite the data in there already. I need like a running...

I have a database that has a lot of queries that require a parameter to run... The problem is that if you sort it at all from the datasheet it will make you put in the parameter twice. This database is used by a lot of people so there is no use in going in and clearing out the sorts since it...