I have an unbound form and an unbound text box (Text43)
on the form.
I've created a UNION query (5/10/2008_Query) that works on it's
own, but when I try and use the SQL to populate the text box

In Form design view, I can see all my fields. In Regular view, I can see only
half. The lower half of the screen is bare, although I can see the top of a
label sticking out. Coincidentally (or not) there is a horizontal line at
about the same place as the labels become hidden. ...

I have carriage returns that used to show up in Excel, but now show up
as vertical bars or boxes in Access. How do I find out what ASCII code
goes with those boxes, so I can do a REPLACE?
Thanks,

access 2007 table reset autonumber:
I found a document on this with the microsoft article ID (812718) but it is
not detailed enough because I am doing something and/or missing something.
Anybody have a better solution for this in 2007 access ?

How can I have a Command Button to execute all the code I wrote in a form?

database design is a follows
tbl.personaldetails - stores clients details indexed on unique field ccode
tbl.personaladdress - stores addresses each address has unique field ID
tbl.personaladdlink - stores ID and Ccode and whether current or previous

We have a database that is pretty populated and the client wants us to add
data from one column into another.  We were looking for a quick cut and paste
method where we can select multiple fields and copy i.e. Excel but we can't
seem to find that option. We can only select one field ...

I have a form in which users will enter the document type (selected from a
combo box) and the initiation date (only the year is necessary but right now
the field is formatted as a general date).  Based off of these two things I
need to assign a sequential number that for a record ID ...

I have the following code assigning a unique number based on the record type:
Private Sub Combo4_AfterUpdate()
Me.Type = Me.Combo4
Me.ID = Nz(DMax("[ID]", "Table1", "[Type] = """ & Me.Combo4 & """"), 0) + 1

Good morning!
Can more than one user make updates (or new entries) into a database at the
same time and each one save his work (the db is on a network).
Thanks!

i am doing a project here and i need to define some words that has to do with
Access. so, i was wondering, what does labelling a report meand and how do
you perform it?

What if you could recapture your ex lovers mind, heart and
soul?...Wipe the slate clean? Turn back time? Even if you feel right
now that your situation is too far gone…too screwed up …or just plain
too darn complicated?

How to open a record in a subform, starting in another form.
The following procedure opens a form B (frm02_Aanvragers) on a specific
record.
The procedure is started on form A (frm01_Vrijwilligers)

I want to subtract values of two different fields. I tried to do calculations
similar to excel by typing '=' followed by add or subtract. But it is not
working. How to solve in access.
Krishna

I have Inventory Table having one of the field as Product Code.
'Product code' field has 10 charectors whose 5th & 6th Charectors show
the type of the product.
How  to select records having the 5th & 6th Charectors as G and A?