I am having trouble trying to manually add a row to a list box. In all the help doco I can find it says to use the .AddItem method. Well there is a major...

i have an order form and a sub form for the order details ... i want the user to enter a product number in column 1 on the subform and in column 2 on the sub...

How can I open my access database automatically when Access is started. I have specified the folder where my database resides in...

This is one of my blind spots. I've three tables: tblCustomer, tblOrder and tblOrderDetails. I've joined tblCustomer and tblOrder on CustomerID and tblOrder...

Hello there, I'm using Access 2000 on windows xp. Is there a way to: 1) Table: Cancel the default value for number (I never want to default to zero) 2) Form:...

I need to do a query to display records where the qcdate field is within the past 5 work days. Does anyone have some ideas for me? I stuck good on...

I have this code on one form: Private Sub Owner_DblClick(Cancel As Integer) On Error GoTo Err_Owner_DblClick Dim lngOwner As Long If IsNull(Me!) Then Me!.Text...

I have a table that lists students and their subjects. All appears as text in the table and the associated query but turns into the corresponding number when...

I have a form which has a control bound to a hyperlink field in a table. I want to be able to click on the hyperlink and have it open a word document to a...

I'm drawing a blank on how to do this. I have a table (orderdetail)with order numbers and detail info. I have a query (ordernumberquery) which has the...

assume I have a table with a bunch of recorsd in it ... I have say 200 columns in the table. All fields/columns are null (as in vbNull)... except the 1st...

I have a database that has a linked .txt file in it. I have it pulling this text to populate the data fields in the database. This file is located on a server...

In a work database a module allows a series of calculation which produces a result of the number of hours worked, but I am unable to carry out any form of...

on an order processing form i need each order to be of all the same type of products - each product is of type 1, 2 or 3. i use a combo box to choose the...

I have had problems with word in my documents I am not able to cut ans past to transpher info from one file to anothe

Why, when I try to debug a private sub in Access 2000 do I get the error message "User Defined Type Not Found" on the line Dim dbD as DAO.Database Steve

on an order processing form i need each order to be of all the same type of products - each product is of type 1, 2 or 3. i use a combo box to choose the...

How do I use a Yes/No button on a form to set the Yes/No value of a specific record in a table? I've got several of these buttons which I'll need to place on...

hi i have a few users who use a split frontend / backend database in access 2000. the database is beginning to feel a little clunky and slow to...

I'm working on a record-keeping system for a traditional Chinese medicine practice and am trying to work out a way of recording the needle points used in each...