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

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

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

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

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

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

is there a way to get access to automatically assign a folder or link a folder to an index field (primary key). The reason I am asking is because there is a form with hyperlinks these hyperlinks lead to a pdf document which I create manually and is incased in a folder. Each folder is named...

Hi everyone I have 3 tables (SQL table) one is the employees table and the other two are link tables for documents the tables have a one to many relationship. everything is running smoothly accept in my in my access form (which is the gui for my users) I can get the field names to look like a...

Hi everyone I have 3 tables (SQL table) one is the employees table and the other two are link tables for documents the tables have a one to many relationship. everything is running smoothly accept in my in my access form (which is the gui for my users) I can get the field names to look like a...

I have this in a query so it will calculate ("=DateSerial(Year([FIRSTRENEWALDATE])+2,Month([FIRSTRENEWALDATE]),Day([FIRSTRENEWALDATE]))" its there to calculate the dates for me so I know when to renew. The only problem is its an expression so if its null on the form I cant edit it, just shows...

I have a form that has a subform that has dates in each field each date is in correlation to the Final Date if the final date says 1/31/2000 then the renewal dates should say 1/31/2002 then the second one should say 1/31/2004. What this means is that an employee must renew every 2 years. what...

My users are wanting me to create a form that they can scan documents to and store in the database. I was wonder how I can scan them in pdf format and how to make the scanner scan the documents to the form. I dont have alot of experience with VB took some classes but I am by no means an expert...

Hello all I was wondering if it is possible to make Electronic receipts clients had to acknowledge fill out online and send back. See I have a user in my department who works with vendors. What he does is he mails out vendor licensing packages and renewal packages he sends them certified...

I am trying to get my scanner to automatically scan to my form in my database called documents, I was trying through a macro by run application, that gets me to the scanner but the scanner wont scan to the form when I hit the scan to button. HELP PLEASE????????/