Search results

Hi Does anyone know if it's possible to show the results of a query on a form? I have 4 people entering various "outcomes" into a table. There are a possible 8 different outcomes and the one i'm interested in is the "completed" outcome. I would like to be able to show on the form used to enter...

Hi I have a table in sql holding telephone data. the starttime column and endtime column are both in "10/05/2006 12:55:56" format. I want to run a parameter query that lets me search by agent name and then by date. The agent name is no problem but when running parameter query by date it brings...

Hi I have a simple select query that pulls data from a table in a sql db. the query shows all records for "agent1". if agent1 has made numerous entrys it shows all of them how can i get it to just show the total of all entries? i've tried selecting the sum option in query design but it says...

Hi I want to be able to run a query within access that lets me chose "agent" and a specific date or a range of dates. I have a table with "starttime", "endtime", "agent", "phonenumb" and a datediff calculation that calculates the diff between "starttime" and "endtime" the "starttime" and...

Hi I have a table with "starttime", "endtime", "agent", "phonenumb" and a datediff calculation that calculates the diff between "starttime" and "endtime" the "starttime" and "endtime" columns are in "10/05/2006 12:57:55" format, i.e. the column holds both the date and time The data is stored...

Hi I have a table with "starttime", "endtime", "agent", "phonenumb" and a datediff calculation that calculates the diff between "starttime" and "endtime" the "starttime" and "endtime" columns are in "10/05/2006 12:57:55" format, i.e. the column holds both the date and time The data is stored...

Hi Does anyone know a basic and quick way to write to a table in a database using a web page instead of a form? the webpage is stored locally as is the database Thanks Ben

Hi I've got a table that stores information from my telephone system. there are a couple of columns that contain times of when a call started and when it finished. the format is 17:11:30 for both the start and end times. i have added another column and in here i want to have the call duration...

Hi I have a database which uses the auto dial function. when someone hits the dial button the date and time of that "click" is logged in a table and basically shows when the record was called. does anyone know of a way to log the username (i.e. windows login) of the person who is logged into...

Hi I have a form where data is entered and outcomes are entered. Any ideas how i can make the outcome field mandatory before someone moves on to the next record? Thanks Ben

Hi I have a set of data in a table that is full of dupes, anyone know a simple De-Dupe Query? Ideally by phone number Thanks Ben

Hi I have a DB where I take orders throughout the day and the time is stored in hh:mm:ss format. Anyone know of a query that I can run that will show me how many oders between certain time? I.e. between 18:00:00 and 18:59:59 Thank you if you can help me!! Ben

Hi I have a DB where I take orders throughout the day and the time is stored in hh:mm:ss format. Anyone know of a query that I can run that will show me how many oders between certain time? I.e. between 18:00:00 and 18:59:59 Thank you if you can help me!! Ben

Hi I've got a a table that contain URL's. On the form i'm displaying the URL as a hyperlink but when i click on the link it does not open a browser. Any ideas? Ben

Hi I have a command button which dials a phone number via the PC. When i cick this button the date and time are written to a table. Private Sub Call_Me_Click() Lsd.Value = Date Ltc.Value = Time Logged.Value = GetUserName On Error GoTo Err_Call_Me_Click Does anyone know how i can get the user...

Hi, hope someone can help! I have a macro written that when clicked on it opens a web browser. Is there a way this can then point to a specific website url? I could make the default url in the browser point to a url but each time i click on the macro button the url needs to be different. all of...

Hi, hope someone can help! I have a macro written that when clicked on it opens a web browser. Is there a way this can then point to a specific website url? I could make the default url in the browser point to a url but each time i click on the macro button the url needs to be different. all of...

Hi I have a form which displays which products are on sale but I want it to count stcok orders down, i.e. if there are 10 stock and someone orders 1 I want the system to automatically recognise that there are only now 9 in stock, any ideas? Help really would be appreciated! Thanks B

Can anyone help?!? I need desperately to display a web page in a form but when i insert the browser i cant find where to put the URL in order to display the webpage..........!!?!?! HELP!!?!:confused: Ben

Hi I can insert a web browser as an ActiveX control however when i view the form in form view no page is displayed. anyone know how i can view the website within a form? Thanks Ben