Recent content by Compuboy

It has a problem with DAO.database. It says "User-defined type not defined

I'm using ACcess 2002. I have a big list box in my form. When a button is clicked, I want to somehow scroll through the whole list box index while outputting all the information to a report or a file. Anyone?? Some code would be nice since I'm pretty lost in VB. THANKS.

I have the SQL statement I Want to use to generate a query when in the form. Is there any way I can add a button to use this SQL statement to make a printable query??

What's a PK?

I tried that. And what that does is select the last item in the list. Since my listbox is ordered alphabetically...it would select the item that begins with Z even if the one I just entered begins with G or something like that. I want to know how to select the one that was just entered.

My DB is in Access 2002. HOW would I automatically select the lastest item in the listbox. For example, in my DB when a record is added it automatically goes into the list box, what code do I need to automatically highlight this record. (Replacing the code below) I've been using the following...

thanks. me.requery worked

My DB is in Access 2002. Right now my form displays information based on a Cord Blood Table. However, when a new sample is added into the table, it's information is not displayed in the form until the form is closed then opened again. When I look at the bottom of the form, the recordset size...

I have 2 radio buttons in my form. When the form is opened I want one of the radio buttons to be automatically selected. What code do I need to put under the Form_Open function.

My DB is in Access 2002. If I want to select records to a listbox that match a string EXACTLY it works when I use: SELECT [CORD Data Table2].[Cord Number] WHERE [CORD Data Table2].[CE Number] = Forms![cord data form]!CEsearchtext All items with that CE number will appear in the list box...

Thanks that helps a lot. but is there a function that is the opposite of IsNull...like Is not null or somethin??

My DB is in Access 2002. The problem now is I have a field called "CE number" that I want to either have a value in the form of (Input Mask: "CE"######? or null) First of all what exactly do I put into input mask? However, I've fiddled around with it a lot. My main problem is this... When "CE...

I want the listbox in my form to display 3 strings. How can I add these 3 strings to the listbox?? P.S. Don't thinkg Additem works for me...

MICROSOFT ACCESS The situation is: I have a listbox that lists cord blood ID #'s. When an item is selected from this list, information (such as Date, Type, etc.) are displayed in text boxes; this is taken directly from the table, I made it with a wizard. You can also select a date from the combo...

When I put this code in Form_Open: Me("ListBox").Selected(0) = True It does select the first item..however, after I cannot switch the selected item...everything just gets locked.