I have written some code that works, but I need to have the form clear the
current record after printing the current record.  I was getting an error
message that said I was creating dupes, but was able to fix that by removing
the PK and having it indexed with duplicates okay.  ...

I want to populate a list box based on a selected parameter from another list
box.
I have been trying to do something like this in my OnClick routine of my
source listbox;

I want to create a control on a form that when characters are entered in the
field, the results have those characters in it.  For example, if we were to
type in “RTU”, it would be nice if the DB could list projects with that in
the project name or description, by client.

Good afternoon,
I don't know how to explain this well but here you go (and semi new to access)
The form selection which feed into a query to show what was selected on the
form  to play in the query. (that doesn't make sense but i don't know how to

I have this code for not editing these records; can you please tell me how I
can prevent the deletion of those records??
Private Sub Form_Current()
If Me!RecType = "fy08a" Then

Is there a calculation that is available for Listbox heights in relation to
Font Size and Weight?
For example if you have Ariel 12 pt, Bold Font and you want your listbox to
show 10 rows cleanly without cutting a row in half.

I put below code in my project :
   Debug.print Len(Me.Lot_no)
In immediate window,I found that
there are spaces on the front and

Can you please help me with the following:
1. VBA code to export the MS Office Clipboard data to text file. I can paste
the clipboard data into text file, then import into MS Access Table. But I
would like to automate the process. The clipboard data comes from a screen

I have an option group. I have checked to make sure they are in a group. When
I run the report the form comes up and I have 3 options "Due Date" "Work
Order Number" and "Part ID". I want the report to sort according to which
option is selected. I tested this and it works. The ...

My boss wants me to do the following:
I see a record of a firm
I update some fields of that record
I must send a report of all changed fields to his secretary.

I have a form that my users enter their Audits in. The Primary key is the
RECID field.
They enter a policy number and an effective date in this form as well.
What they want to happen is after they enter the policy number tab and enter

Dear All Access Expert
I maybe post this question to the wrong forum. It should has been posted to
somekind
like "TABLE" forum I guess, but I didn't find any.

I've used Allen Browne's Locking bound control codes
(http://allenbrowne.com/ser-56.html) to prevent overwriting data accidentally
within an Access form and it works perfectly.
Now, to make it slighly more difficult for certain users to edit this form,

Hi! I work in a large trucking company where I am trying to develop a simple
solution for printing dispatch sheets. These sheets have a few elements:
Trailer Location, Trailer %, Trailer #, Driver Name, Trailer Destination,
etc. These sheets are given to drivers to tell them ...

This is the first time I am using a subform (Access 2003).
Dim strText as String
strText = "whatever"
txtbxMemo.Value = strText