This is my VBA for pasword in the textbox, How can I make it expires in 15
days after they 1st run it in their computer.
Private Sub txtPassword_AfterUpdate()
If Me.txtPassword = "hfs1754" Then

Beside the code can not be changed, is it that DATASHEET VIEW is disabled?,
I find mine that I can not see it in datasheetview. I want it be able to see
in Datasheet View.
Thanks for your enlighting.

I know that each control on a form/report has to be unique, but do they have
to be unique to the whole .mdb project? I haven't encountered any problems
with a Customers form where I can use txtCustomerId, txtFirstName,
txtLastName, and etc. I do, however, have my fields in the ...

I have a form with a subform that also contains a subform.  The Data Entry
property for each is set to No.  I would like to prevent users from updating
records on each form, but I would also like to allow them to create new
records on each form.  To achieve this, I set the Allow ...

In a combo box designed to find records in a query, the data in the 2nd, 3rd,
4th and sometimes 5th colum does not appear when I click on the down arrow of
the combo box.  The first colum generally appears with the ID numbers as it
should. In other parts of my form, it works ...

Ready?
I have an Access database (2000 format running on 2007) connecting through
an ODBC to PostgreSQL. Postgres queries are very particular i.e. case
sensitive. Now that we have that out of the way...here is the problem.

I would like to insert the Date and Time, but when I test this code it
insert only date.
How it is possible to insert in the same filed date + time ?
DoCmd.RunSQL "INSERT INTO Tillgangar ( Anvand, now, Mobiltelefon ) SELECT 1,

Hi, I have a form which contains a text box, when you enter a number in this
text box it displays the results in a another text box below, because it is
looking up the values in a table.  I need to set a validation rule so that
the user must enter at least 000000 before tabbing ...

Below is the code I am using to open a report based on criteria from
three comboboxes.  The problem is that the report errors as the
WhereCondition is wrong.  Here is the code:
Private Sub btnJC_OpenFull_Click()

I have a form with filtered records. What VBA code/ option can I create a
command button to export the filtered records to MS Excel? I tried the button
wizard, but did not see any option to export data. Thanks

From a "menu" users can choose the region they work. A form opens and
filters records for that region from a table which contains all the regions.
There can be several people pulling records from this main table but
different regions. Once they have done the work needed for each ...

Can someone tell me what's wrong with this code. First it works, then it
stops working.
I have 4 unbound boxes on a form. Dodaac, Supply Chain, Start Date and End
Date. It's the date I'm having a problem with.

I have a number of forms that are displayed one at a time. I need to display
them all maximized. I can do this fine, but there's an annoying problem
though.
When I close one form to open the other, the next form first appears NOT

Good Day,
This wasn't happening before.  All my forms have the default veiw set to
single form and the Min/Max Buttons are both Enabled.
When I veiw the forms in the Design Veiw, they show in a small area of the

Can someone tell me what's wrong with this code. First it works, then it
stops working.
I have 4 unbound boxes on a form. Dodaac, Supply Chain, Start Date and End
Date. It's the date I'm having a problem with.