Search results

I recently moved some of my be tables to SharePoint to test is see if it is viable option for my be tables. So far everything is good except for one minor issue, I am getting the error "Data Type mismatch in criteria expression" when i try and filter the table or run a query. this only seems to...

Hello, I have a Main Form with a Sub-Form, the sub-form is base off a query. on the sub-form i have 8 controls, one of them is "Status' and "Process" and "Review" My Main Form have a Refresh command that refreshes the data in the sub-form. What i am trying to do is make the "Process" Control...

Hello everyone who reads this, I work for a bank and have built a workflow tool using access, i have a section where i have a start date/time and I need to add a certain amount of hours to that start date/time to give my users the due time for a loan. So our operation hours are 8 am to 5 pm...

I have a query based form i use to gather data to generate a report. I have 2 forms Form A is where users open all reports from. On form A i have 2 unbound fields "Report Start Date" and "Report End Date" my queries us these from Form A as the criteria for the queries. I have like 30 reports...

In my database i am building a totals report on each employee for a certain job they do, in the work for i have a start date and time and stop date and time, then i have a 3rd field that stores the calculated total time it took to do the work, it is a Short Time formated field. That all works...

In my DB that we use and a workflow tool, some of our work has and due date and time.If we get the complete_package our work time starts and we have X amount of time to complete our work. This is something i worked on but set it aside, now i am coming back to try and fine tune this so it returns...

I am trying to run a query that looks at data/time. The expression i have so far isn't working and i need some suggestions please. Use Date2: IIf(([Use Date]<"#03:00:00 PM#"),[Use Date]+1,[Use Date]) So what i need is for this to look at [Use Date] and if [Use Date] is before 03:00:00 PM then...

I am working on some report query's, i have 2 fields that i need to make one if 1 one of them is not null. Field 1 is: Date Sent Field 2 is: Date Unpended In my query i have this expression Use Date: IIf(IsNull([Date Unpended]),[Date Sent],[Date Unpended]) So what i mean by all this is the 3rd...

Hello This may be a long question but it is a very big part of my DB. If i am not clear i am sorry i am still learning VBA and have to get the full grasp on it. I work for a bank and have build a few little DB's for differant groups but my current project is a work flow tool for a department. I...

I have a form with a sub form based on a query, in one of the fields i use a dbl click to open another form. I have use this in several areas in my DB but i having issues in one section of it not opening to the correct record. i tried a few things but i am limited to what i can use. The...

Hello, So i am building a DB for my work and i am having alot of fun with it today and showing my geek/nerd side and putting a few sounds to give it some flair, however i think it might be a good idea if the users can mute the sounds. what i have is a module with my sounds and then call...

Hello, I have a form and a subform based off a query, I am trying to run a SQL update statment from one of the fields in my subform. I know what fields in my table i want to update but the Where part of the statment is what i am having a issue with. DoCmd.RunSQL "UPDATE [Daily Work] SET [Daily...

Hello everyone, I have looked though this site on many occaions and has been helpful in the past so i thought should be a part of it. Here is a little about me, i recevied my programming degree back in 2000 over the years i have taken several classes picking certs in networking, A+ , Server+ and...