| Newsgroup Index | prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next | last |
| Help! My database wont open (by zoe on 6 May 2004, 1 reply) |
|---|
|
When trying to open a database in access 2000, which has a database password set, i get the message "Resource library.mdb needs to be repaired, or isnt a database file" "You or another user might have unexpectedly quit microsoft access, while a microsoft access database ... (more) |
| Problem with import wizard (by Michael W White on 7 May 2004, 6 replies) |
|---|
|
I'm using Access 2002 on a Windows XP Professional machine. I'm attempting to import an text file into Access using the Import Wizard. I cannot change the field names. When I change a field name, the name is applied to the first field. I select another field besides the first field and attempted to ... (more) |
| Newbie Question (by Maggic on 7 May 2004, 10 replies) |
|---|
|
I know how to duplicate information from a field say "service date" to the same field in subsequent records i.e. by pressing the Control & quote key together during the data entry process. However I would like to do this automatically by using an event procedure, but don't know how to program it ... (more) |
| Re: using Access with SQL Server?? (by david epsom dot com dot au on 7 May 2004, no replies) |
|---|
|
SQL Server bit fields are 3 state by default: Yes No Null Jet 4 does not support 3 state bit fields. When you connect Access to SQL Server, all bit fields with ... (more) |
| Page Down Key (by =?Utf-8?B?U2hhcnJvbg==?= on 7 May 2004, 2 replies) |
|---|
| When I am entering data, and do not need to fill in every field, I hit the page down key to go to the next new record. However, the cursor remains in the last field that was entered. How do I default the cursor to go to the first field when the page down key is entered? ... (more) |
| Mysteriously lost data (by Que Gatlin on 7 May 2004, no replies) |
|---|
|
We are having the exact same problem with a shared Access 2002 database. Have you received any solutions yet? I'd be grateful if you or others could share any information. Many thanks. ... (more) |
| RE: Access MDB on network is read only (by =?Utf-8?B?cm9i?= on 7 May 2004, no replies) |
|---|
|
I am having similar problems with an Access database. Were you able to solve? Thanks, Rob ... (more) |
| Compact/Repair and Deleting Table Entries (by =?Utf-8?B?R2F1cmREb2c=?= on 7 May 2004, 1 reply) |
|---|
| I have a db that will not compact even with jetcomp4.0. I have tried deleting entries in the table, but there are a few dozen that will not delete and appear to be missing some information. Does anyone have any ideas on how I can repair and compact, or delete the entries that appear to be giving me problems? Thanks in advance. ... (more) |
| Re: Connecting to Oracle Database - macro fail. (by jamiee on 7 May 2004, no replies) |
|---|
|
I still get the same message. Could it have anything to do with the Trusted Resoureces Parameter? What does this do exactly? and where does it go in connection string? ... (more) |
| Re: Query for address field. (by =?Utf-8?B?Z3NpZWJl?= on 7 May 2004, no replies) |
|---|
| Any hints on how to do that, and may generate an even/odd field at the same time? ... (more) |
| REVOLUTIONARY INTERNET TEAM! (by Pandi Stephen on 7 May 2004, no replies) |
|---|
|
REVOLUTIONARY INTERNET TEAM! 30 Days "FREE" Training WILL change the way business is done on the net. WE HELP OTHERS. ... (more) |
| splitting up a field? (by =?Utf-8?B?Z3NpZWJl?= on 7 May 2004, 7 replies) |
|---|
|
I have a table with an address formatted as "1234 some street name" I want to add three colums to the table for stnum, stname, and even/odd. ... (more) |
| Question about Read-Only (by =?Utf-8?B?UmFjaGVsQ2hyaXN0aW5l?= on 7 May 2004, 4 replies) |
|---|
| Recently my husband and I reformatted our computer, backing everything up first. Well, I opened up my access file today and it's opening as a read-only file! I tried going into properties and unchecking read-only, but it won't let me. Is there anything I can do? A way I can resave it as a non-read only or copy and paste it into a whole new database or SOMEthing? It's hours and hours and hours of work. I'd hate to have to start over. ... (more) |
| Startup Menus Disappeared (by =?Utf-8?B?amJveTE3MTdAYW9sLmNvbQ==?= on 7 May 2004, 1 reply) |
|---|
|
Hello everyone, I was playing around with my Access file yesterday, and under the Tools menu - the Startup option - I went into that and turned off shortcut menus when Access opens. I turned another menu off also I think. Basically I unchecked both the boxes that were there to see what happens. Now when I open my Access file, I have no way to make changes to any tables or anything. The previous "Tools" menu is gone, all I have is Files, Edit, Insert, Records, Window, and Help menus. I tried searching the Office Help guide for answers, but could not find anything. Does anyone know how I can get my menus back and get back to how my file used to be? ... (more) |
| Access Error - Created in an older version of Access - Need update (by =?Utf-8?B?UGF0IE1jYXRo?= on 7 May 2004, 2 replies) |
|---|
|
This morning I opened my database up and was working in it and then an error came up saying I needed to update to a newer version or somthing like that... I have had this database for over a year and have not made any changes? What do I do? Please help. ... (more) |
| Error Access2000 (by =?Utf-8?B?U2t5?= on 7 May 2004, 2 replies) |
|---|
| Double Click some Table in Access2000 I found This object requires a newer version of the Micresoft Jet database engine. ... (more) |
| IIf statement with two or more choices (by =?Utf-8?B?a3dfdWg5Nw==?= on 7 May 2004, 2 replies) |
|---|
|
Is there a similar function to the IIf function for more then two options or do I have to do some complicated programming to get my results. Here is my table and values [STATUS] ... (more) |
| netmeeting? (by jen on 7 May 2004, 2 replies) |
|---|
|
Hi, Does anyone know if there is a site that I can post my windows netmeeting questions? Thanks, ... (more) |
| hi i'm new (by me on 7 May 2004, 1 reply) |
|---|
| This is a good program. ... (more) |
| Read-Only (by Larry on 7 May 2004, 2 replies) |
|---|
|
I worked on a database at home, burned it to CD and copied it over to my computer at work. When I open the Database, it says its read only, and won't allow me to make any changes. How come? ... (more) |
| Combo Box ? or Any other way to do this? (by Brad on 7 May 2004, 2 replies) |
|---|
|
I have created two combo boxes in a form that look up data from two seperate tables and then add that info into a third table. ... (more) |
| Access 97 database problem (by Dan on 7 May 2004, 1 reply) |
|---|
|
I run a database from Access 97 and recently installed Publisher 2000. After having done this, the access database appears to have missing fields which I can no longer view. The database is on a network and still works ... (more) |
| Access 2000 -- Service Pack (by Kevin on 7 May 2004, 1 reply) |
|---|
|
I have Access 2000 (9.0.2720) running on Win XP Professional. I have no service packs on Access. I want to get to SP3. I keep getting error message, teling me to call Microsoft, when I try to install SR-1A which appears ... (more) |
| Bloating of ACCESS2000 Dbase (by Slucci on 7 May 2004, 3 replies) |
|---|
|
I have a dbase that stores digital pictures seperate from my data file. These pics (OLE objects) are combined with data to create reports that include digital pics. I have a picture database with 275 .jpg pics with an average size ... (more) |
| I have a need to print username (by Kamy on 7 May 2004, 3 replies) |
|---|
|
I have a need to print the username in report, Can someone tell me how to do so? Thank you in advance, ... (more) |
| Converting back end data to SQL database tables (by Denise on 7 May 2004, 3 replies) |
|---|
|
Is this something that a novice SQL user can do? I heard that SQL will help to stabilize a multi-user database that is being strained. ... (more) |
| Missing reference (by Laura on 7 May 2004, no replies) |
|---|
|
I'm trying to correct a missing reference called Jetsql35.TLB version 3.5. My "Available References" list doesn't include a Microsoft Jet SQL help reference. Does anyone know where can I find this file? ... (more) |
| Access Licensing (by Richa on 7 May 2004, 3 replies) |
|---|
|
How does Access licensing work? If we have 500 users out of which about 200 use the same mdb files. But sometimes these users may want to build their own reports. ... (more) |
| SendObject using Rich Text Format (by =?Utf-8?B?TWFyaW8=?= on 7 May 2004, 2 replies) |
|---|
| When using Send Object in a macro with a Rich Text Format, the email stalls out and is never sent. How do I fix this? ... (more) |
| Re: Button code (by =?Utf-8?B?Uks=?= on 7 May 2004, no replies) |
|---|
|
Gotta to love the typos . . . RK ... (more) |
| WINKINC desgin (by winkinc@sympatico.ca on 07 May 2004, no replies) |
|---|
| this format, some or all of this message may not be legible. ... (more) |
| HELP PLEASE (by Alistair on 07 May 2004, no replies) |
|---|
|
HELP I have an NEC express5800/110PRO/5 I reset the CMOS and canot get into the computer it says: Warning IRQ not configed pci on mother board Bus oo Device 02 Func 02 ... (more) |
| Labels in Word Tools (by =?Utf-8?B?anVsaWE=?= on 7 May 2004, 1 reply) |
|---|
| Why did the blue lines outlining each label on a New Document labels page disappear and how do I get them back? ... (more) |
| Convert numeric values into words (by =?Utf-8?B?UE1L?= on 7 May 2004, 3 replies) |
|---|
|
Is there any code available that allows you to convert numeric values into actual words? If there is. How and where do you place this code. ... (more) |
| Access Database (by =?Utf-8?B?ZGFtaWNv?= on 7 May 2004, 2 replies) |
|---|
| My granddaughter accidently replicated a database for school project & we need to reverse this or make a copy that is not a replica. Does anyone know what to do to help? Any suggestions would be greatly appreciated. ... (more) |
| narration won't fully run (by D Rojas on 7 May 2004, 1 reply) |
|---|
|
I have recorded several narratives on slides, but when I view the slide show it cut-off the narration on each slide and them moves on. I have tried reseting the transition of slides, but nothing works. ... (more) |
| App path (by John on 7 May 2004, 3 replies) |
|---|
|
Hi How can I get the path of the current access app programmatically, within the same app? ... (more) |
| Re: Mysteriously lost data (by Lynn Trapp on 7 May 2004, 1 reply) |
|---|
|
Denise, Is it possible that there are different copies of the backend database and that the links have been messed up, so that changes were made to the wrong backend? ... (more) |
| Microsoft Jet 4.0 Service Pack 8 (by Boris on 7 May 2004, 7 replies) |
|---|
|
When I open Microsoft Office Access 2003 I am recommended to update to Microsoft Jet 4.0 Service Pack 8. According to http://support.microsoft.com/default.aspx?scid=kb;EN-US;829558 in Service Pack 8 Msjet40.dll's version is 4.0.8015.0. The Msjet40.dll I find on my ... (more) |
| My Computer Is Ill (by Rob on 7 May 2004, 1 reply) |
|---|
|
When i started my computer today all english language was replaced by symbols. you can't read anything, all menus are the same. all i can recognize are icons. does anybody know why this is and can you help ... (more) |
| Help files 2002 vs 97 (by Bill on 7 May 2004, 14 replies) |
|---|
|
I've run access for ten years and only just switched from 97 to 02. Am I missing something or is help rearranged/dimished? ... (more) |
| Access query (by Judy on 7 May 2004, 3 replies) |
|---|
|
I want to join two or more text fields into one field. When I run my query I'm only getting the first field and not others. This is what I tried. Expr1:[des1]+[des2] and I tried Expr1:[Des1]&[des2] ... (more) |
| Formatting a calculated field in a query (by K. Georgiadis on 7 May 2004, 3 replies) |
|---|
|
I have added a calculated field to a query, using an expression. How can I format this new field so that it displays the results in currency format? In the Property sheet, I see no formatting options for this new field. ... (more) |
| In over my head RE: charts (by Averil Pretty on 7 May 2004, no replies) |
|---|
|
Hello, As the subject suggests, I'm in a little over my head here. I have to have this working for a meeting on Monday ... (more) |
| Search engine source (by ANSWER on 7 May 2004, 1 reply) |
|---|
|
Hi, Does anybody have Dictionary search engine for (MS Access, C++ or other) who can sed it to me. ... (more) |
| My computer is ill part 2 (by rob on 7 May 2004, 1 reply) |
|---|
|
i did a system restore(see my other message) that fixed it, but wether it was the right thing to do or not i don't know ... (more) |
| big database (by bev on 7 May 2004, 6 replies) |
|---|
|
can i run a big database using access 2003? 5 users, maybe 1 millions records? if not, what else could i use? someone mentioned MSDE, but i dont know what ... (more) |
| Normalization! (by Niklas Östergren on 7 May 2004, 2 replies) |
|---|
|
Hi! I´m having a little of a problem with the normalization of one table in my db. It´s a db storing data of people that our organisation are in contact ... (more) |
| Concatenation a value with string on a report (by kw_uh97 on 7 May 2004, 2 replies) |
|---|
|
Hello All I have a field that contains single character values ie ... (more) |
| Time Syntax in query (by John on 7 May 2004, 4 replies) |
|---|
|
Hi I am using the this time syntax in an acess query; iif([Setup Time]>=#12:00:00 PM#,"PM","AM"). Problem is that I am getting error on the ... (more) |
| Re: Calling ALL Access gurus ... "Come and have a go if you think your smart enough" ! (by Nikos Yannacopoulos on 7 May 2004, no replies) |
|---|
|
A basic scenario (just for calculating the pricing) would involve at least four tables: CUSTOMERS ... (more) |
| cookies (by Andrea Pruitt on 7 May 2004, no replies) |
|---|
|
Need help. cookies don't work, and they are turned on to accept all cookies. How do I delete OSC22 cookies file? ... (more) |
| Re: upgrading to Access 2003 (by Larry Linson on 7 May 2004, no replies) |
|---|
|
access 2003 from access 2002? Just about all the changes in Access 2003 were bug-fixes and Office-cross-application enhancements -- with the enhancements mostly ... (more) |
| Auto-certificating Access 2003 mdbs (by Christopher Mackie on 8 May 2004, 1 reply) |
|---|
|
We're looking for a solution that will let us add certificates automatically to a large number of 'legacy' mdbs, in order to enable our organization to set Office 2003 security levels to 'high' across the enterprise. The numbers of files involved are too large, and the need too ongoing, to permit ... (more) |
| Re: What is the best MS Access 2002/3 XP book out there ? (by DesC on 8 May 2004, 1 reply) |
|---|
|
Does anyone know if there is an updated version of Stan Leszynski's Access 97 Expert Solutions out there anywhere? "A" <exit@space12345> wrote in message ... (more) |
| Langston Hughes (by =?Utf-8?B?cG9lbXM=?= on 8 May 2004, no replies) |
|---|
| do you have ant oems on him ... (more) |
| Kicking users out of my DB (by Damien McBain on 8 May 2004, 4 replies) |
|---|
|
Is it possible to kick other users out of my Database so that I can open it exclusively if I need to? ... (more) |
| Newby Needs Help (by Leo Janysek on 8 May 2004, 1 reply) |
|---|
|
The facility where I work has about 500 "pattern keys" that between them will open every lock on the facility. We then have about 125 key rings made up of copies of the pattern keys. Our policies state that I must have a printed form for each key ring, and that each key ring can have no more than ... (more) |
| Random Pull (by =?Utf-8?B?VGFzaGE=?= on 8 May 2004, 1 reply) |
|---|
|
When I pull a query I want to colume to have a random order? Any one help on this? ... (more) |
| Database Will Not Open by Double-Click (by =?Utf-8?B?SW1wZXhpcw==?= on 8 May 2004, 1 reply) |
|---|
|
"MS Access cannot open this file. This file is located outside your intranetor on an untrusted site. MS Access will not open the file due to potential security problems. To open the file, copy iy to your machine or an accessible network." The file is already on the local machine (in fact it is on the SBS 2003 server, and I am logged on as Administrator, but still the same problem). I CAN open it by double clicking the mdb or short cut to it from another computer on the network! ALso odd, is that I can use "file open" from within Access, and there is no problem, but this is not the way we wish to work. Why does this problem happen at all, why does it happen to just some of the databases, and how do I fix it? ... (more) |
| Newsgroup Index | prev | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next | last |