Search results

Hello, Hoping someone will help me with my problem. I have a small Tickler Access Database just to keep track of customers and follow-ups on different things. I need to create a Due Date from the [Last Date] and then another field which will contain number of days [Days] that they want the...

Hello, Our Access 2016 Database Option sometimes changes for no apparent reason. I have a navigation panel that is set in options to open with a form when a user opens the Database, I have it set on a tabbed view, and all my objects show. Occasionally, upon opening the Database, the user no...

Hello, I was just wondering if anyone could offer any guidance on working remotely and using 2016 Access Databases that are on our Company Network. I have a front-end on my local drive and the back-end is on a network folder as there are a few of that use the Database. It is extremely slow and...

Hello, I am trying to calculate the business hours between two dates (that include the date and time) in a query. I did research on line and found some code that others said worked, but I am not getting the same results and not sure why--it seems to work on some dates but not others...

Hello, In Access, I have a table called tblMonarchPerformance that contains a Start Date and Finish Date…I have them set to the General Date Format which is supposed to include the time (or so I thought), yet the time does not display, all I see is the date. I have a query based on...

Hello, This is a question as to how difficult something would be for a person like myself who does not know code well but has tweaked code to use in my Databases with the help of you folks here. The task is: Taking multiple Excel Spreadsheets (and the number of files will be different...

Hello, I hope someone can help me, I have an Open Response table with records that I need removed based on the Closed Response table - they both share the OpenRespID. I would like to use a delete query so I pulled in the tblOpenResponses, and the tblClosedResponses and joined on OpenRespID...

Hello, I have been searching for awhile and can't quite make this work for me. Would anyone have an idea why. And before I go on, everything I have read says to put the code on the Form's "Before Update" event but I have Audit Trail code there and can't seem to add additional code or maybe I...

Hello, I need some help please. I have a Access 2010 Tracking DB which contains a tracking form which a user can input data regarding an exam and there is a combo box which lists manager's names and stores that ID in the table, so the manager comes in and approves what the user put in--they...

Hello, I tried to find something on this but could not locate it. I have a PTO Database and a form in which a user searches for the employee name (Main form) and then a Sub-Form which is tied to the PTO table and allows the user to enter the date of PTO for that Employee-the forms are joined...

Hello, I have a Database which is split and both the front-end and back-end are on the shared network, which I have found does not improve the speed at all of the front-end. I have done some reading on this and it says that the front-end database files should be installed on each user's PC…and...

Hello, I have an input form in Access 2010 and I would like to put data validation on a few of the date fields (at form level). This form use to be in Excel. I am in Design view of the form, in the Properties of the field, Validation Rule. I have tried several attempts but it is not working...

Hello, I have created a lookup table before but with a Yes-No box and it works great but am having a difficult time trying to recreate this for another field and have no idea what I am doing wrong and would be grateful for any help. I have a form for input and feeds directly into my...

Hello, I am trying to use the code I found here in the forum to calculate an existing date and adding a number of days to get the new business date...I have a query in which I am using the field "DateARAgingRcvd" (which is a date field) and adding 10 to get the new date which would be...

Hello, I apologize for asking this question as I am sure it is very basic but I am trying to figure out what it is doing...I am looking at a query and in that we are pulling in the "Audit Due Date" field and in the criteria for that field, it says "Between Date() and Date() +30"... the query...

Hello, I have a query in which I saved in PivotTable View because that is how the person wants to see the data. In the query, it has a date prompt in which one can type in a date range and it will give the data within those dates. Works perfect for what I need. Then I read how you can put a...

Hello, I wasn't sure if this was possible and I did try but could not figure it out. I need to figure out the amount of days between two dates that do not exist in my database...I use this calculation to do waivers...I was able to build a table and put in the two dates and then build a query...

Hello, I am sure this is simple but I just can't get it and I have tried...I also did look through the threads here but did not seem to find anything on this so what I am trying to do is this...In my query, I have a field that is giving me the number of business days between a period of time...

Hello, I have a query in which some of the field names were assigned a while back and don't make a lot of sense to the person who gets the report so I give them new labels in the query...for example: I pull in the field AE_resp_req and in front of that I type in RM Response: AE_resp_req and...

Hello, I have two questions, both the same query… I need a date prompt and null records in the same line of criteria so I get all those within a certain date range under the field “CO_resp_rcvd” and those that didn’t respond yet but need to -- is that possible to do both and if so how would...