Restructuring tables
Thu, 2 Oct 2008 16:33:03 -0700
Hello everyone.
I'm currently working on a project that's... a real pain in the posterior.
My employer assigned me with the task of converting their 10 year old Lotus
database to work with the Access platform.
I would have preferred to start from scratch with the new database, but he
needed it asap so ...
|
How to get a count of items in a Select Distinct query?
Thu, 2 Oct 2008 18:32:07 -0400
I have a table that records client attendance on a course and need to get a
count of course sessions given each month.
If I do a Select Distinct [dateattended] I get a cursor showing exactly what
is needed - for example:
2008-04-02
2008-04-09
2008-04-16
2008-05-01
2008-05-08
2008-05-15
2008-05-22
2008 ...
|
Append data - key violation
Thu, 2 Oct 2008 15:26:08 -0700
Hello all;
I'm trying to append 122 records to a table. The key in the table which
contains the 122 records is "sample#", same as the key in the master table.
The append query didn't work -- I got a key violation message.
I checked the master table and those sample numbers (which correspond to the
122 ...
|
Launching Access using VBS
Thu, 2 Oct 2008 15:17:00 -0700
I am using a vbs script to launch Access (see below). Everything works
except the /ro command lines switch. Can anyone help me rectify my code so
that the db open in a read-only state.
What is puzzling me even further is the fact that when the db does open it
indicates that the db is opening in read-only ...
|
Access 2007 Error
Thu, 2 Oct 2008 15:01:02 -0700
I am trying to copy one table to another table but I keep getting the
following error
"Your network access was interrupted. To continue, close the database, and
open it again." Help tells me my network was interrupted but I am not
working on a network but on my local hard drive. I have copied the database ...
|
simulate a ticket
Thu, 2 Oct 2008 15:31:30 -0600
Wish control is the most appropriate to simulate a ticket sale.
...
|
ADO Connection dropping? when left idle
Thu, 2 Oct 2008 14:13:27 -0700 (PDT)
I'm developing a database in 2003 with a separate FE/BE. The BE is
Access, but the book I had when I started learning was really pushing
ADO as this new and great thing so I started out using ADO.
If the database is left open and unused while the client is on lunch
or break, she gets errors when she tries to d ...
|
|
|
Copy records from one table to another
Thu, 2 Oct 2008 13:51:01 -0700
I need to copy 182 records to another table that already has 84 records in
it. All the fields are the same for both tables. How can i do it? ...
|
Text File into Access not bringing in Dates
Thu, 2 Oct 2008 12:55:01 -0700
I am trying to import a text file (large one) with multiple dates as a
delimited file but when Access imports the date do not show up in the table ...
|
Unbound text box repeats for every row on a continuous form.
Thu, 2 Oct 2008 12:13:00 -0700
I have two text boxes on a continuous form. Text2 is populated from the
value selected in Text1. Text2 is unbound and repeats the text on every line
displayed once the value is selected in Text1. I do not want to bind Text2
to a table/query as form is a purchase order receipts data entry form and
needs to ...
|
