Search results for query: *

Hi, I created a form for use with data entry. It is in Tabular format. Is it possible to create the form in tabular mode that allows for data entry? The problem I am having now is that when a user is trying to enter data and tab from one field to the next, the cursor moves from the record that...

Hi, I have a db with the requirement of having to multiply time...can this be done via an Access query without too much hassle?

Hi again... This should be an easy one. How do you execute a query from inside another query using the GUI of Design View?

Hello All, I have a question about breaking a number out of a text string and then running a sum of that number. I know how to break out the numeric data, but I'm uncertain how to run a calc on it as it is still in a datatype of text. Can you help?

Hello, I am trying to create a report which lists volunteers and their transactions across a speicified date range. My goal is to provide a sum of all volunteers during that timeframe. I have tried Count(ID) but it counts every transaction. I need a way to count DISTINCT folks...evidently...

Hello, I am wondering how to allow a summary of time on a report. I have a field in my query which calculates the minutes, but I can't seem to get the formatting or syntax right on the report. What I would like is for the elapsed minutes to be displayed in the report footer in days, hours and...

Hi, I have imported a file from excel which has a field "Avg_Time" which contains an amount of time it takes to drive to a destination. The Avg_Time field was imported as a Date/Time field. When the data was in excel, all was peachy with the appropriate data that represented the time it took...

Hello All, The questions are: Can a person run an apend query from an after update event using values that are supplied by unbound textboxes on the form? If so how? TIA

Hello, I have a form that contains a combo box which auto fills 3 other text boxes. My question is how do I update a table from the fields that the combo box supplies? Also how do I rememdy adding a new record and having the combo box 'reset' the fields to blank when a new record is added? The...

Hello, I've just got my very first DAP (data access page) up and tentively going (access 2003)..it works just great if I am at work, but when I try to enter in data remotely I am having an error -- Microsoft Office Web Components could not open database "databasename"-- Would anyone know why...

Hello All, I am working with a Data Access Page in Access 2003 and am finding that I cannot add or delete any records due to the recordset being read-only...any suggestions on how to rememdy this? TIA

Hello all, I have a form that is to have the names, addresses, phone numbers and email addresses plus a couple of other fields for 11 people. Now, you can imagine this takes up a great deal of space on the form with all it's textboxes and labels. I decided one way to cure this ailment would be...

Hello, I know there should -probably is??- a way a person can automate report generation in MS Access 2003 without too much hassle, but exactly how is a bit beyond me. Is there a way I can either concatenate the reports or have them run in a batch? Anyone? Thank you ......