Search results

could you explain that in more detail, I am having a hard time understanding exactly how to go about this.

On my switchboard I have a place for people to enter a new client and it opens a intake form but it opens it to a existing client how can I make it so it only opens to a blank form for data entry???

I have a combo box in which you can select a client name and I have command buttons that go to forms but I want the form to go to the record of the name selected in the combo box how can I write a code for it to do that???

I realize that this is not the best way to managage our records but we are slowly trying to straigten this mess out and make it work properly but I really needed a quick fix for now and I really appricaite your help with that!!!

Okay if I wanted to flag it at a certain date how can I move it to the master table upon that date? But I don't really want to delete the information in the intake table but hide it per say??

Okay let me explain our tracking, when we get a new client we fill out a intake form, and we track these for production purposes, then when that client is actually approved to be a client we start tracking a whole bunch of other stuff that is not the intake form, see the intake form just gives...

Well some of the information is in the master table but alot of it isn't and we don't track that information right now so I didn't include it in the table. Is there an easier way to do this or should I just include all of the stuff on the intake form into the master table?

I have a intke table in which I have a intake form that we enter new clients on, but I also have another table which is the "master" table for all clients, now on the intake form there is only about 10 fields that need to be in the "master table" how can I make it so that these fields will...

thanks alot!! both helped!~

Rich, I have 2000, but I can save it as a report but I need all three forms on the same report because all of them are one client's information, it tells me to save them a three different reports?

Thanks!!How do you do that???

I have a date field in a form that puts in the current date, but when you re open the form at another time it puts that date in, how do I keep it from changing the date, I want the original date that it was first created to stay in there? is this possilbe???

I have a form that is several pages long because of the contents I had to make really 3 different forms and then I made a button to move to the next pages but it is really one persons record on all of these pages is there a way to make it print all of the forms for that person at the same time...

Thanks! I will try that and see if it helps!

It is not based on a query it is based on the table, but sometimes to go to a certain record you have to use the navigation buttons because the records do not a have a complete ID number and if you choose from the drop down menu it will not go to that specific record so you have to scroll to...

One of my data entry forms is not working correctly when I use the combo box the names are alphabatized and in order but when I try to use the record page forward on the botton of the form the records are out of order? In the table they are in order as well???

this happend when I replicated the database,do you think this created my problem??

yes, the forms work on their own, but not using the switchboard, I also tried to create a switchboard in design view and got a error access was not communicating with the OLE server or Active X control?

I am trying to run a switchboard off the switchboard manager and when I go to the form that I have on the switchboard it gives me a run time error 3021 no current record, but I have 1300 some records under that form, Please help have a deadline!!!!!

My check boxes in my form are not "checking" in the table. One of them is a "male", "female" check box but when you check it on the form it does not appear in the table. I have them set as yes/no in the table, am I doing something wrong? Molly