I have an unbound textbox called "TxtDisplay".
I'm using Command buttons with the code
Command1
Me.TxtDisplay = Me.TxtDisplay & 1

I have a table, tbSamples, with a field UserID. when a new recorded is added
I would like to default the User ID of the person loged on, adding the record.
I have tried using; =CurrentUser() , this only returned Admin regardless of  
who was logged on.

Hello to all,
I have two tables called "Main and Employees" and I want to stop users from  
swapping employee names in existing records.
In other words: once an employee record is input into the Main table, don't

Where can I find a stable calender control instead of Microsoft Active X
that is reliable and royalty free.  Thank you in advance

I included a custom file menu and a toolbar with the print command, my
problem is that if I use Access standard menu "File-Print"  I get the
printer dialog box, but I can't get that with my custom file or tool bar
menu it will just print without asking what printer to use when ...

I have an Access table with an AutoNumber that I want to have a '0' value.
In SQL Server I can do an "Identity Insert" to override a column's Identity
(autonumber) property.
How can I do this in Access 2003.

I have a main form with a subform in it. I use the button wizard to generate
a save button to give save command for the subform. I put the button on my
main form but it doesn't work. The code in my Save button's On Click event is:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, ...

Can anyone please tell me what I have done wrong in this statement?  I have a
Form with a sub form on the sub form I want to limit the Blocks that show up
in a drop down form to the jobs that are assigned to Divisions.  I have a
table called jobs with the fields Block and ...

Can anyone tell me the correct code for closing all open forms using an event
procedure?

I have been given the task of administration of an MS-Access 97/2003
database.
The date field has ALL the dates of the year in black. I want the database
to identify weekend dates & display them in another color. I want the

I am trying to devlop an sql statement that gets the short description from a
table (routes) and updates the forms text field (Notes) with the value
displayed in the lstRoute listbox. I get an error on the docmd.runsql
statement.  Also, I am not sure that the Me.Notes statement ...

I am developing a data base for humanitarian projects that each can operate
in several countries and each country can have several projects.
Users enter data through a form that is based on the main tblProjects and
three sub-forms. One of the sub-forms handle the entry of project

how to mannage the application resolution according with user's screen
resolution?
application  include's  forms with tabcontrols

I wrote following code:
Private Sub Form_Current()
    If IsNull(Me!foto) = False Then
        Me![fotoken].Picture = Me![foto]

how can i create a table from a recordset in vba ?