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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.