Hi, I have a table with a field called CUST_ACN that is set to text. The
numbers contain leading zeros, like this: 000000001401. Now, what is the best
way to remove those leading zeros when I create and run a simple query?
Thanks.

How can I sort address by street name, not by house number?

I have a small database for my church..my fields are
birthmonth,birthday,lastname,firstname,& suffix....now i need to change my
birthmonth field,which is text, to date/time, to sort birthdays from january
1 to december 31st...i cannot remember how to change the field

I am seeking to change my unique Autonumber field to a Text field that
automatically generates a unique, six-letter alphanumeric sequence, such as:
Y3D8RK
H6GJ9P

I need to automate a specific routine at a specific time, I have found the
following article for excel
http://www.cpearson.com/excel/OnTime.aspx
But I need to run this from Access, I havent tried the Win API version yet

Hi, hope to get some views on this.
If I have a table representing an entity and that entity has 9 attributes
(eg, regions of the county where the entity operates) I would add 9 boolean
region fields.

Hai to every one,
  here is my question
          I have been designed a coding to accept the information from the
user

I'm using the following code to combine four fields.  It works fine.  My
problem is when all the fields are blank I get #Error on the report for that
record.  What I would like when all fields are blank is "NA" to be placed.
Thanks.

I use a make table query and would like to transfer the defaults to the new
table.
Is this a brick wall? Anyway round it would be welcome!

I have a report I currently open with the following code:
DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria
I have added the following line to save this file as a snapshot:
DoCmd.OutputTo acOutputReport, stDocName, "Snapshot Format", _

I have a form with a listbox (lstNames) and a button (btnEdit) to edit name.
This button is disable when form is open to prevent use opening the
frmEditName unless user select a name in the lsitbox (lstNames). I want to
enable the button when the listbox is clicked/selected. How ...

Is it possible to add a line of code to a report that will print a solid line
if a given condition is met?  I have a detail section of a report with the
following fields:  Info and Comments.  The Info and Comments are connected to
a selected category.  Each category has a ...

I have a table that has dates that have been entered as follows:
10-28-07. The field is formatted as a text field. I need to convert
the dates to date format 10/28/07. I have tried using DateSerial in an
update query but am having trouble getting it to work.

Hi.. I would like to create a msgbox with personalized buttons. On the manual
i just can find the VBA commands like VBOkCancel, VBOk, VBYesNo.. I would
like my msgbox to have two buttons, the first one "Ok" and the second "Sair"
(Quit in portuguese). Then i will program the ...

I want to make a form where I select from a dropdown in one field, and other
fields will populate with information from the record that I select. So, if
field 1 has me do a pulldown of names from a table, and I select a name, I
want the other fields to show me corresponding info ...