Short time format problem in Access 2007
Sat, 22 Nov 2008 07:57:01 -0800
In my table, I have a date/time field and have format the field for short time.
When I enter 00:34 hours, the table converts that to 0:34 hours dropping the
first zero. I have tried various ways to format the field but can not get
access 2007 to properly format the field in a 24 hour format.
When my form ...
|
access 2007 runtime
Sat, 22 Nov 2008 05:38:01 -0800
Is there a way to setup different install options for a split DB using Access
2007 Runtime? install both frontend and backend, install just backend,
install just frontend. From what I can tell it only allows one setup option.
Any information would be appreciated. ...
|
New to Access & DB's
Fri, 21 Nov 2008 22:22:03 -0800
Hi All!
I'm a brand-spanking-new Access user, especially am new to the Microsoft
Office 2007 version. I have the need to make a hobby-related database which
contains data from 10-15 years of published data containing a small number of
related fields. I tried to learn Assembly, like the type used in Micros ...
|
Pass Field Name Using Variable to SQL string
Fri, 21 Nov 2008 17:54:22 -0800
I want to pass field names to an SQL string to identify the current of many
fields that I have to update in the table tblData (ie Fields ----> Jan06,
Feb06, Mar03......Dec09).
I want to use a recordset with SQL to identify the current field and edit
and update the current record in the current field.
Th ...
|
Problem with data displaying in form and layout view
Thu, 20 Nov 2008 19:25:00 -0800
I was hoping someone could tell me why a form I am designing only displays
the data in design view. I am designing a form with a sub form and I have
built the queries. All the fields show up in only in design view. I have many
other forms with sub forms in my database and this is the only one that has
given ...
|
This record has been changed by another user ...
Thu, 20 Nov 2008 10:25:54 -0800 (PST)
I received this message after adding a "bit" value to a table.
The error message box reads:
This record has been changed by another user since you started editing
it.
If you save the record, you will overwrite the changes the other user
made.
Copy the changes to the clipboard will let you look at the value ...
|
Normalisation and Relationships Problem
Thu, 20 Nov 2008 17:34:33 GMT
Hi
I'm very new to Access databases and I'm trying to set up a system for a DVD
rental shop. At the moment I have my tables set up as below, but I've been
told that this is not normalised and won't work properly. Apparently I need
to add another table. I'm also not sure what type of relationships I should
hav ...
|
|
|
Subforms
Thu, 20 Nov 2008 08:23:01 -0800
Hi! Sorry for my lack of terms when trying to explain my problem, but I am a
newbie. Here goes the question. I have a Main form, which is embedded with
3 subforms, When I add a subforms to the main form, for some reason, the
subforms are not functioning the same way as the its original form (i.e. The
Main ...
|
Create Linked Table to AS/400
Thu, 20 Nov 2008 07:05:01 -0800
I am trying to create a linked table from Access to our AS/400 database. I
am basing my macro on an Excel macro that uses a SQL call to download data
from the database. My code to build a table using ADOX is below"
Private Sub CreateAS400LinkedTable()
Dim adoCn As ADODB.Connection
Dim adoCat As ...
|
Multiple Combo boxes
Wed, 19 Nov 2008 19:16:01 -0800
Is it possible to synchronize 4 combo boxes? If so, would I have to create
four tables and link them? Please help, I am in a big rut...Thanks! ...
|
