Search results

Got it! Thanks Chris. I was getting a little frustrated over this one. Thanks Again Cindy

No I didn't. How/where do I set the key preview? What does the Key Preview setting do? Thanks Cindy

Helo Everyone, I need a little direction. I have an unbound field on a form where the text is formatted as white. I want to have the field switch to black when F10 is pressed. I need that event to happen from anywhere in the form. So I thought I could put the following code on the KeyDown...

Because my 'little application' is so convoluted I am concerned that making it available may make things more confusing. I had a thought to run by everyone. Would using a variable that is based on another hidden DLookup field, as the source of the display field work? Would I be able to...

Hello Everyone, I am still having trouble with this.... I am duplicating a production database for training so I need to mirror the original database (have no idea what the original was developed in) Anyway this is just a mock up for training purposes. The user enters an Appointment Number...

Hello There, I have records in an appointment table. Each appointment has a start time and end time. The person with the appointment must show up between these two times. I have a form where I have an unbound field that contains the current time - Now(). I need to compare the Now value to...

I am simulating an application for training purposes and it is the way the original application was developed. Plus the Combo box would be far too large due to the number of entries in the table.

Yes that is exactly what I am looking for. Thank You Cindy

Where can I find a listing of the ASCII values for Keyboard Keys/Keystrokes. I am attempting to use the KeyPress Event. I want to indicate If F10 is pressed then display a certain value in an unbound text box. For future reference though, i would like to get access to a listing if anyone...

I have an Unbound Form that has two text boxes, One called Appointment ID, the other Transaction Type. When the user Enters an Appointment ID, the Transaction Type automatically populates by way of the DLookup function. In some cases an appointment ID does not exist, thus no corresponding...

Thank you, I thought it had to do with defining variables, but the book I am reading has not stated that yet. Thank you again

Hello There, I am reading through Access 2000 VBA Handbook by Susann Novalis. I haven't yet been able to find an explanation for using DIM. Can someone shed some light on this for me. I've searched the Access Help and could not find anything. I am stumped. Thanks Cindy (new to Access)

Absolutely... Sorry about that, I didn't want to mislead you. I should have elaborated on composites.

Hi Cam, You need to implement a composite key in your booking details table. A composite key is a primary key consisting of two fields. What uniquely identifies your records is the date and the start time. You want to make both of these fields a Primary key. The system then makes sure the...

I've managed to get that far. What I am looking for is the coding that would say on Form A, in Field X if the value is 1 then open and populate FORM B upon pressing the TAB key, if the value is 2 open and populate FORM C upon pressing the TAB key, if the value is 3 then open and populate FORM D...

I have a situation where I have a table containing prebooked appointments. Each appointment is booked with a specific appointment type. I have a main form that you can input the appointment number, the company and some other details. When you input the appointment type I need a form that is...

Same Problem Michelle, Did you sort this out and if so, culd you pass along what you did. I am having the same problem. Thanks Cindy

Thanks that seemed to do the trick!

Hello, I have a form where you enter an ID for a container. There is another field where enter either 1 - for an Empty container or 2 - for a full container. If 1 is entered I need a new form for Empty containers to open. If 2 is entered I need a different form to opne for Full containers...

I did that, but I don't want the already entered records to display on the form. I always want it to appear blank after a record is entered or when you open the form. I seem to always see record number 1