microsoft.public.access

Message Index 28 for News Archive microsoft.public.access

Data Access Pages: objects don't bind (by leon on 3 Jun 2004, no replies)
When running Access 2000 on Windows 2000, or Windows 2000 Server SP4, data objects, pivot tables etc. do not bind to the page after initial saving. Page comes out blank, but the related web page is fine. How can this be rectified? ... (more)

unicode text column (by dianna on 3 Jun 2004, no replies)
The width of a Unicode text column must be an even number of bytes. It was a simple query. ... (more)

All access files do not display Charts (by Schlauberger on 3 Jun 2004, 1 reply)
I have Office 2000 Pro installed on my laptop. All my Access files that have charts do not display the charts. The problem is specific to MS Access I have no problems displaying charts in Excel. I have completly removed the ... (more)

Multiple subject searches in access '00 (by Eddie on 3 Jun 2004, 1 reply)
Hey, Ive built a database that tracks my dealers, and all service, product returns, and product orders associated ... (more)

MDE causes hanging (by Kay on 3 Jun 2004, 1 reply)
When I convert an Access 2002 file to an MDE, Access gives an Error Report box, and does not save the MDE. Why does this happen? Is there a work around? ... (more)

Duplicate Records in Output (by janice on 3 Jun 2004, no replies)
I am updating an access data base periodically with imported data from Excel. I then do a pivot table in Excel which imports the info in the Access data base. (Too much data to keep it all stored in Excel) ... (more)

error message 3704 (by Ian T on 3 Jun 2004, 1 reply)
could someone please tell me how to fix this error? Many thanks Ian Tucker ... (more)

Exports and decimals (by Ben Jammin on 3 Jun 2004, 3 replies)
Anyone know how to export a table to a text file and get more than 2 decimals? ... (more)

Unicode text column (by Dianna on 3 Jun 2004, no replies)
When running a query in Access 2003, I got the following error. ... (more)

Outlook Calendar importing (by Eric Blitzer on 3 Jun 2004, no replies)
We use Internet mail calendar sharing. I have no problem importing my own calendar to an Access table however when I try to import shared calendars of ... (more)

"Invalid Argument" Error Message (by Tammy on 3 Jun 2004, 1 reply)
I get this message when trying to look up stuff in a database that I am using. The database, however is over 2 gig and there are several memo fields in the tables. I have eliminated the problem in some tables by removing the ... (more)

VBE Code Modules will not stay closed (by Tony_VBACoder on 3 Jun 2004, 2 replies)
In Access 2002 (SP2) with WinXP, why won't my code modules stay closed when I close Access? If I open up code behind forms or Modules and close each window, the next time I open Access and go into my VBE and select "Window", I have ... (more)

Subdatasheet in 2003 with linked tables (by Scott on 3 Jun 2004, no replies)
I have an Access FE db with a SQL BE db. For any local table in the FE I can insert a subdatasheet and manage it just like I have in previous versions. But the insert option is grayed out for a linked table. ... (more)

data access (by jatwa on 3 Jun 2004, 3 replies)
The file of type txt is not available in access97. I removed office 97 and performed custome install, during the intallation it showed text and html drivers were installed and they were checked and gryed out. How could ... (more)

I also have a question about main and subform !! (by =?Utf-8?B?Smlt?= on 3 Jun 2004, 3 replies)
Hi, field1 = department field2 = salesman ... (more)

SCC support (by =?Utf-8?B?S3dhbGl0eSBBc3N1cmFuY2U=?= on 3 Jun 2004, no replies)
I was wondering if anybody knew if source code control was still available for Access 2003? ... (more)

Migrate VIEW from Access to SQLserver ??? (by YURYSSG on 3 Jun 2004, 1 reply)
I migrated a DB from Access 2000 to SQLserver 2000. The tables are OK, but I see the old Access views... as TABLE in SQLserver!! ... (more)

Text Totals (by =?Utf-8?B?dGhlaGVkZ2Vob2c0Mg==?= on 3 Jun 2004, 2 replies)
I am trying to total up the number of times certain words are used in a column of my Access table. I can figure out how to total numbers, but not how to count the number of times a word appears. I've tried using a report and a query, but I can't figure out a way to count text. Thanks, Ashley ... (more)

DLookup (by =?Utf-8?B?QXJ0aHVy?= on 3 Jun 2004, no replies)
Ok, I'm suicidal.....this dlookup is doing me in. It seems so simple or should that be me? I have a form - FrmTransactions field - From Suburb (combo box ) text ... (more)

Deleted Data (by =?Utf-8?B?SG9sbHk=?= on 3 Jun 2004, 1 reply)
I accidentally deleted a whole table in one of my databases. I lost all the information that took me hours to input. Does anyone know how I can restore the data? If so, Please email me. ... (more)

Recordset is not updateable (by =?Utf-8?B?TWFyayBQZXRyb3NraQ==?= on 3 Jun 2004, 2 replies)
I am currently building a database. I used the wizards and they work well. However, I am unable to input data into the forms. I reviewed MS Access help feature and all settings are correct for editing data on a form: Record Locks - No Locks, Record set type - Dynset. The two tables in the query are one to one, linked by the last name. I reviewed the topics in this discussion group with no success. Any other help would be appreciated. ... (more)

Recordset is not updateable (by =?Utf-8?B?TWFyayBQZXRyb3NraQ==?= on 3 Jun 2004, 2 replies)

I am currently building a database. I used the wizards and they work well. However, I am unable to input data into the forms. I reviewed MS Access help feature and all settings are correct for editing data on a form: Record Locks - No Locks, Record set type - Dynset. The two tables in the query are one to one, linked by the last name.
I reviewed the topics in this discussion group with no success. Any other help would be appreciated. ... (more)

Ole server error when trying to insert sound file in table (by =?Utf-8?B?cmp1ZGdl?= on 3 Jun 2004, 2 replies)
The Operation on the OLE object failed The Ole server may not be registered To register the Ole server, reinstall it ... (more)

DB field of type Date (by Hans on 3 Jun 2004, 1 reply)
I have a DB field of type Date (dd-mm-yyyy) The contents of this field is the birthday ... (more)

Login to DB (by Antonio on 3 Jun 2004, no replies)
Good morning everybody...I am thinking about creating a login screen for users to log into the databse. Can somebody point me in the right direction? Thanks ... (more)

Convert Date (by =?Utf-8?B?U2Ft?= on 3 Jun 2004, 2 replies)
Hi, I have a date (i.e. 970401 = 1st April 1997 - UK) how could I convert this to a date? Is there a function that would do this for me? And where’s the Knowledge Base on Microsoft’s site gone? Many thanks ... (more)

How can I contruct a "READ ONLY" query (by =?Utf-8?B?V0MgTG8=?= on 3 Jun 2004, 4 replies)
I have a form with a query. Usually when the form is close or change of record, the query will update the database. is it possible to build a read-only query? thanks ... (more)

Data Access Page Problem (by =?Utf-8?B?RGVsZiBNZWVr?= on 3 Jun 2004, 1 reply)
hello all, I'm new to Data Access Pages, and am trying to deploy a simple data access page on the internet. ... (more)

Disable the mouse wheel (by =?Utf-8?B?QmVu?= on 3 Jun 2004, 1 reply)
When we scroll the mouse wheel, it means retrieve/fetch another record. Can we ignore / disable the mouse wheel? ... (more)

Calculated Field with Criteria? (by =?Utf-8?B?S2F0aWU=?= on 3 Jun 2004, 7 replies)
I have a query that has a field created on-the-fly (it picks the first 8 characters of a field) and works fine when I run the query. However, if I add a criteria such as between [startdate] and [enddate] the query says it is too complex. I ran a watch and the between [Forms]![frmName]![txtStartdate] and [Forms]![frmName]![txtEndDate] have proper dates. How can I make this work? I've been pulling out my hair on this trying to solve it! ... (more)

Calculated Field with Criteria? (by =?Utf-8?B?S2F0aWU=?= on 3 Jun 2004, 7 replies)

I have a query that has a field created on-the-fly (it picks the first 8 characters of a field) and works fine when I run the query. However, if I add a criteria such as between [startdate] and [enddate] the query says it is too complex. I ran a watch and the between [Forms]![frmName]![txtStartdate] and [Forms]![frmName]![txtEndDate] have proper dates. How can I make this work? I've been pulling out my hair on this trying to solve it! ... (more)

Report Type (by =?Utf-8?B?TWF0dA==?= on 3 Jun 2004, 2 replies)
If the object type of a query is 5, what is the object type of a report? Or anything else for that matter. Thanks! ... (more)

Connecting to Exchange via a linked table (by Mike Fellows on 3 Jun 2004, no replies)
Hi, Im trying to use an access DB to link to one of my exchange public folders, all my other public folders work fine except this one ... (more)

Access 2003 Runtime for Win98 (by =?Utf-8?B?QnJldA==?= on 3 Jun 2004, 2 replies)
Am I right in my understanding that there is no way to get the Access Runtime 2003 to work on a Windows 98 machine? ... (more)

Creating a Surver (by =?Utf-8?B?VGVk?= on 3 Jun 2004, 1 reply)
Hi, I need to create a survey/poll. The poll will be conducted from my PC not online. i.e. people will use my Pc to fill in the survey. I need the results to be stored in access etc. Does anoyne know of a survey templete for Access/Word? Thanks a Mil ... (more)

after updating or entering a comment, the date is entered into that comment (by =?Utf-8?B?UnV0aA==?= on 3 Jun 2004, 1 reply)
Date Stamp: after updating or entering a comment, the date date is entered into that comment (modification date) Help please! Ruth ... (more)

Combo Box Query Value (by =?Utf-8?B?TWF0dA==?= on 3 Jun 2004, 3 replies)
I was wondering if there is a way to be able to choose which queries I want in the drop down box instead of all of them. The code is below that I have to receive all queries in the drop down box. Thanks, ... (more)

risk assessments (by =?Utf-8?B?ZGVuaXNlIHBlcmVsbGk=?= on 3 Jun 2004, 1 reply)
is there any body out there that knows how to do a risk assessment in the forklift industry ... (more)

Query Problems (by =?Utf-8?B?THVjeQ==?= on 3 Jun 2004, 1 reply)
I'm new to using Access. I am trying to build a calulation for a query. I am having a building the correct calulation because I don't know how it works. Does anyone know were I can get detailed information on building a caluation for a query involving tables? ... (more)

Visual Basic Error (by =?Utf-8?B?R2VvZmZU?= on 3 Jun 2004, 1 reply)
i am using office professional 2003 on a xp professional operating system. When I open my main database in access 2003 I now get the following error message in visual basic debugger = "set dbs=CurrentDb()" Compile error - Error in loading dll. The above relates to the switchboard form. If I try to load the swithboard manager I get the message ActivX component cant create object. ... (more)

Access subdata sheet (by =?Utf-8?B?SmF5IEpvbmVz?= on 3 Jun 2004, 2 replies)
I am creating a Video Collection in Microsoft Access. I have a subdata sheet that provides brief details of each movie, but each movie that i have in the list shows the same detail that does not pertain to the specific movie. Can anyone help???? ... (more)

FindFirst (by =?Utf-8?B?TG9sbGk=?= on 3 Jun 2004, 2 replies)
FindFirst is available for DAO only, what is the equivalent in ADO ? ... (more)

linked table manager (by =?Utf-8?B?VklDVE9S?= on 3 Jun 2004, 3 replies)
í want to know if there is a way to refresh the linked table automatically, i mean by a macro or something. and how can a i make this, thanks for your answers ... (more)

Data Access Pages (by =?Utf-8?B?TWljY2E=?= on 3 Jun 2004, no replies)
I am running an Access 2000 database on a Server 2003 box with iis6. I have created a Data Access Page (DAP) from Access and have it saved in the same folder as the mdb file. The page works fine when I open the DAP on the server from the folder, but I only get the page formatting when I access the DAP page from the web. I can see the mdb file in the directory listing from the web, and I think I have all the necessary permissions set up and the folder is set to allow execute and scripting. Any ideas? ... (more)

Data Access Pages (by =?Utf-8?B?TWljY2E=?= on 3 Jun 2004, no replies)

I am running an Access 2000 database on a Server 2003 box with iis6. I have created a Data Access Page (DAP) from Access and have it saved in the same folder as the mdb file. The page works fine when I open the DAP on the server from the folder, but I only get the page formatting when I access the DAP page from the web. I can see the mdb file in the directory listing from the web, and I think I have all the necessary permissions set up and the folder is set to allow execute and scripting. Any ideas? ... (more)

Time conversion and calculation (by =?Utf-8?B?RXJpYyBTdGVwaGVucw==?= on 3 Jun 2004, 1 reply)
30 (which equals 30 minutes) 100 (which equals 1 hour) 130 (which equals 1 hour 30 minutes) etc. ... (more)

Distributing an MDB file with my ADO.NET App (by =?Utf-8?B?QWxhbiBMZXc=?= on 3 Jun 2004, 1 reply)
I've created an MDB file using a copy of Access. Would I be allowed to distribute that MDB file with my ADO.NET application if I simply include the MDAC redistributable? Or must I include a runtime version of Access? Thanks. ... (more)

Data Access Page - data definition corruption (by =?Utf-8?B?Q0hJ?= on 3 Jun 2004, no replies)
Upon opening Access 2002 SP1, I select "create blank data access page" from the menu on the far right. I receive the following error: The data defintion of this data access page has been corrupted and can't be repaired. You must recreate the page. Save has been disabled. I have reinstalled Access and still receive the error. Again, this is from scratch just trying to create a DAP. Any ideas? Thanks very much ... (more)

Data Access Page - data definition corruption (by =?Utf-8?B?Q0hJ?= on 3 Jun 2004, no replies)

Upon opening Access 2002 SP1, I select "create blank data access page" from the menu on the far right. I receive the following error: The data defintion of this data access page has been corrupted and can't be repaired. You must recreate the page. Save has been disabled.
I have reinstalled Access and still receive the error. Again, this is from scratch just trying to create a DAP. Any ideas?

Thanks very much ... (more)

How to compare data in one field for different records. (by =?Utf-8?B?U29waGlh?= on 3 Jun 2004, 1 reply)
I want to compare the date in one field in a table for different records. How to write the query? ... (more)

Run command (by =?Utf-8?B?Sk1vcnJlbGw=?= on 3 Jun 2004, 2 replies)
Does anyone know a quick-key sequence to run a query? I don't like to use the mouse to hit the "!" in a query screen and think there must be a key stroke to do it. tia ... (more)

Custom msgboxes (by =?Utf-8?B?RGFuaWVsIFA=?= on 3 Jun 2004, 5 replies)
Hello, Can anyone tell me if it is possible to use user (me) specified images/icon in a msgbox. Instead of the usual information, exclamation .... I would like to use some custom made images.... Can this be done and if so how? ... (more)

Database corruption (by =?Utf-8?B?TS4gR2FyY2lh?= on 3 Jun 2004, 3 replies)
Good day, Ever since our company moved to WinXP, our shared access databases are going crazy. ... (more)

ODBC Connection (by =?Utf-8?B?Q2h1Y2s=?= on 3 Jun 2004, no replies)

I have an Access 2000 mdb using an ODBC connection to a MSDE db. I am able to create the ODBC connection on 3 out of 5 client PCs. On the 2 others I get a SQL Server 11004 error refering to [TCP/IP sockets]. All PCs are Windows 2000. The only difference is the second window of the ODBC Wizard under the Client Configuration button, the PC's that are working have the Dynamically Determine port checked under TCP/IP and the 2 that are not working do not even have that option but have an IP address in the Port number field?
Why do I not have the Dynamically Determine port option for TCP/IP on these 2 PC's?? Is this my problem?
Thanks
Chuck ... (more)

Access 97/Jet database engine problem (by Maggic on 3 Jun 2004, 2 replies)
"The Msoft Jet dbase engine stopped the process because you and another user are attempting to change the same data at the same time". I am using a stand alone system and can't figure out why I get this msg or ... (more)

a elemental question (by knit on 3 Jun 2004, 4 replies)
can I know from you how many records one access database can have? I have over 10,000 pieces of records, can I use Access to manage these records? ... (more)

APPLE MCKINTOSH (by Domingo Ib��ez on 3 Jun 2004, 1 reply)
I WOULD LIKE TO HAVE SOME REFERENCES ON HOW TO CONFIGURE AN APPLE MCKINTOSH FOR AN ITERNET CONNECTION. ... (more)

"Jet database engine could not find the object" when trying to open a *.mdb file. (by David Battams on 3 Jun 2004, 1 reply)
Hi there, I get an error with the following message when trying to open a certain access database file. Error happens when I try to open the file by double ... (more)

Immediate Opportunity for Access Expert! (by Ross Culver on 3 Jun 2004, no replies)
We're looking for an Access expert (which implies a VBA, Access project & SQL expert) in the Houston, TX area. Part-time, full-time or contract is possible. ... (more)

Split database (by Mark on 3 Jun 2004, 2 replies)
Hi there. I'm trying to change an access DB created by someone else (only need to add a couple of fields). However is proving more difficult than i imagined. ... (more)

Immediate Opportunity for Access Expert! (by Ross Culver on 3 Jun 2004, no replies)
We're looking for someone with excellent MS Access skills (which implies that this person has VBA, Access Project, and SQL skills) in the Houston, Texas area. ... (more)

Uniformed Patrolling (by Polynesian Girl on 3 Jun 2004, no replies)
The motherboard offers expansion slots where you inset cards or adapters, including expansion cards for adding new components to your PC. Most PCs come with some slots already filled. For example, your monitor attaches to a video card that's plugged into one slot. The remaining slots are for adding ... (more)

Re: Drawing Shapes on Forms ? (by Stephen Lebans on 3 Jun 2004, no replies)
http://www.lebans.com/imageclass.htm ImageClass has been replaced by the PictureBoxA97 project. A standard Image control is wrapped within a class to allow the control to resemble the standard Visual Basic PictureBox control. Simple drawing methods are ... (more)

crosstab query (by ryanb. on 3 Jun 2004, no replies)
Can anyone tell me why I cannot link word or excel to a crosstab query in access? Both word and excel see all other queries in the database except the crosstab. ... (more)