| News Index | first | prev | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | next | last |
| Cannot open database file - Err 3197 (by Luke Bellamy on 10 May 2004, 6 replies) |
|---|
|
Hi, I have a Access2002 mdb file that I cannot open and I am 100% sure no one else has it open. 3197 - The Microsoft Jet database engine stopped the process because you and ... (more) |
| MSDE SQL Update Stored Procedure Syntax (by Admin on 10 May 2004, 1 reply) |
|---|
|
I have 2 tables, table A and B. Table A has the following fields; Phone (nvchar), Fname (nvchar), Lname (nvchar), DNC (bit). Table B has one field PhoneNo (nvchar). I would like to update the field DNC to True if the values Phone in Table A = PhoneNo in Table B. ... (more) |
| Transporting database file (by =?Utf-8?B?ZmVycmVsbA==?= on 10 May 2004, 1 reply) |
|---|
| I have several remote locations - stand alone computers. Developing data base and forms in office. When I try to save to cd (nero express) it always ends up in "read only". Have changed permissions, its not marked read-only. I want to be able to save a single entry database with the form and physically transport it on a CD to the remote location for them to use the form with the database attached. ... (more) |
| Modifying Top Values Property in Query Automatically (by =?Utf-8?B?RVdSSUdIVA==?= on 10 May 2004, 4 replies) |
|---|
| Is there a way to use a macro/form/VBA to update the number in the top values property on a query, based upon another queries returned value? I am trying to return x number of records from a list table, but if that list table gets below x, then it will have to pull the difference between the remaining records and x from another list table. ... (more) |
| User Names and Table Fields (by =?Utf-8?B?U0NITllERVM=?= on 10 May 2004, 1 reply) |
|---|
| Is it possible to have a person's user name autopopulate a record in access? Take for example I'm trying to save notes that someone would type into the system..is there a way I could have their user name autopopulate as the person who entered the note? Any help would be great with my security with access. ... (more) |
| Switchboard Drop down menus (by =?Utf-8?B?QW15?= on 10 May 2004, 1 reply) |
|---|
| I have a report that runs in a Switchboard. I need to have a dropdown menu appear before the report runs to pick a parameter. I have a seperate table with the items that need to go into the dropdown. Please help. ... (more) |
| Trying to open an Access 97 DB using Visual Basic (by MurrayK on 10 May 2004, 2 replies) |
|---|
|
Good Day, I was wondering if anyone could point me in right direction. I'm trying to open a shared Access 97 (DAO/ADODB??) database using Visual ... (more) |
| Help with some table structure! (by Niklas Östrergren on 10 May 2004, no replies) |
|---|
|
Hi! I have earlyer, last week, posted a msg "Normalization" in which I asked two Q. One of them is now solved but I still have one small problem left. But ... (more) |
| Calculating total from subform on the main form (by Polly on 10 May 2004, 3 replies) |
|---|
|
Hello! I'm a little new to Access, but do have a fairly good knowledge (all self taught). I get lost quite easily with visual basic, but can work ... (more) |
| prompts (by Susie on 10 May 2004, 1 reply) |
|---|
|
A couple of related things...I have a macro that runs when I open the database that appends a query. When I open the database, I get prompts telling me I am about to append a table, is this OK. I also have a query that runs daily ... (more) |
| unexpected error from the extern database controler (12034) (by Lizette on 10 May 2004, no replies) |
|---|
|
I had paradox tables vinculated in access 2000, I worked out without any trouble, until I deleted from the access and tray to vinculate them again, and it sents me the error, anybody has answer to this problem?? ... (more) |
| greyout fields (by John on 10 May 2004, 1 reply) |
|---|
|
Hello, I am trying to create database for the first time, and one of the things I need it to do is to hide or geayout some of the fields dependant on a tick being places in ... (more) |
| SQL statement not working properly (by Antonio on 10 May 2004, 5 replies) |
|---|
|
Good morning, all, I am trying to get the e-mails of all the customers that subscribe to a title and that are sql = "SELECT CustomerDB.[E-mail Address] FROM CustomerDB WHERE CustomerDB.SubscriptionTitle1 ='" & ... (more) |
| can't find msysdb (by dolfan1873 on 10 May 2004, 2 replies) |
|---|
|
i am getting a error message can not find msysdb, check spelling and path when i try to open a database. the database is about 2 years old and in constant use, this message just started and can't get into the database. ... (more) |
| Loop For Next in a shell (by GolfBag on 10 May 2004, 5 replies) |
|---|
|
I want to use Access to open a shell to another program and I can do that. Now I want to use send keys which will work on one instance, but I really need to do a for I = 10 kind of thing so I can get it to send the series of keys ... (more) |
| hyperlink problem (by Aaron on 10 May 2004, 1 reply) |
|---|
|
I need to import an Excel spreadsheet that has fields storing hyperlinks. How do I retain the path so that they will open from Access. I had a problem in the past where the path was no longer recognized and I'm not sure what I ... (more) |
| Issue after Upgrade (by Lauren on 10 May 2004, 3 replies) |
|---|
|
Problem Description: I just upgraded my system to Office 2003 and I seem to be having a couple of issues with going 1. While opening a database in Access 2003 that was created in Access XP, I get a error message that basically ... (more) |
| Browse through record at opening (by Antonio on 10 May 2004, 4 replies) |
|---|
|
Hello, everybody. Here's what I am trying to do: when a user opens the database, I would like it to go through all the record and put a checkmark in a Inactive account checkbox if the subscription date is < 0. Can somebody ... (more) |
| System text dimensions affecting Forms visualization (by Ale on 10 May 2004, 1 reply) |
|---|
|
I've noticed that large (instead of normal) text dimension (Set in Desktop Options) affect the visualization of my Access application. I've tried to run my application on a Windows 2000 ... (more) |
| Querry Date (by Robb on 10 May 2004, 1 reply) |
|---|
|
I understand how to do a date future date calculation on a form what I need it to do is to do the date calculation in the query so that I can see the data in the query lookup, as of now it only shows the future date calculation on the ... (more) |
| Combo box query (by Frank H on 10 May 2004, 2 replies) |
|---|
|
Can anybody help ? I have an unbound combo box on a form, displaying an ID & a Name field. Once I select a record from that combo I ... (more) |
| Access: Form width (by ANSWER on 10 May 2004, 1 reply) |
|---|
|
Hallo I have a database with main Form (width= 10cm and height= 5cm). When I open my database I want Access window to be same dimensions like my ... (more) |
| Replication conflicts (by Dave on 10 May 2004, 2 replies) |
|---|
|
This question is aimed at users of replicated databases. We have had recently a lot of Unique Key conflicts. Where the big keys in the tables (cant remember name) ... (more) |
| Re: Access crash!! (by John Vinson on 10 May 2004, no replies) |
|---|
|
Likely. Did you try my suggestion of creating a new database and importing everything? Do you have a lot of temp tables (which can cause bloating and instability)? ... (more) |
| Removing duplicates from a query (by Support on 10 May 2004, 4 replies) |
|---|
|
I have a query that looks at linked tables and outputs customers who have bought certain brands. The query works but I am getting duplicate results where the customer has bought more than one product of the same brand. What would be the best method of removing the duplicates from the result so ... (more) |
| Related Table View (by Phil Jones on 10 May 2004, 2 replies) |
|---|
|
Can anyone tell me How I change the view of related tables in table view? My current setting is to one table but I want to show another related table. ... (more) |
| A varible question? (by delolwai on 10 May 2004, 1 reply) |
|---|
|
Dim a as variant Dim rst as variant a = "AddNew" ... (more) |
| Unicode import problem (by Anthony on 11 May 2004, no replies) |
|---|
|
Hi All, I have some text files that I have been using monthly for years. Recently, our company upgraded to Access 2003, and now the files are seen as "unicode" ... (more) |
| Data entry doesn't work in Data access pages (by robeito on 11 May 2004, 2 replies) |
|---|
|
AllowAdditions= true AllowDeletions= true AllowEdits= true ... (more) |
| HOW TO LIMITATE NUMBER OF THE RECORDS IN A TABLE ? (by Chris on 11 May 2004, no replies) |
|---|
|
I need to limitate the number or the records introduced by a certain user in a table at a time ( let's say to 7) . Can it be done? How? ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 010984db-2eb2-4209-a7c4-dff393e23736 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 0ec73606-3a90-4904-8d29-3cda0346f88a ... (more) |
| error on opening switchboard manager after creating mde (by Sue R on 11 May 2004, 1 reply) |
|---|
|
I have created the .mde for an application.Now when I try The Microsoft Jet Engine cannot find the input table or query 'Switchboard Items' What does that mean and how can I modify the switchboard ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 1293d7e7-ea87-43b2-b509-6ea4ea1e74e3 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 133f1f59-d7c1-490e-9d5b-2a5137c97c37 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 16507b75-420a-4e57-9a87-b03bdf76201c ... (more) |
| add same data in mutiple records at once (by =?Utf-8?B?YWRyaWFueQ==?= on 11 May 2004, 3 replies) |
|---|
|
how do i add same data to mutiple records at same time? like to input data from the form and save button. save data will placed on mutiple records in one table/field ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 1ba58afd-3d43-4b33-8a8b-a830cfaf0643 ... (more) |
| Link (by =?Utf-8?B?U3RldmVD?= on 11 May 2004, no replies) |
|---|
|
I have a database on a pc and server, I have recently transfered the database on the new pc and and server, change the shortcut path on the destop on the pc, and changes the link between the pc and the server, the database is working until you click on on button so far inot the database, and i receive this message. '\\tfp 6\maindatabase\tables\TFPt_4-4_be.mdb' is no a valid path....how is this, when i have reset all the links though link manager., I have in the VB code, Call pathToTables Set db = DBEngine.OpenDatabase(StrDatasource)..this work in the other forms that i have.. ... (more) |
| Access question (by B.Etienne on 11 May 2004, 3 replies) |
|---|
| Is Access easy to learn ? ... (more) |
| Digitally signing (by =?Utf-8?B?Ti4gQ290dG9u?= on 11 May 2004, no replies) |
|---|
|
I have created an app with Access 2003 and have purchased a digital certificate from Thawte. I have used the VBA editor to sign the code and the certificate can be viewed sucessfully and shows that I have the private key. ... (more) |
| Subform (by =?Utf-8?B?bXdpbGw=?= on 11 May 2004, no replies) |
|---|
| I have a form with a subform. When I click the new entry button on my main form I want the subform to open to a blank record as well. I would also like a button on the subform to add addition entries for the current main form customer. Any help would be great. ... (more) |
| pulldown list in ascending order (by =?Utf-8?B?cmF3bGV5?= on 11 May 2004, 3 replies) |
|---|
|
I have a list of defects (~10). I have just added the 11th, which is right in the middle of the list, alphabetically. However, this shows up in the form (pulldown menu) in the order the codes were entered (by CodeID). How can I alter the form so that this pulldown shows the list in alphabetical order? Thanks! ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 4445482b-e4dd-46ea-b2d3-38abcf01fdea ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 47adebd8-9c11-4518-9211-c299ceabf002 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 4aed8798-67ac-466c-a409-f0936852f807 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 5dc59e76-98cd-4597-be46-9fdab13cf1dc ... (more) |
| Count (by =?Utf-8?B?YW50aG9ueQ==?= on 11 May 2004, 2 replies) |
|---|
| Okay, I have a quick question. I have a summation query, where it's supposed to count how many people are attending an event. When I use just the attendance table, where I did a group by using the conferenceID and count the PersonID, I have 80 people. However, if I link the attendance table with the person table, I get 79, which is the correct count. Does anyone know why? ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 61f8ca11-62da-42b6-bbeb-eb9c72f7e3c2 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 630819f4-c4ae-4760-af6a-48356254648a ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 6641e41a-2dee-43bd-b07c-eda507ba0897 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 66efe1c3-adee-4010-99c3-0d93db242d1e ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 70ab0520-ed2c-432c-b1cd-8c5081037d2d ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 7448d789-9aa5-4d43-a788-cc24bf5c8961 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 77623f47-0507-4444-8833-cef68f7740df ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 838436f9-6f2b-44a7-9381-442467385f2c ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 89b70b52-10e8-44a0-bb5a-c6ea7e107943 ... (more) |
| Best place to put FE db (by =?Utf-8?B?VGFzaGE=?= on 11 May 2004, 11 replies) |
|---|
|
I have a FE/BE multiuser Access db. About 100 people have access to this database but very seldom will more that 10 people be on at once. My dilema is where to put the FE database. I know it is best to give each user a copy of it. The problem is most of the users are very inexperience users. When sending out a new update the likely hood of it actually making it to the proper place on their system is slim to none. Mapping a drive would be like brain surgery to some of these people. (I'm not intending to be mean. I sent out a copy to about 10 people to test the db. I included a manual with pictures and very easy instructions on how to map the drive and where to put the database. I still ended up doing mapping the drive and installing the database on each system. This is not feasible when we roll the finished product out to our Customer Service group). I then tried just leaving the FE on the server and sending out the needed workgroup and a shortcut without a drive mapped just using \\server\file. However the place where the our dear IT dept decide to allot us is five folders down and slows up the db completely. I have attempted to have this put closer to the root but our IT people say it won't help so they won't do it. I have done every thing possible on the Microsoft Access Performance FAQ that is posted on this site many times except putting the SQL in the Form Load and unload events. This causes problems with other code in the db. Any suggestions as to how to A) improve the performance of the db or B)automatically update the database on each users system? Thanks!! ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 8da99bf8-c063-4348-aebb-42aa47872819 ... (more) |
| CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies) |
|---|
| 91ae6b87-150f-4d2c-ae47-320a74f975fd ... (more) |
| News Index | first | prev | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | next | last |