Search results for query: *

I know how to define a default in the form properties but I cant seem to set it on the fly. any advice? Justin

How do you set the default value? Where is the best place to find information on Comboboxes?

I am using a listbox to jump from record to record based on list of dates. However I want to add a few other features that I cant seem to figure out. When A date is updated how can I update the listbox and have the proper date selected in the listbox? Also I would like that when a new...

But How can I show check box information from previous visits?

Sorry for the late response, I actually got to go away on vacation. The check box information is for drugs and symptoms of patients. This past information is more a convinience for the nurses inputing the data so they can see what meds the patient was on last time. Everytime a patient comes...

Where would I be using this select statement? I know I could use it as a listbox but what about checkboxes? Would I use default value? Or is there another way? Thanks to everyone who has helped me. Hubbard

What about for check boxes? IS there a way to use a query for them as well? For the Last(Ht) will that make sure that the last height is from the same patient? Thanks for all the suggestions. Any others would be highly appreciated. Hubs

I do not know if this is possible but I thought I would ask if anyone had any idea how to do it. We are tracking weight and heights of patients and I was hoping to show the previous entries' height and weight in a locked field. Is there anyway to show other record's information? OR and...

>Using the form for data entry, allow the users to type the >00/00 format you want into an unbound field and then convert >and store this into the date field you want to record the >data into. This is what I'm struggling to figure out. I do not have the user adding/editing the data in the...

Its just frustrating because I know it has the ability to do this (Enter mm/yy only). And at one point I had it working but something goofed and I cannot replicate what I had done previously or it is because of another intervening element(link or form) that this has stopped working? Its doesnt...

But if i enter 8/02 it is translated into 08/02/2004 instead of making it 08/../2002 like i'm hoping. I dont care if it has to make it 08/01/02 for 08/02 but I was hoping there was an easy way to automatically do this for me so I could type in 0802 and have it enter 08/01/02 for the date...

I'm trying to set up a field which only takes in only the month and year. I tried setting the data type to "Date", the Format to "m/yy" and the input mask to "00/00;;_" When i enter data into this i.e. 01/01 it records it as 01/01/04. Any ideas what I'm doing wrong? Thanks for all your help.

To The Top Please

Any other suggestions out there?

OK so a memo field is Definitely just a pointer and will not slow down this particular table? By consolidating I would hopefully be gaining speed since not every entry in all the different tables will have an actual memo and I would rather just have a common memo table if it means the DB will...

I have a database with 7000+ entries that unfortuantely I inherited and it basically is a flat file (on Access). I am migrating this data into a more traditional relational database setup (on access). The flat file dabase has 1 table with ~100 fields and I'm splitting that up into 10+ tables...

I have a database with 7000+ entries that unfortuantely I inherited and it basically is a flat file (on Access). I am migrating this data into a more traditional relational database setup (on access). The flat file dabase has 1 table with ~100 fields and I'm splitting that up into 10+ tables...