| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | I am attempting to reduce the number of harddisk writes I make into a
mdb file. Currently, I insert roughly 10,000 rows of data on a daily
basis...
Bob Barker
|
06-06-2010 05:09 PM
Phillip Holmes  | 8 | 50 |
| | | Here is the result of a query. This query was created using 2 temporary
tables which hold every combined total of a number of payments ( I...
Phil
|
06-06-2010 12:22 AM
Phil | 4 | 21 |
| | | I open Access 2007, open the mydatabase.accdb database, run the below
code as a macro and it runs fine.
But, if I open a Word 2007 document, try to...
r
|
06-05-2010 07:29 PM
r | 4 | 21 |
| | | I am getting the following error when trying to open a linked to sql
table in access.
Connection Failed
sqlstate 28000 sql
server error 18456
Login...
mcolson
|
06-04-2010 04:32 PM
Albert S. | 1 | 40 |
| | | I have 8 meeting rooms that are available to be booked by the hour. In
addition to the rooms there are ancilliary resources eg pojectors etc
I would...
Vet Tech
|
06-04-2010 12:47 PM
Access Developer | 3 | 31 |
| | | On Fri, 4 Jun 2010 06:52:54 -0400, "Douglas J. Steele"
<NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote:
Additionally you need a unique index...
Tom van Stiphout
|
06-04-2010 08:32 AM
Tom van Stiphout | 0 | 21 |
| | | I have an Access 2007 database. I would like to make it so it could work
with multiple currency symbols.
Example: In the US they would enter...
Mark Andrews
|
06-04-2010 08:29 AM
Mark Andrews | 6 | 25 |
| | | We will be switching from GroupWise to MS Outlook w/exchange in the
near future. I would like to be able to add some features to our
database to...
Rick A.B.
|
06-04-2010 07:33 AM
Rick A.B. | 0 | 17 |
| | | I've been doing some work with resetting the user-level security
permissions on one of our databases and now am confused and have a
headache.
I am...
Vincent
|
06-04-2010 01:27 AM
Rick Brandt | 5 | 21 |
| | | In Access 2003, I have a form with four distinct subforms. When I open
the main form in datasheet view, the first subform is available as...
Neil
|
06-04-2010 12:42 AM
Tom van Stiphout | 1 | 25 |
| | | Does anyone have experience with installing a new copy of Office 2010
(Word and Excel only) or upgrading the existing installation, but
retaining...
AllenWhite
|
06-02-2010 10:42 PM
Gina Whipp | 1 | 24 |
| | | Watch the latest video in the DB2 vs. Oracle series. This one is an
animated tale of two peasants from the “Village of Orrible” who want
to
break...
Anil Mahadev
|
06-02-2010 10:57 AM
Anil Mahadev | 0 | 19 |
| | | Greetings and salutations!
I have a form to enter data that tracks attendance at a function. As
in, this grandparent attended this seminar. I have...
MrsRum
|
06-01-2010 07:05 PM
Mark Andrews | 1 | 17 |
| | | Hello,
We are using Lebans ReportToPDF module and are having conflicts with a
printer driver. It seems that if we switch the default printer to any...
Albert
|
06-01-2010 01:49 PM
Albert S. | 2 | 20 |
| | | I have created a Access 2007 database, Test.mdb, created a table called
"mytest" and created required fields in it. Now, using VBA(Visual Basic
for...
r
|
06-01-2010 08:17 AM
r | 3 | 36 |
| | | I've been trying to find a way to check whether emails (sent via
Outlook) have a Read Receipt - and getting nowhere.
A 2003 and Outlook...
jbguernsey
|
05-31-2010 01:39 PM
jbguernsey | 3 | 26 |
 | | I have a 2000 database that users ULS for restricting access to forms and
reports.
What is the best, or any, solution for restricting access to...
JeffP
|
05-31-2010 01:32 PM
David W. Fenton | 22 | 68 |
| | | Access 2003 SP3
I have a form with a couple of date/time fields
On one PC I can do a filter by form and enter *17/03/2010* and the
filter will...
Dennis McDermott
|
05-31-2010 03:40 AM
Dennis McDermott | 11 | 56 |
| | | I want to restrict a user to enter ONLY numbers 0-9 in a text box with
a max length of 10 digits. No signs, spaces allowed. All 10 digits are
not...
Prakash
|
05-30-2010 11:25 PM
James A. Fortune | 6 | 46 |
| | | Hi
My odbc drivers appear to be corrupted or have 'vanished'??
when I click on the User DSN >> User Data Sources: MS Access
I get the following...
Clive Swan
|
05-30-2010 04:59 PM
Arvin Meyer | 1 | 23 |
| | | I want users to be able to store personal preferences for paths, layout,
report dates, etc. I'm thinking to store the info in the following...
Lars Brownies
|
05-30-2010 09:35 AM
Lars Brownies | 10 | 38 |
| | | The Word 2003/2007 document(some files are in
"docx" or Word 2007 and some are in "doc" Word 2003 format)
has data as indicated below:
...some text...
s
|
05-30-2010 07:22 AM
Rudi,R.F. | 1 | 33 |
| | | I just purchased one of...
Wayne
|
05-28-2010 09:52 PM
Wayne | 13 | 63 |
| | | I have a query that has Var1 VAR2 VAR3 VAR4 in the output
each row is based on var4 having a 6 or a 12 and they variables are
all there.
But in a...
sparks@work.com
|
05-26-2010 04:58 PM
Salad | 3 | 17 |
| | | I'm creating an Access 2007 dB which will have several users (no more
than 10). I've never split a dB before or worked with a split dB.
What is the...
Clare
|
05-26-2010 02:23 PM
Tony Toews [MVP] | 3 | 29 |
| | | Is it just me? Has anyone noticed odd things on calcs with Access and
Windows7?
A rounding function that has worked for years increases a pence...
elg
|
05-26-2010 07:25 AM
jwither | 1 | 40 |
| | | Hello all. I'm not sure if this is possible or not, so if anyone
could tell me definitively, that would be great.
I want to create an unsecured...
Vincent
|
05-25-2010 08:13 PM
Access Developer | 5 | 24 |
| | | I trying to create access stand alone project and in the top of that I need to be able to lock the program something like EULA if they don’t pay...
jack
|
05-24-2010 03:58 PM
Tony Toews [MVP] | 4 | 41 |
| | | I am trying to Create a table from DDL code.
Upon running the query I get the error: Syntax error in CREATE TABLE
statement. (Error 3290)
Here is...
zufie
|
05-24-2010 12:25 PM
Salad | 1 | 13 |
| | | Please help, a clear answer is needed!
If the code below copies the record to the same table... How do you
copy it to another table? I would be...
Brad
|
05-23-2010 05:23 PM
Tom van Stiphout | 1 | 20 |
| | | Using MS Access 2007 I have a PivotTable form (created via Create-
Forms-MoreForms-PivotTable) and I want to be able to open another form
by clicking...
Clare
|
05-21-2010 06:55 AM
Clare | 2 | 45 |
| | | I have a sql server table with a column definition that I cannot
change (third party application)
when I link this table into access97
the linked...
Roger
|
05-21-2010 02:54 AM
Roger | 3 | 25 |
| | | Just upgraded from Access 97 to 2007 and all working well except
I used a popup calendar using mscal.ocx in 97. But in access 2007,
none of the...
OJ
|
05-20-2010 11:51 PM
Tom van Stiphout | 1 | 15 |
| | | I have also written to the firm and asked that the practice stop. It
would seem that they have seen reason and chosen to do the right
thing.
The Frog
Maple MRS
|
05-20-2010 02:25 AM
The Frog | 1 | 33 |
| | | Whenever I add a table's field to a form, a colon is automatically added
after the fieldname. Is there a way to prevent that from happening? I...
Lars Brownies
|
05-19-2010 09:53 AM
Lars Brownies | 2 | 16 |
| | | I have a person table and want to add an extra 1xM table: tblNotes. I'm
doubting whether to add a specific primary key NotesID or to put a...
Lars Brownies
|
05-18-2010 11:11 AM
Access Developer | 6 | 41 |
| | | I'm still composing my personal naming convention and I have a question
about it.
In my apps I have a table tblUser with the first field: UserID. In...
Lars Brownies
|
05-18-2010 11:05 AM
Access Developer | 11 | 33 |
| | | In the microsoft.public.access.* groups, Microsoft has announced their
intention to shut those groups down and move to a web based system....
Allen Browne
|
05-14-2010 10:25 PM
Access Developer | 18 | 60 |
| | | "(PeteCresswell)" <x@y.Invalid> wrote in
news:em6vr5diie23113pgf48e7aks95hcjb6mf (AT) 4ax (DOT) com:
Only the 32-bit version. But that's the only...
(PeteCresswell)
|
05-14-2010 09:05 PM
Access Developer | 47 | 165 |
| | | Hi all,
I have developed a tool for a team in Ms.Access 2003.
According to the microsoft I have downloaded the RUNTIME Environment.
This is added...
Repath
|
05-14-2010 09:00 PM
Access Developer | 2 | 34 |
| | | A few months ago, I posted a message about an Apply Filter error
message that only appeared on 2 of 20 or so computers using a program
I developed. ...
Tomahawk Lady
|
05-14-2010 08:54 PM
Access Developer | 10 | 61 |
| | | The company I work for is currently trying to redeploy Maximo (CMMS
software). We are trying to figure out the value of using the Standard
Modifiers...
Steve Berebitsky
|
05-14-2010 08:14 PM
Access Developer | 1 | 24 |
| | | I was hypnotised last night by a stage magicisan! How do I know I am
out of it? Pleas help.
Samuel Luter (N4469P)
|
05-14-2010 07:38 PM
Access Developer | 2 | 65 |
| | | Title: Software Developer
Location: Princeton,NJ
Duration: 6+ months
Description:
The candidates filling these Developer positions will be...
Maple MRS
|
05-14-2010 07:27 PM
Access Developer | 1 | 23 |
| | |
zufie
|
05-14-2010 02:17 PM
Salad | 2 | 13 |
| | |
zufie
|
05-14-2010 01:40 PM
zufie | 0 | 20 |
| | | I have 2 databases, one is just a front for the user's to enter data
(all tables are linked tables). The another database has the data.
We have just...
Pat
|
05-14-2010 07:58 AM
Pat | 2 | 30 |
| | | Hi
i have created a chart based on a query
TRANSFORM Sum() AS SELECT FROM
GROUP BY PIVOT
;
this works fine puts weeknum in order ie 4 ...
kevcar40
|
05-14-2010 07:47 AM
Phil | 4 | 19 |
| | | Title: SAP ABAP LEAD
Location: Syracuse,NY
Description:
2-3 years of Lead Experience
5-8 years of SAP ABAP
Maple MRS
|
05-13-2010 01:41 PM
Maple MRS | 0 | 17 |
| | | I've got an Access 2007 application that uses automation to create an
Excel 2007 Workbook. Everything works great except that it changes
the value...
BB
|
05-13-2010 01:40 PM
BB | 5 | 24 |
