I have a secured database split into front and back ends. I have two
security groups FirstLevel and SecondLevel, each group can see, access and do
different things in the database.
However both groups can use the main form [frmClientDetails], there is one

How would one change a Table's name via a Form textbox?
Why?  Users need to create a ProjectTable carved out from records in the
Master Tables - so the query is a MakeTable query to create a TempTable they
can work with.

Thanks in advance,
Code run from access to operate an excel sheet.
Problem is I want to insert 1 column at Column "A' but inserts five colums
why?  What is fix?

I have a "Last Updated" subform that is embedded in several data entry forms.
In case a user has several data entry forms open at once, I need to capture
which particular data entry form is being updated so that the Last Updated
info is correctly assigned to the right record.

I have a form with a combo box. The combox box is set to select records from
a table. If a record is selected that is not in the table, a popup window
tells you that selection is not valid, then ask if you would you like to add
it.

I have a combo Box in my forms. This form his used to Generate a report. When
I select each one of the customer in the combo box with a date I do not have
any problem. I have the word "ALL" in my combo box using ( SELECT DISTINCT  
store.client FROM store UNION select "All ...

I have a simple form with a text box and a list box.  The list box's row
source is derived from a query that finds all records containing the text
that is written in the text box.
The problem is that I can't find out how to update the list box after every

if this is posted already forgive me
I have a query whichright now the syntax for is as follows
Door Width:[Cabinet Width]-.1250
I'm new in access ( i'm okay with excel and vba)

All,
I have table tblTrialBalance which has fields [Account], [JanAct], [FebAct],
[MarAct], etc for Actual results as well as fields for budget and for
forecasts.

When I put anything in before update event procedure of an input form, below
error message came up.
Error message
Microsoft Office Access

I have a split database.  back-end is only 3 related table (standard
many-to-many). Referential Integrity was set up with both cascades.  Now Access
has somehow decided to gray out the ref int/cascades when I check on the
relationship.  I did import a query but the design window ...

I have some code that I have put together from several sources that
runs Access Reports as PDFs using Acrobat 7 pefectly.
I can change some options in the code:
- send fonts (yes or no)

In Form_BeforeUpdate event I want to check if a specific control had been
changed. This is for a business rule, if x has changed and y then CancelEvent.
Thanks.

Let's say I have the following:
Private Sub btnRefRes_Click()
   Me.Remaining_Calls = Format(Nz(DCount("*", "tblCandidates", "[Source] =
0 "), 0), 0)

I have this query:
SELECT T_LOGS.DATE, T_LOGS.AGENT
FROM T_LOGS
WHERE [Forms]![frm_logs]![MyCriteria];