microsoft.public.access

Message Index 10 for Discussion Archive microsoft.public.access
Access 2003 runtime macro secrity (by kev on 13 May 2004, 1 reply)
Hello,
We are using the Access 2003 runtime to for some applications. I need to
change the macro security to low to get rid of the warnings about opening
the database. Does anyone know the registry key this is held in, since I ... (more)
Help with Creating a Mask (by Stephen White on 13 May 2004, 3 replies)
Is it possible to create a mask that will force a user to enter number with zero's in front to make every entry 6 digits

Ie
1 would be 00-0001 ... (more)
Problem deleting a record in a SQL Server linked table! (by Nuno Almeida on 13 May 2004, no replies)
Hi,

Sometimes, when I try to delete a record in a SQL Server linked table,
through a Microsoft access form, I get the following error message: "The ... (more)
Importing my Address Book (by Andy Bilham on 13 May 2004, no replies)
When I try to import my Address Book, saved on a CD from before a re-format,
I'm informed that the Address Book is lock by another application (although
there are no others open), and I can't get past this. I'm running XP Pro.
Can anyone please help - all my addresses are in there! ... (more)
unable to open database (by erinyes69 on 13 May 2004, 1 reply)
I created a database in Access 2000 when not connected to
my network and it worked fine but once connected to the
network it will not open. I have tried several times but
cannot get it to work. Has anybody any ideas?? ... (more)
How to change with VBA Regional setings (by niki on 13 May 2004, 1 reply)
How to change with VBA Regional setings decimal symbol ... (more)
Data Error (by Benn Vosloo on 13 May 2004, no replies)
I have a data base on one XP Pro pc connected to a network
of XP Pro
and Win 98 SE pcs. All other pcs are linked to the tables
on this pc. ... (more)
Tab Order (by Lyn on 13 May 2004, 3 replies)
Hi, I am a newbie to this group and to Access. I am working on developing a
form and am having trouble with the Tab Order dialog (View -> Tab Order...).
I am using Access 2003 under Win XP. ... (more)
Update a date value to 1st of month (by Tim on 13 May 2004, 2 replies)
Hi

I have an update query that places a load of snapshots
into a table storing month data for trend analysis. I ... (more)
command line switch /runtime (by Herbert Becker on 13 May 2004, no replies)
Hello!

What exactly is the switch /runtime doing? ... (more)
Pivot Table Wizard (by Phil on 13 May 2004, 1 reply)
Does anyone know which .DLL file runs the Pivot Table
Wizard?

"Problem obtaining data" ... (more)
Having the hardest time creating the dropdowns I want. (by Greg on 13 May 2004, 2 replies)
I would like to create 3 dropdowns. I believe they are
dynamic dropdowns.
1. Company
2. Division ... (more)
Weeknum (by Ashley on 13 May 2004, 1 reply)
I need to returns a number that indicates where the week
falls numerically within a year.

This function returns the #NAME? ... (more)
Control Panel Not Accessible (by Alex on 13 May 2004, 3 replies)
When I try to use any application in my control panel I
get an error message that reads: Access to specified
device, path, or file is denied. I'm using Windows 98.
How can this be fixed. Thanks in advance. ... (more)
Data Acces Page from Wizard - where does path come from? (by ArtIgnacio on 13 May 2004, 1 reply)
I have used the wizard to create a data access page. The
HTML shows a data source with a path with the full path on
my machine. I edit it to reflect the relative path. That
is, the page and the database are in the same directory. ... (more)
database configuration (by cheryl on 13 May 2004, 6 replies)
I am a newbie with databases. We have built a database
that only has the forms and tables done. What is the next
step. Do we need someone to develop architecture (how
many users, how the information is going to get to the ... (more)
Access97 Module Name Argument error (by pat2469 on 13 May 2004, 3 replies)
I get the following error message when trying to open any
Access 97 database on my computer could someone let me
know what it means and how to I fix it? None of the
database contain any modules. ... (more)
access upgrade (by doug on 13 May 2004, 1 reply)
does microsoft access have any flaws occur when you
upgrade an existing database from 97 to 200?
thanks ... (more)
Access 200 Runtime SR-1 Request (by David on 13 May 2004, 1 reply)
I have a Word document with an Excel worksheet object
within the document, when a click to open the worksheet,
Access 2000 Runtime starts to load and wants an Access
2000 Runtime disk. My problem is that I do not have ... (more)
Multiple forms for Data Entry (by Frank on 13 May 2004, 2 replies)
I have a 2000 access database that has multiple forms for
data entry only. When I get to the last page of entry I
need to save and move to the next record opening the first
form. ... (more)
Office 2000 Professional and Access 2003 (by J. Wallace on 13 May 2004, 4 replies)
Does Access 2003 work with Office 2000 Professional? Our
computer company supplies our computers with Office 2000
Pro. without Access. I would like to load access on my
computer, and have received an "ok" from our computer ... (more)
Error Message (by Loi on 13 May 2004, 3 replies)
Hi,
Anytime I close a database, I revieve a message like that
MSACCESS.exe has generated errors and will be closed by
Windows. you will need to restart the program. ... (more)
acces 2000 trouble (by douglas on 13 May 2004, no replies)
i have a database that was in access 97 when i upgraded
that worked fine. now after the upgrade the database and
want to make selections in a pop up box it wont let me
accept or cancel. it just refreshes the popup box and i ... (more)
out of date mscomctl.ocx (by anonymous on 13 May 2004, 1 reply)
I am getting an out of date mscomctl.ocx error on my
machine. How can I get this up to date.

Thanks, ... (more)
Reusing an existing database (by Dave on 13 May 2004, 4 replies)
We have an existing Access 2000 database. We would like
to use it for another project without the existing data.
What is the best way to prepare an existing database for
reuse of this sort? I presume I should not open all the ... (more)
Windows 98 MSjet40.dll (by Rose on 13 May 2004, 1 reply)
Have a complex Access program running in multiple user
environment. All have Win2000 and Office XP SP-3 and
Msjet40.dll version 8.0.8618.0, except one user who has
Windows 98 (same Office)and jet of 4.00.2927.17(?). Since ... (more)
Number of characters in a field (by Scott on 13 May 2004, 2 replies)
I have a Memo field which I would like to convert to a
text field, in order to avoid database corruption, now is
there any way how I can get the number of characters I
have in each record of the Memo field using a query. ? ... (more)
Function and Query (by Pete on 13 May 2004, 4 replies)
Function GetPhoneTimeTotals()

Dim db As DAO.Database, rs As DAO.Recordset
Dim totalhours As Long, totalminutes As Long ... (more)
Cognos Automation Method names? (by Roger on 13 May 2004, no replies)
I want to run an .imr file and export it in a CSV format.
Does anyone know how I can do this?
I have some code for exporting it into a DBF file. The
problem is that the filed names become truncated and this ... (more)
MSAccess 2002 Not Exiting Cleanly (by Judith Ryan on 13 May 2004, 2 replies)
Since I converted our Access application from Access 97
to Access 2002, the program doesn't end properly.
Everything looks ok on the surface, the application goes
away, but if you go into Task Manager, the MSACCESS.EXE ... (more)
Split Database Question (by Dave Ruhl on 13 May 2004, 10 replies)
Our front-end is an Access 2002 MDE, with the back-end
data in SQL Server. The MDE is stored on a file server,
and each user has an icon on their Desktop for this MDE. ... (more)
auto fill-in (by joni on 13 May 2004, 1 reply)
How do set up a form/table to auto fill-in repetitive
information? ... (more)
auto fill-in (by joni on 13 May 2004, 1 reply)
How do set up a form/table to auto fill-in repetitive
information? ... (more)
Need help!!!! (by annette on 13 May 2004, 1 reply)
I have a form that I enter information. I filter my form,
then I print my form. Once I have printed the form, the
information that I filted, I want deleted. I have tried
creating a macro and I can't do it. I want to simplify ... (more)
How can I Exclude a Field From a Select * Query? (by Preying Mentis on 13 May 2004, 4 replies)
I have a table that has over a hundred fields (about 150). I am trying
to select all the fields but one (149).

I am doing this through code and am not using the Access Query builder ... (more)
need to delete record having two different fields with same value (by L. T. Portella on 13 May 2004, 3 replies)
need to delete record having two different fields with same identical value

daily I am given a table (access 2000) where a record may have the same
identical value in two of its fields. I have to delete such a record. Can ... (more)
dbSeeChanges specified in OpenRecordset yet Access still raises error 3622 (by Ivan Starr on 13 May 2004, 1 reply)
Hello thank you for trying to help.

I have a call to OpenRecordset with an SQL query that references linked
tables that are linked to tables on an SQL Server. The call gets error 3622 ... (more)
How to get the order of a field? (by Özden Irmak on 13 May 2004, 4 replies)
Hi,

Is there any method/property in ADO or ADOX to get the order of a field in a
table? ... (more)
Clear Clipboard in Access 2000 (by Ricardo on 13 May 2004, 2 replies)
Hi,

How does one clear the Clipboard in Access 2000? ... (more)
Access version number history (by Silvester on 13 May 2004, 9 replies)
8.00.00.3512 Access 97
8.00.00.4122 Access 97 SR1
8.00.00.5903 Access 97 SR2
9.00.00.2719 Access 2000 ... (more)
Connecting to a database (by Michel gour on 13 May 2004, 1 reply)
i need to connect to a database on different servers i would like to use for
the connection the IP address of the server . how i can do it in a function
or a sub in VB
thank you for your help ... (more)
New table in Design Master - no "Replication" icon (by felecha on 13 May 2004, 1 reply)
Using Access 2003.

Replication is new to me. But it's a very good solution to my need in
an application. I can enter configuration changes in one machine, ... (more)
Access 2000 and Windows XP (by Paul Fenton on 13 May 2004, 2 replies)
A while back we installed an Access 2000 front end on a new Dell
running Windows XP and Office XP Pro. Every other installation of
this application is running on Win 2000. ... (more)
Re: Data taken from one record and placed into another record (by Larry Daugherty on 13 May 2004, no replies)
Jon,

Please don't multipost - get the same thread working independently in
several newsgroups. In stead, crosspost into all of the relevant groups. ... (more)
office xp access (by ted medin on 13 May 2004, 12 replies)
We have 3 pc's using a common access db.
1. What are the ramifications for locking (records pages ...)
2. We have been getting some disk errors referencing the db thru a wireless
LAN. We even got a sever error warning from access. What are your ... (more)
ActiveX control license problem - Access 2003 (by Greg on 13 May 2004, 4 replies)
I have an access database created in Office XP (2002) that is in Access 2000
format. The database works fine in Access 2000 & 2002, but I receive the
message: "You don't have the license required to use this ActiveX control"
when using Access 2003 (regardless of the computer it is on). Does anyone ... (more)
Runtime? (by Asim Tozlu on 13 May 2004, 2 replies)
Hello,

how can I check an Access-Runtime or the complete version installs on a
computer is? ... (more)
Importing from Excel problems (by Aaron on 13 May 2004, 1 reply)
Each of my Excel files has the same exact first row (the column headings
used for the field names in Access). I know this because I cut and
pasted each one from one original file. As I'm importing each of these
files, I eventually get to one where, upon designating that the first ... (more)
print dialog from pop up menu (by LGarcia on 14 May 2004, 1 reply)
Hi all,
I have a pop up menu for my reports. When you right click you get the
options to export or print. I'd like to have the print option open the
printer dialog box instead of just printing to the default printer. I don't ... (more)
Re: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. (by Dirk Goldgar on 14 May 2004, no replies)
"zulu" <zkendir@simternet.com> wrote in message
news:O%23aTe%23QLEHA.268@TK2MSFTNGP11.phx.gbl

What is the SQL statement you are trying to execute? ... (more)
change column name (capture property) in query (by Rajko on 14 May 2004, no replies)
Hi,
Is there a way to change caption (or alias) property in query into f.ex.
label caption property or txtbox.value. ... (more)
Right click menu (by John on 14 May 2004, 3 replies)
Hi

When a user is editing a text field, I would like to allow the user to right
click and view a pop up menu of values taken from a table and when a value ... (more)
Active X Calendar Control (by Fawke101 on 14 May 2004, 2 replies)
Hi, there,

Access 2000
I have several different date fields in my database that require a calendar ... (more)
Re: program (by Wim Hekken ;-) on 14 May 2004, no replies)
Wim Hekken ;-) ... (more)
Creating 'Table of Contents' list with XSL (by Don Wash on 14 May 2004, 1 reply)
Hi everyone!

I'm creating an ASP page (with VBScript) to display the Table of Contents
(TOC) for my website. I have stored the TOC in the XML file and currently ... (more)
Find-method or DLookUp (by Niklas Östrergren on 14 May 2004, 4 replies)
Hi!

I know that ther´s a prestandadifference between SEEK method and FIND
method. At least that´s what I have read. But what about FIND methode ... (more)
Print a Barcode (by Al P on 14 May 2004, 3 replies)
I would like to print an employee ID badge using a windows printer, and have
a barcode for the employee clock number.

Can someone show me how to do it. ... (more)
Multiple Users at once? (by =?Utf-8?B?QWNjZXNzIE5vb2I=?= on 14 May 2004, 5 replies)
Thanks! ... (more)
multiple access run time versions on same computer (by =?Utf-8?B?bWlrZXI=?= on 14 May 2004, 1 reply)
Is it possible to install multiple access run time versions on the same computer? Some of our front end databases are in 2000, and others are in 2002. Thanks, Mike ... (more)
Access 2000 and Access XP on the same machine (by =?Utf-8?B?S2FyaWJ1c3o=?= on 14 May 2004, 4 replies)
Hi everyone!

I have on my PC both Access 2000 and Access XP installed (in different directories). I need that the default version of Access that opens when I double-click an .mdb, .adp etc. file to be Access XP, and not Access 2000, as it is now. (I don't need a shortcut where I can type the location of the desired Access version, I need that Access XP were the default Access.) What can I do for this? ... (more)