Search results

Hello I've never had to do this before and I'm not actually sure how to explain it but here goes. I have to create a query that will reflect the number of calls and messages a person has either taken during business hours and if a message was left how long did it take them to return the message...

Date Returned Date & Time Left 10/23/2014 10/23/2014 6:27:00 AM 10/23/2014 10/23/2014 7:28:00 AM 10/23/2014 10/23/2014 7:22:00 AM 10/23/2014 10/22/2014 10:42:00 AM 10/22/2014 10/22/2014 9:35:00 AM 10/22/2014 10/22/2014 9:20:00 AM the data type in [Date & Time Left] is Date/Time and the Data...

Hello I have to create a query in access that will calculate two Date and time fields [Date & Time Left]/ [Date Returned], need to figure out between the two fields. Trying to identify when the rep returned the call and the number of business hours (6:00am - 4:30pm) it takes to return a...

where statecategory starts is where the error message is, but I checked the spelling several times

Sorry forgot to post the error message Error message "compiler error - method or data member not found".

:confused:Hello I have a Lookup Table that updates a child table through on combo called MERCodes. What happens is the user picks a code such as 7ca or 3ca and it populates 2 two to three fields depending on which the code. I need to add two more colums to the lookup table so that it will...

hi all I have an access database with a main form which is the people_tbl and a subform which is called the TanfActivity_tbl and the childrens_tbl. The users and myself are unable to do a search in the subforms, is there some way I can make it so that the users can search fields in the subforms...

Hi all I am trying to figure out how recreate the CTRL+' function using the AutoKeys macro, or the OnKeyPress of the form. I know how to create a macro but I have never created an AutoKey. Can anyone assist?? Pls I did some research and it can be done through a macro Here is my situation, We...

yes it does its like ditto key that access supports but and ADP does not

apparently what the CTRL + ' Key does an Insert the data from the same field in the previous record CTRL+' its like a ditto key and I need to recreate or code it into a macro because the ADP I am using doesnt support it. adn I dont know how to create that??

Hi all I was wondering how do you create the Autokey Macro its the equivalant to CTRL+' hot key?? thank you

Hi guys, I have an ADP Access on the Front SQL on the back and I want to make it so that every time the users open the form to either enter data or look up a record, all the records dont load. How would I do that, cause with all the records loading it makes access run so much slower, takes too...

statsman Ok thank you I'll give that a try

Hi all I have a database with SQL server as the engine and Access 2003 on the front end (ADP). I am trying to filter reports, for example when a user Types in a TeamMember Number when looking up a record on a form I want them to be able to see the report of that team member also, this code will...

Nevermind figured it out

Does anyone know how to create a search for a subform, I got a one to many relational database with a child table linked to a main table the child table is displayed in a subform is there a way to create a search for it??

In the picture below you see a main form and a tabcontrol with two subforms on it, what I would like to do is make is so the users can search by First Name or Last Name which resides in the (Subject Subform). right now I'm using the Find And Replace command button microsoft provides but that...

this doesnt work in an adp file? how do you use this in sql [Forms]![Employee Dialgo Box]![cboEmployee]

I have a database that has access as the GUI with sql tables (sql engine). One of the tables is suppose to consist of hyperlinks, which lead to a pdf document. What I want to do is Link a hyperlink/document to the primary key, because the documents are the employee files and the primary key is...

Adam Thank you so much for helping me adam I sure do appreciate it. I need to donate to this forum its helped me alot in the past how can I go about doing that?? I'm going to be taking visual basic classes soon so I wont have to keep asking these questions. I've learned alot about databases...