Hi Groupies
On September 18th I posted a question called "Fill next record based on
previous". The post was answered by Klatuu and said that I have a kit
inventory and that I need a subform and a query to use as the subforms

I've been stuck on this for almost a full day, the following select generates
an error number zero.
Dim  rs As New ADODB.Recordset
...

Private Sub cmdConfirm_Click()
Dim strMsg As String
If Me.cboApproval = "Approved" Then
strMsg = "Your meeting request has been approved." & (Chr(13))

I need some help with the syntax.
I have code like below. I want to find the record that has DWG#: in the
comment. I add the word Like and then the astrisk after DWG#: but those don't
seem to work. What would be the proper syntax?

I am creating a drawing request tool for my company. The drawing request
number will be the ID number of my record followed by a letter. The first
letter will be A and each revision will follow sequentially B..C..D and etc.
So if my record ID is 1000 the first drawing number will be ...

I'm maintaining an application that currently allows entry of new records or
updating exisiting records.
What would be involved in modifiying the application to allow multiple
windows to be open simultaneously. In other words, if the user is updating or

From the statement below, the first parameter of the function won't work as
I'm trying to put a space betwee lastname and firstname. However, it would
work without concatenating a space.
=DLookUp("[firstName] & " " &

I seem to be having problems with this post, so I am going to try
again.
I need help in coding a form so that the following can happen:
The scenario is that a user will open the form for the first time on

I have an interesting dillema.  I have a combo box in my for with 4 values
(A, B, C, D).  What I would like to do is if a user selects A, B or C, the
results pull from query A but if they select D, the results pull from query
B.  Is there a way to do this?  Thanks.

Hopefully, someone can help me with this.
I have a continuous form that has a check box in each record.  If the box is
checked, it means that the user is finished with that record.  I want the
BackStyle of only that record's controls to change to Transparent when the

I'm doing an import to an existing table from Excel.  When I do it
manually, it works. I get the message about key violations, but then select
'yes' to do it anyway.  
Running the same functon with the "TransferSpreadsheet" function with same

Hi Folks - getting brain fade here. Should be simple but guess I'm
over-complicating it!
I have a form with a list (subform table) of reports available to print or
preview etc. I have one button that takes the form name and saves it as a

I just can remember....How do you get rid of the windows close button on a
form? "X"  I want to force the user to use my exit button so that I can check
some fields.

I have an "enter data" form which is bounded to a table. When I enter
the new record for all textboxes, "enter data" form insert the data to
the table instantly, then move to the new record to be fill in.
What i need is to force the Access to focus on the recordset I already

I though this would be a simple fix, but I am stuck.  I have a date/time text
box that is used to filter with.  There is a format mask of 00/00/0000;  My
problem is that when the text box is clicked on, if the cursor is in the
middle of the format mask that is where you start ...