Recent content by desireemm

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