Search results

This seems really straight forward to me. I have 3 forms - FormA, FormB and FormC. When I open FormA the user inputs some information, when they tab to the last field, FormB opens (which I want to be invisible) and Form C opens. I've tried putting this coding on the Open event of FormB...

Hi Everyone, I will do my best to try and explain what I am trying to accomplish. I have a form that has two fields [NumbX] and [NumbY] They way they display on my form is [Numbx] of [NumbY]. These two field show which transaction of the total number of transactions. So basically if someone...

Hello Everyone, I have a main form for entering transactions. There are 2 fields which are transaction X of Y (X being one field, Y being the other so for example TRANSACTION "1" or "2") If Y is greater than 1, when the user finishes inputting all information on the subsequent forms and...

Hi There, I have a form with an unbound text box called TrkID. When the user double clicks in the TrkID text box, I want another form to open that contains a list box. From that list box the user makes a selection that will then populate TrkID on the original form. The user also needs the...

Hello, My odd situation is that I have a form, this form has some fields which default from a different form. I need the record to save with the default values before the user types anything into the form. I would like to save the information already contained in the form when the user tabs...

I have an unbound form (form A). Depnding what is input on form A another form will open. For this example Form B. Form B has a field called ContNbr that defaults with the value from a field on form A, this field on Form B can be overwritten/changed by the user. Within Form B is a subform...

I have a form where I need to populate an unbound box with values from a table, based on an entry in a textbox on that form. As well the entry in the textbox populates a different table: Tables: tblDataInput & tblCont My form is a data entry form based on tblDataInput. The user will input a...

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...

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...

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...

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)

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...

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...

Hello, I need to create a blank form that is soley for input. It will update a table. My issue is that I do not want the form to display any of the existing records in the table. i just want a blank form for capturing data. Any thoughts on how to do this? Thanks Cindy

Hi There, I am trying to create a form that has a text box. I want to be able to input a value into that text box and have it lookup whether that ID exists in my table. If it does I would like it to open a form that is populated with that ID and relevant information. If the ID does not...

Hello, I have a report that displays invoices/bills. Each page breaks on customer, so 1 page per customer. (In my instance I have 42 customers and 42 pages in my report) When I export this report it created 42 HTML documents, which is great, exactly what I need. Now the naming of the reports...

I have a databse built to use as a survey tool. The survey is to remain annoymous so I have built an ID table with some random id numbers that will be distributed in envelopes. I have tables built on areas and in those tables I have the various questions and ratings built in. I have a query...

I have two tables where I would like to subtract field values in one table from field values in another table. Once the calculation is done, I want to take the result and perform another calculation on them EG: Answer =[TABLE1]Field A - [TABLE2]Field A Answer2 = Answer X 1.5 Does anybody...

I am using Access 2000 I need to subtract fields in one table from fields in a completely different table. Once each of these pairs of fields in different tables are calculated, I need to take the sum of each pair and multiply each of them by different values. Does anyone know how I would go...