Search results for query: *

Please can somebody help? I have used the code below to build a scroll bar. Could somebody tell me how to stop the text scrolling after twice viewing the message? I would like the text to completely disappear after it has scrolled twice. code: Private sub Form_Timer Static strMsg As String...

Please can somebody help? I have built a form and i only want the facility to edit the queries which are already held in the database. Basically i want to disable the option to create a new record. At the current time the user can click on the next button through the records and when at the...

Please can anyone help.... Hi im just building a new enquiry database which will be used by about 10 people, which will be stored upon a server. Each user that opens a database i would like a username/password to stop unathorised access to the database. Q1. What is the best way to create a...

I had designed a login and password facility for Access 97 which worked fine. However when ive recently copied it to Access 2000, im receiving an error message in the code....... Compile error: User defined type not defined The compiler stops at this piece of code: Dim dbCurrent As Database...

Hi im building a query logging database, which will be used by several people on a server. I have implemented the data capture form, and was wondering what would be the best way to search for previous records and make amendments. Due to concurrency issues i thought MS Access might have a few...

Please can somebody help me? I need to build a time counter in short-time with a button to stop and start the time. The time counter would count up from 00:00 up to say 99:59? Please can someone advise?

How do i keep the initial value in a combo box blank until one is selected from the list? I tried using the default option for e.g. "", but it only keeps it blank until you move on to the next record? Can you please help?

Hi, can somebody please help me. I have a enquiry form. on that form is a button, which allows supervisors to go to a password form, then choose a feature. When the supervisor has chose a feature a supervisor form opens, which contains some of the same fields as in the initial enquiry form...

On my first form i have used the maximize function. on openening my second form i have used the restore function due to the second form only being small. Unfortunately it restores the first form too! How do i stop this? p.s. i always want the first form to be open in a maximized state...

I have completed a password using the code below. However when a user inputs the password you can see what they are typing. I want it so it just shows ***** . Can somebody please help? Dim strPasswd strPasswd = InputBox("Enter Password", "Restricted Access") If strPasswd = "" Or strPasswd =...

I have got an orders database which contains a start time and an end time. I want to work out the average it takes each employee to complete an order. An employee may make several orders a day. The first step was completing the difference between the start time and the end time which i...

Does anyone know how to average two periods of time?

I have a number of different users, in the database. I also have a Start Time & a End Time Im using a short time format How would i go about averaging how long it takes each user to complete the task(record)?

I want to count the amount of records that have been delivered and not delivered in the same query. I have tried putting: no of queries delivered : isCleared Total: Count then in the criteria defining whether its true or false But it doesnt seem to recogise the fact whether is been delievered...

Unfortunately i keep on receiving this error message, can somebody help? "The microsoft jet database engine stopped because you and another user are attempting to change the same data at the same time"

Hi, im producing a user input search criteria. For the initial criteria i used the like operator: Like "*" & [parameter]& "*" However.. This does not return Null values in other fields For e.g. I have a custname field which always contains data I also have a...

Within a parameter query,i have many user input criterias. Im getting very confused so could somebody please explain: If a user entry is not made, then the records should display both null values and non null values. If a user entry is made then it should just display the records that match...

Please can somebody help me.......... i have created a new forms containing a number of fields relating to a specific table. These fields are being used as a search criteria. I also have a command button which opens up a query, and takes the user inputted information from the form. However if...

My first form (frmEnquiry) is a customer details form which contains a unique customer number called enqID. The text box which contains this number is called EnquiryID. My second form (tblCallB) is a separate independant customer check form which is related to the same table as the first...

My first form (frmEnquiry) is a customer details form which contains a unique customer number called enqID. The text box which contains this number is called EnquiryID. My second form (tblCallB) is a customer check form which is related to the same table. After completing the first form i...