microsoft.public.access

Message Index 22 for Discussion Archive microsoft.public.access
Discussion Groups Index     first   prev   18   19   20   21   22   23   24   25   26   27   next   last 
Re: question (by John Vinson on 26 May 2004, no replies)
No you cannot.

Microsoft.public.access is NOT A CHAT ROOM. It's a technical support
newsgroup for the database program, Microsoft Access. Chat rooms and ... (more)
Cry For Help! - Filling In Forms Automatically From Tables (by -elniniol999- on 26 May 2004, 3 replies)
i have a table called order details which contains:

order id
product id ... (more)
t-sql to create table (by tobbe on 26 May 2004, 3 replies)
Hi

How do I create a table in access whit a t-sql script? Im accessing the
strSql = " CREATE TABLE language (pkid COUNTER not null, name Text(50)) " ... (more)
Can I add "properties" to a Recordset? (by MyndPhlyp on 26 May 2004, no replies)
One of the things I'd like to do is retrieve the name of the underlying
table (or query) for an ADODB.Recordset even if the Recordset is closed.
That tends to rule out sifting through the Properties since a closed
Recordset has no Properties. ... (more)
Word Macro for image conversion (by anand on 26 May 2004, 2 replies)
Hello group ,

I have a word page that carries certain EMF( Excel objects like bar diagram
etc.) , I want to convert each EMF into GIF images. Is there any word macro ... (more)
Outlook Express (by jerrynjulie1 on 26 May 2004, 1 reply)
How can I tell Outlook Express to remeber my password? The sign in window
has a check block to tell it to remember but you can't check it. ... (more)
SQLState 3146 (ODBC call failed) (by MyndPhlyp on 26 May 2004, no replies)
Arghh.

(Fear not. That rhythmic thumping you hear is only the sound of my head
repeatedly hitting the desk.) ... (more)
Date function gets compile error: Can't find project or library (by Ivan Starr on 26 May 2004, 1 reply)
Hello thanks for trying to help.

I wrote an mdb frontend on one computer and it worked just fine. I ran it
on another and it came up with the error ... (more)
need you help. (by William Lehutso on 27 May 2004, 2 replies)
I have an USB ISDN when it is connected an trying to go to inernet it keep
telling me that moderm is not responding ,what might cause this?
William ... (more)
Reordcount = -1 (by George Hester on 27 May 2004, 5 replies)
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;248255

I just put one command button on a form and this is the code for the =
Click event: ... (more)
NZ function? (by js on 27 May 2004, 6 replies)
Hello,

I can use a NZ function query in a VBA code, but got error when I using ADO
Dim cnn As New ADODB.Connection ... (more)
SQL "DELETE" mit "LEFT JOIN" (by Winfried Kaiser on 27 May 2004, 2 replies)
Ich habe mir mit ACCESS 2000 eine Abfrage konstruiert, die mit alle Einträge
der Kundentabelle zurückliefert, für die in einer zweiten Tabelle keine
Einträge vorhanden sind. ... (more)
export tables from Access 2003 to a MySQL (by =?Utf-8?B?ZW1wdGluZXNz?= on 27 May 2004, 4 replies)
I am trying to export tables from Access 2003 to a MySQL database. I created an ODBC with the ODBC 3.51 that I found in the MySQL's site. The ODBC is working fine, when I tested from the control panel it conects to the database. Then I go to Access, select a table then export. In the combo "Save as type" I select "ODBC Database" and select the ODBC that I created (and tested) for MySQL. I get the following error: "ODBC Falló la llamada" (ODBC: The call failed).

I am really needing to get this working as soon as posible... please HELP ME!!!!! ... (more)
Disable macros? (by Van T. Dinh on 27 May 2004, 2 replies)
Distribute your app in the MDE format and the user won't
be able to change the Design of the database including
create Macros. You need to keep the MDB file in a safe
place as you WILL NEED it if you want to do any mods to ... (more)
Problem With Replicas and Linked tables (by Tim on 27 May 2004, no replies)
I have a table linked in for auditing the database use
(the code was kindly provided by Roger Carlson via this
forum). Need has arisen for the database to be replicated
to various parties, for synchronising every other day. ... (more)
Filter by Selection Returns Duplicate Records (by donna on 27 May 2004, 1 reply)
I'm trying to help a user of Access 2002. He opens a
linked table, searches in one field for a specific value,
then uses the "filter by selection" button to limit the
display to just those records. He gets 28 records ... (more)
Default file location A2002 Windows2000 (by Brigitte P on 27 May 2004, no replies)
When I dump a file into an Excel spreadsheet via the
toolbar button "x" (Office Links in Tools), the file goes
by default into the same folder that I have designated as
the default folder for Access files. My user then runs a ... (more)
Update Query (by nl on 27 May 2004, 2 replies)
Using an update query, how do I update numbers like
V62.81 to V6281 (no decimal point); there are different
numbers for each record. ... (more)
Pocket Access (by Pocket access on 27 May 2004, 1 reply)
Is there such a thing as pocket access for the PDA? If so
where can you buy it

Thanks ... (more)
Is this a known issue? (by Tim on 27 May 2004, 5 replies)
I've had this on several apps I've developd.

I've got a database, about 10 tables, several forms
accordingly. On 1 form (to add account information, as ... (more)
IIF Limitation (by JA on 27 May 2004, 2 replies)
I am using IIF statement to specify weeks as shown below.
Unfortunately it does not allow me to go beyond 13 weeks.
How can I overcome this limitation? ... (more)
colour in records (by dumbo on 27 May 2004, 1 reply)
is there a way to highlight in any colour only one or two
particular records. I have tried everything and ony
managed to highlight the whole page. please help. ... (more)
MS Access 2000 database size limit (by Amoebakit on 27 May 2004, 1 reply)
Hi all,

I have been seeing/hearing people mentioning different
version of MS Access supportable database size limit ... (more)
Upgrading / Converting from ACCESS'97 to ACCESS'2003 (by Vern DeGeus on 27 May 2004, 3 replies)
i will be converting a significant ACCESS'97 .mdb to
ACCESS'2003. The .mdb has complex forms, many pass-thru
queries and linked tables and a lot of DAO code. Can
anyone share with me any gotchas and other issues that i ... (more)
Adding up Hours (by Jackie on 27 May 2004, 1 reply)
I need to track the number of hours a student accumulates
while taking various courses. These hours will then need
to be added, by query, to produce a total number of hours. ... (more)
access report (by mackie on 27 May 2004, 1 reply)
I am creating a report grouped by day's transaction.
is there a way to manipulate the number of total number
pages per group? ... (more)
Can open by open but not by clicking file (by Bryan T. Hoerber on 27 May 2004, 6 replies)
I have upgraded from a Win98 to WinXP machine on a domain
network. Ever since doing so I can no longer open
Microsoft Access databases by navigating to the folder
and opening the file by double clicking it. I have to ... (more)
Justifying Memo Fields (by Ernie on 27 May 2004, 1 reply)
Hi, I am trying to justify the text in a memo field on a
form. At the moment, it is left justified and ragged on
the right. I can't see any icon that offers full
justification left and right. Can anyone help me? ... (more)
running total in a query (by benoit on 27 May 2004, no replies)
Hi,

I asked before about having a running total. Thanks for
the answers, but maybe my question wasn't clear. ... (more)
Finding a competent teacher (by NeedHelp on 27 May 2004, 4 replies)
Hi everyone.

I am in charge of hiring someone to teach a
basic/introductory/beginning level Access class that is ... (more)
Access 2002 (by Sherri on 27 May 2004, 2 replies)
I needed to back up Access files onto my computer and
when I go to edit it won't let me save says it is a "read
only" file. Can anyone tell me how to change this so I
can continue to work within these files? Thank you! ... (more)
problem with help file (by Pedro L. Arango on 27 May 2004, no replies)
Hello. You know that help text has text that's
highlighted and underscored. Upon clicking on the second
type, a new help screen shows up. That one is ok. ... (more)
RAM Memory Used by MS Access (by fred on 27 May 2004, 1 reply)
Our organization in planning on purchasing a server for
all the MS Access applications. How much RAM Memory does
a single MS Access application use. The second related
question is...does each MS Application executing use up ... (more)
Record limit and file size (by kenlo on 27 May 2004, 5 replies)
1. Excel has a limit of the number of rows. Is there a
limit on Access how many records can be saved in one file?

2. The file size gets bigger everyday even after ... (more)
Copying data into multiple records (by Lynn L on 27 May 2004, 1 reply)
I have the same data that needs to be added to 4000
records. The standard copy and paste will take forever.
Is there anyway to copy and paste it to multiple records
at once? ... (more)
ie5 (by dee on 27 May 2004, no replies)
Sorry to post this here but I'm new to this newsgroup and
couldn't find anything on IE

When a page is loading I cannot move the cursor, or it is ... (more)
Justifying a Memo field (by Ernie on 27 May 2004, 1 reply)
I am trying to fully justify text in a memo field. There
doesn't seem to be an icon available to do this. Does
anyone know of any code that would achieve a left and
right justified appearance? ... (more)
Rounding to nearest whole number??? (by Bob on 27 May 2004, 2 replies)
How can I round a calculated value to the nearest whole
number? ... (more)
Access down & Security warning (by Minhee on 27 May 2004, no replies)
Hi everyone,

Recently I migrate Office 97 to office 2003.
Now I cannot open my access and cannot create table. ... (more)
sqlcode=-0106 (by jordan on 27 May 2004, no replies)
hi, I'm using access 2002 on windows 2000.
When doing a simple select on table I get a sqlcode=-0106
optional function not installed.
I don't understand which function do they talk about ? ... (more)
Office SBE 2003 and Access 2002 (by RoseA on 27 May 2004, no replies)
Have a database (2000 file format). User just upgraded
computer and IT loaded SBE 2003 but Access 2002. NO SPs
showing on Access although just did "office update"
yesterday. Need SP-2 on Access 2002 for macro bug fixes. ... (more)
limit combo box (by Antonio on 27 May 2004, 3 replies)
I am using a combo box to locate records on the curren
form based on a "DateOfVisit" field. Right now, there are
100 records in this table (we add about 50 a day). 50
records have a Date of Visit of 2/14/2004 and the other ... (more)
Access Linked Tables to Outlook/Exchange-Server (by Tom Wickerath on 27 May 2004, no replies)
An interesting question, posed to an
_____________________

Sent: Wednesday, May 26, 2004 3:38 PM ... (more)
Access 2000 will not function with WinXP Pro (by =?Utf-8?B?TmFuY3k=?= on 27 May 2004, 9 replies)
I have an application I wrote in Access 2000 on my old Win98 computer. I now have a new computer with WinXP Pro on which I installed my Access 2000 program. The application that I developed does not function properly. Many of the command buttons give error messages and often the application will not close. The message to send to Microsoft keeps coming up and then Access shuts down. A new file is written each time Access shuts down with the same name as my application with a ending extension of .ldb. This file type says that it is Access.LockFile.9 I feel that this has something to do with the network capability of WinXP, but I am not on a network. The application still works fine on my Win98 laptop and I even checked it on another persons computer that has Access 2000 with Win98. It seems to be the operating system. What can I do? ... (more)
space/storage (by =?Utf-8?B?Sm9obiBL?= on 27 May 2004, 6 replies)
have a person who has told me that given a table with say 200 columns in it... if I create a bunch of records in that table such that only ID field contain a value, while the rest of the fields are null (as in vbnull) that the amount of storage is significantly less compared to if the fields contain actual data. In otherwords, null fields take up no storage (or at leat minimal).... I just tried the experiement and it did not seem to behave that way ... even with compacted DB.... So is what I was told true? ... (more)
error 2495 (by David on 27 May 2004, 4 replies)
What would cause this error after executing a sub from a funtion?

The action or method requires a Table Name argument ... (more)
Saving (by =?Utf-8?B?QnJpYW4=?= on 27 May 2004, 1 reply)
How can I force users to perform a Save as? I would like to save the workbook's orginal state everytime a user opens, modifies, and / or saves. I'd like to force them to do a Save as, rather than a save....which would change the workbook.

thanks ... (more)
msjet40 error when starting database (by =?Utf-8?B?R2xlbiBD?= on 27 May 2004, 1 reply)
One of my users using Citrix is getting 'Cannot load DLL file msjet40.dll' when starting any of my databases. I've found that msjet is an extra installation for Access that allows users to view databases. (Shame its not inbuilt), and I've also found that the version msjet on the users PC is msjet35 (or similar).
My question is - How do you go about updating msjet40 for a Citrix session. Is the install placed on the local PC or through the Citrix session, and if it is through Citrix, are there command parameters that I have to be aware of? ... (more)
Calculated field with incremental costs (by =?Utf-8?B?R2Vyb24=?= on 27 May 2004, 1 reply)
Hi,

FrmProductCosts
Product 1-10 boxes - 11-20 boxes- 21-30 boxes- Minimum Order Value ... (more)
Access 2003 MDE fails (by =?Utf-8?B?R3JlZyBNb2hy?= on 27 May 2004, 3 replies)
I have received the following error after installing the ADE cd and trying to create a MDE of a db. The MDE process works with just one or two tables and two forms, but not with the small db I have created. I have 4 tables, 9 querys, 8 forms, 2 reports and 5 small macros. I consistently receive the error below. My jet 4.0 is version 4.0.8618.0, the link that comes up with the error indicates I should be at v82 or so.

This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used. ... (more)
Dropdown boxes won't show value (by =?Utf-8?B?VGFzaGE=?= on 27 May 2004, 1 reply)
I followed the MS Access performance FAQ to the link below. This link is about loading the queries for a form, combobox,etc. at runtime to help improve performance. I attempted to implement this. I was able to get this to work. However, when I load the rowsource for the comboboxes instead of the value from the table the form is connected to showing the value is blank. If I click on the dropdown box the correct value is highlighted and will then show and the dropdown box is populated properly. Is there anyway to work around this to make the value in the table show on load?

http://www.granite.ab.ca/access/performanceforms.htm ... (more)
U.S. State Combo Box (by =?Utf-8?B?TWljaGFlbA==?= on 27 May 2004, 4 replies)
I know a similar question was answered recently but what I'm looking for is slightly different. On a form I have a combo box which pulls all the states' names, spelled out, from a table. What I would like is for the user to be able to type (for example) WV in the box and have West Virginia come up from the list. Then that full state name will be stored in the "state" field of my main table. Can it be done the same way as with the separate text box?

Thanks,
Michael ... (more)
Error Message (by =?Utf-8?B?Sm9sdmVy?= on 27 May 2004, no replies)
Can anyone tell me why I am getting the error message " could not use 'I'; file already in use" when trying to open an excel pivot table that is linked back to Access 2000? ... (more)
Help . Access and I. Explorer (by =?Utf-8?B?UGFuZ28=?= on 27 May 2004, 1 reply)
Hi, one of my customers have come with the idea of putting a link to one of their access databases front End on their intranet. This never came out to be a problem. However, he also suggested that when someone clicked on the link, the database should be loaded within I. Explorer (browser) just like .xls, .doc or .ppt/pps files. This now came out to be a problem since I have no idea on how this can be done, that is, if it is even possible.

Waiting for help,
Sincerly ... (more)
No Items In File Menu (by Sam on 27 May 2004, 4 replies)
Hope somebody can give me a hand here. Boss gave me a CD and said,
"There's a database on here with some kind of front end. Figure out how to
export the data to Excel, or at least to a text file." ... (more)
Access running slowly over Network (by =?Utf-8?B?U2ltb24=?= on 27 May 2004, 5 replies)
I am using access 2003 over a network.

The Tables are contained in a MDB file located at a WinXP Server. There are few thousand records in the tables.
And at each workstation I place anther MDB file which contains the Queries, Forms and Macros. ... (more)
Creating Tracking system (by =?Utf-8?B?MXRpbWU=?= on 27 May 2004, 2 replies)
I'm trying to find a way how to tracked changes in Access. What I'm trying to do is when a person signs is using a login name, can Access record any changes that make in Access.
thanks ... (more)
Can access do all my work for me??? (by =?Utf-8?B?TWF0dGhldw==?= on 27 May 2004, 12 replies)
Can someone please help me do my database work. I am in school and I can't do it. Yes this is a pitiful cry for help. This is such a bludge. ... (more)
ldb (by =?Utf-8?B?cmljaGFyZA==?= on 27 May 2004, 3 replies)
Help, Have a mdb file i cant open, was restored from a network deletion or network drop?, anyway will not open now
any sugestion, my thought was it was open when it was removed???? ... (more)
Help Me!!! (by =?Utf-8?B?TWF0dA==?= on 27 May 2004, 2 replies)
I can't do my database. Please can anyone help me. How do you do macros. I know how to do it but do you???? ... (more)
Discussion Groups Index     first   prev   18   19   20   21   22   23   24   25   26   27   next   last