microsoft.public.access

Message Index 27 for News Archive microsoft.public.access

Envelopes (by Antonio on 2 Jun 2004, 2 replies)
I have a table containing various contact addresses. This table is connected to various forms, used for various reasons. Is it possible to make print an envelope based on the address that is currently displayed on a form? ... (more)

Completing Form On Current (by DP on 2 Jun 2004, no replies)
I would guess I missed (at least) this day in Access Class. Have form where based on a Number, the Name is selected ... (more)

Selecting by Name or Number (by DP on 2 Jun 2004, 1 reply)
Is there a way to select an item based on knowing either the Number or Name. (I'm using Combo boxes). Example would be to eventually find "1160 Broadway" by entering either 1160 or Broadway. ... (more)

Access 2000 versus 2002 problem (by Bob Thomas on 2 Jun 2004, 1 reply)
We have a master database being created in one location by a person using Access 2000. He creates multiple versions of this with slightly different file names for each person needing to input data. This then gets sent to about six ... (more)

MS D-BASE STATES NEED REPAIR (by Chris on 2 Jun 2004, 3 replies)
When I open d-base it states that it needs to be repaired but when I click yes it looks like it starts and then just sits there and does nothing else. In the task manager it still shows running. Does anyone have any suggestions on ... (more)

memo filed (by JIM.H. on 2 Jun 2004, 1 reply)
Hello, I have a memo filed in my table and I want to type a long string there but it seems it is cutting my string, what is the limit in number of characters in a memo filed. ... (more)

Look in Box is slow to show avaliable resources (by Jason La Faber on 2 Jun 2004, no replies)
When user are in in a Word or Excel document and they use the look in box to open a new document, when clicking on the drop down box. ... (more)

Uppercase in Text box (by San on 2 Jun 2004, 2 replies)
I want to capitalize the first character of every word that I type in a text box. Is there a property setting this is capital ... (more)

Files mdb to exe (by Florbela on 2 Jun 2004, 2 replies)
I need to convert files from access xp (mdb) in to (exe). I need a simple way to get it. I try office xp developer, but where is other ways???? ... (more)

Can anyone help me with DAO codes? (by =?Utf-8?B?TGl6YQ==?= on 2 Jun 2004, 1 reply)
I am not familiar with DAO. So far I am learning and writing ADO codes. I want to change it to ADO. I did but it is not working. Can anyone kindly with the below codes? Original DAO codes ... (more)

Adding data to table (by Techsupport on 2 Jun 2004, 2 replies)
Good morning, everybody...I have a table (tblLogin) and two forms (frmAddUser and frmUserLogInfo). The frmUserLogInfo feeds from the tblLogin. Whenever a new user needs to be ... (more)

Strange result from query / OleDbException (0x80040e57) (by Versteijn on 2 Jun 2004, no replies)
Hello all, SELECT DISTINCT * FROM Models ORDER BY Design; ... (more)

Access closes automatically when a certain record comes up (by =?Utf-8?B?YWxp?= on 2 Jun 2004, no replies)
Please help! I have an access database that seems to be working fine until I try to get into a certain record. When scrolling down the recors as soon sh this record is about to appear I get booted out of the program. I have tried to run a delete query but it says that it can not find this file. The data is this record has been entered using a different number so the problem file can be taken out. ... (more)

Access closes automatically when a certain record comes up (by =?Utf-8?B?YWxp?= on 2 Jun 2004, no replies)

Please help! I have an access database that seems to be working fine until I try to get into a certain record. When scrolling down the recors as soon sh this record is about to appear I get booted out of the program. I have tried to run a delete query but it says that it can not find this file. The data is this record has been entered using a different number so the problem file can be taken out. ... (more)

My data is gone! (by =?Utf-8?B?YW5uYQ==?= on 2 Jun 2004, 4 replies)
dont get on me for not backing up...but I open up the database, as usual but my tables are gone! Years of collecting data and it just vanished. ... (more)

Filter Combo box (by =?Utf-8?B?VHJldm9y?= on 2 Jun 2004, 1 reply)
I can't articulate this exactly how I want to so I going to use an example in my database. Hopefully it will not confuse. So firstly I scroll through all my nurseries, the sub form linked on the nursery then displays all the inspections. To do a new inspection you choose a "seed lot" in the subform. I would like my "seed lot" combox not to show all seed lots just those that match the nursery. Can I filter the combo box based on the value in another field. If nursery A is selected only show in the combo box seed lots also at nursery A. ... (more)

Filter Combo box (by =?Utf-8?B?VHJldm9y?= on 2 Jun 2004, 1 reply)

I can't articulate this exactly how I want to so I going to use an example in my database. Hopefully it will not confuse.

So firstly I scroll through all my nurseries, the sub form linked on the nursery then displays all the inspections. To do a new inspection you choose a "seed lot" in the subform. I would like my "seed lot" combox not to show all seed lots just those that match the nursery. Can I filter the combo box based on the value in another field. If nursery A is selected only show in the combo box seed lots also at nursery A. ... (more)

Number of records (by =?Utf-8?B?Ym5pY2hvbHMwMzMw?= on 2 Jun 2004, no replies)
I know this is probably an easy fix, but I can't seem to figure it out. I need to be able to include a field on a report that shows the number of records found by a query. Example: I have a query that is pulling all subjects from group 1 that answered yes to a question. That information is displayed in a pie chart. I need to be able to make a field below the chart that says how many subjects that date represents (ie. n=35). Also, I have three pie charts set up to show the percentages of each group that answered yes or no. Is there a way that I can then have a bar graph at the bottom that shows the percentage of each group that said yes (ie. Group 1 = 35, Group 2 = 20, Group 3 = 42 in a bar graph form)? ... (more)

Number of records (by =?Utf-8?B?Ym5pY2hvbHMwMzMw?= on 2 Jun 2004, no replies)

I know this is probably an easy fix, but I can't seem to figure it out. I need to be able to include a field on a report that shows the number of records found by a query. Example: I have a query that is pulling all subjects from group 1 that answered yes to a question. That information is displayed in a pie chart. I need to be able to make a field below the chart that says how many subjects that date represents (ie. n=35).

Also, I have three pie charts set up to show the percentages of each group that answered yes or no. Is there a way that I can then have a bar graph at the bottom that shows the percentage of each group that said yes (ie. Group 1 = 35, Group 2 = 20, Group 3 = 42 in a bar graph form)? ... (more)

6Overflow (by =?Utf-8?B?VHJ1ZHk=?= on 2 Jun 2004, 1 reply)
Does anyone know what this error is and how to fix it?? ... (more)

Excel and VB Script (by =?Utf-8?B?QWRyaWFu?= on 2 Jun 2004, 1 reply)
Hi I'm looking for information on using VBS to create and append excel workbooks, but have only found very simple examples on the net any reference would be great. ... (more)

Working with Trees (by =?Utf-8?B?amJs?= on 2 Jun 2004, no replies)
Hi all. I need to build form, that can allow me work with trees. ... (more)

MoveNext (by =?Utf-8?B?TWFyZ2U=?= on 2 Jun 2004, no replies)
Hi I have a form with 2 tabs in one tab there is a datasheet view of the table and the second tab has the details. The second tab displayes the details depending on which record you select in the first - this all works fine. My problem is that once I choose a record and look at it's details from there I want to move to the next record or previous record (numberically) without changing back to the first tab. Can this be done or is it one funtionality or the other ?? Any help or ideas appreciated. I have had a look at the Recordset Clone feature but I think my problem might be that I want to move thru all records in the table at this point so I mean the next id in the table. I have code in the ONCurrent event that enables me to display the correct record depending on the rec selected in the first form does this make the recordset just that rec ? ... (more)

MoveNext (by =?Utf-8?B?TWFyZ2U=?= on 2 Jun 2004, no replies)

Hi
I have a form with 2 tabs in one tab there is a datasheet view of the table and the second tab has the details. The second tab displayes the details depending on which record you select in the first - this all works fine. My problem is that once I choose a record and look at it's details from there I want to move to the next record or previous record (numberically) without changing back to the first tab. Can this be done or is it one funtionality or the other ?? Any help or ideas appreciated. I have had a look at the Recordset Clone feature but I think my problem might be that I want to move thru all records in the table at this point so I mean the next id in the table. I have code in the ONCurrent event that enables me to display the correct record depending on the rec selected in the first form does this make the recordset just that rec ? ... (more)

Re: Re: Problem changing datatype of a field in a table with many records (by =?Utf-8?B?bWFyZzEwMzdAbm9lbWFpbC5ub2VtYWls?= on 2 Jun 2004, no replies)
I am having the same issue, or at least a related one. i am working with an access 2000 db, and it has about 190k records in one of its tables. I am trying to add an autonumber column to it and get the message that "file sharing lock count exceeded. increase MaxLocksPerFile registry entry". currently, my registry entry for MaxLocksPerFile value data box says 251c, though I have increased it to 400,000c and 900,000c and 999,999c -- in hopes of eliminating the problem. It says it's base is hexadecimal, not decimal. I have seen posts where users corrected this error by editing the registry entry for MaxLocksPerFile, but it does not seem to work for me -- my error still occurrs. Can you please offer other options? Thank you! ... (more)

Re: Re: Problem changing datatype of a field in a table with many records (by =?Utf-8?B?bWFyZzEwMzdAbm9lbWFpbC5ub2VtYWls?= on 2 Jun 2004, no replies)

I am having the same issue, or at least a related one. i am working with an access 2000 db, and it has about 190k records in one of its tables. I am trying to add an autonumber column to it and get the message that "file sharing lock count exceeded. increase MaxLocksPerFile registry entry". currently, my registry entry for MaxLocksPerFile value data box says 251c, though I have increased it to 400,000c and 900,000c and 999,999c -- in hopes of eliminating the problem. It says it's base is hexadecimal, not decimal.

I have seen posts where users corrected this error by editing the registry entry for MaxLocksPerFile, but it does not seem to work for me -- my error still occurrs. Can you please offer other options? Thank you! ... (more)

storing data (by =?Utf-8?B?a2ltYw==?= on 2 Jun 2004, 1 reply)
Can multiple pieces of data be stored in a single field? What I'm looking at, is when using a form, I think I want to use the multi-select feature of a list box to be able to select more than one of the choices in the list. The thing is, can I store more than one selected choice in the same field of a table? ... (more)

Shall we give up the subform Line Number ? (by =?Utf-8?B?TGl6YQ==?= on 2 Jun 2004, 1 reply)
Hi Access MVP, My colleague Jeff and I have been working on a form for 3 days. The form is for Inventory Movement Enquiry. There is no table update, just only read from several tables. The enquiry composes of main and subform. These two forms are absoulately unbound. In the main form, there are only 2 key controls, product and warehouse. User will choose product first and it will lead a AfterUpdate to formulate the warehouse combo box. So user will see those warehouse only associated to the chosen product. After the warehouse is chosen, it will lead the warehouse AfterUpdate to pull the transaction history and place in the subform. In the subform we use For Each control and Select .. Case to display all history. So far it is working fine, except we think it would be better to put a line number in the subform for easy reference. ... (more)

Shall we give up the subform Line Number ? (by =?Utf-8?B?TGl6YQ==?= on 2 Jun 2004, 1 reply)

Hi Access MVP,

My colleague Jeff and I have been working on a form for 3 days. The form is for Inventory Movement Enquiry. There is no table update, just only read from several tables. The enquiry composes of main and subform. These two forms are absoulately unbound. In the main form, there are only 2 key controls, product and warehouse. User will choose product first and it will lead a AfterUpdate to formulate the warehouse combo box. So user will see those warehouse only associated to the chosen product. After the warehouse is chosen, it will lead the warehouse AfterUpdate to pull the transaction history and place in the subform. In the subform we use For Each control and Select .. Case to display all history. So far it is working fine, except we think it would be better to put a line number in the subform for easy reference. ... (more)

Help!! How to evaluate a math function in string form (by JM on 02 Jun 2004, no replies)
Hi, I need to evaluate a math function that is in a string, example str = (4) ^2 + 34, ... (more)

6Overflow error message (by =?Utf-8?B?VHJ1ZHk=?= on 2 Jun 2004, no replies)
I work in a network environment using a mulituser access 97 database. The onserver file currently reads at 153,000kb. how do i compact this? Thanks ... (more)

Help!! How to evaluate a Math function in string form (by JM on 2 Jun 2004, 2 replies)
Hi, str = "(3)^2 + 23" ... (more)

pieces jointes (by cbdp.saulieu on 2 Jun 2004, no replies)
merci de me dire comment faire pour que outlook ne me d�truise plus les pi�ces jointes � mon courrier ... (more)

How to display an unbound form field on a report? (by Jim on 2 Jun 2004, 2 replies)
I have a form that lets you select a customer based on they're customer ID, which then brings up phone, fax, contact, etc. I also have an unbound text box on the form where you can type in a message. I then have a report based on this form formatted as a fax cover sheet that works great, except that I ... (more)

Email a contact from the forms page, How to? (by Greg Gensicki on 2 Jun 2004, 5 replies)
Hello all, I've created a contacts database using the default contacts template and the wizard. ... (more)

HELP!!!! Subreports (by Chris on 2 Jun 2004, 7 replies)
I need to display on the same A4 page more pages of the same report, and, after the A4 paper sheet is over to continue on the next A4 paper. Can I insert it more times as a subreport setting it for every insertion to display another consecutive page(and not to appear anymore if there are not ... (more)

Good idea - bad idea (by Andy Levy on 2 Jun 2004, 1 reply)
Hi I have a web server in california usa, but the database server is in the UK. What can i do to help the long distance speed. Has anyone got any top tips? ... (more)

emailing from access (by Dave on 2 Jun 2004, 22 replies)
Hi, I have found some code on the Microsoft knowledge base that 'should' allow me to send emails and attachments ... (more)

Tricky Inner Join (by Maik Richter on 2 Jun 2004, 1 reply)
Hi guys, I need to join 2 tables with 2 criterias ... (more)

Linked table to view on SQL7 server does not show new record (by Ivan Starr on 2 Jun 2004, no replies)
Hello thanks for helping. I am using Access 97 to connect to a view of a table on an SQL Server 7 box. A new record was added through another user, but when the linked table to ... (more)

Report from multiple queries (by ryanb. on 2 Jun 2004, 1 reply)
Is it possible to have one report be 2 pages, with the first page pulling one query, and the second page pulling a second query? ... (more)

Problems openingusing VBA Access from Excel (by Jan Kr on 2 Jun 2004, 2 replies)
I try to open an Access database from Excel, using the following code Sub OpenDatabase() ... (more)

REPORT DESIGN (by Chris on 2 Jun 2004, 3 replies)
I have a report with page header, page footer, and a VARIABLE number of lines with data in the detail zone of the report. How can I make the detail zone of the report to shrink or to grow for not leting free space between the last line and the page footer? ... (more)

Why the hell is this difficult? (by bigbob on 2 Jun 2004, 3 replies)
A master spreadsheet, keyed (for example) by Social Security number. This grid would contain name, phone number, age, etc. A second grid also keyed by SSN listing children's names and ages related to the SSN in the master ... (more)

Repost - Default folder for Office Links (by Brigitte P on 3 Jun 2004, 5 replies)
I posted this in the past and didn't get a reply. Would someone please have mercy on me :) Thanks. When I dump a file into an Excel spreadsheet via the ... (more)

Calendar Web App w/ Access? (by Justin M. Keyes on 3 Jun 2004, no replies)
Hi, I need to make a website that has a calendar page which stores data on a MS SQL database. ... (more)

List of available printers (by jan on 3 Jun 2004, 1 reply)
When using the print dialog, I can get a list of available printers. Is there any way I can access that list from code? I need to determine if a certain printer is on the list, and if it is, I want to print to this printer. If not I need to tell the user, that the ... (more)

How to get linked table to login automatically to SQL7 using uid/pwd (by Ivan Starr on 3 Jun 2004, 3 replies)
Hello thank you for helping. I have a few linked table in a msaccess97 frontend that I would like to login to automatically using uid/pwd authentication (no domain). As it ... (more)

mapping? (by =?Utf-8?B?bWFieW4=?= on 3 Jun 2004, no replies)
This may be a really dumb question but heregoes... I have a database created where I'd really like to show it on a map. Is there a module or something I could do with Access already created that could do this? ... (more)

Compacting Error -1611 (by =?Utf-8?B?V0FS?= on 3 Jun 2004, 3 replies)
When compacting my Access 2000 database, I received an error -1611 "Could not find field 'Description'". I looked through all of my tables in design view and none of them have any information at all in the 'Description' fields. Any thoughts? ... (more)

installing access runtime changes default program to open mdb's (by =?Utf-8?B?TmFzb3M=?= on 3 Jun 2004, 3 replies)
I have a runtime version of my application which I want to install on users machines, some of whom have already got another version of access on their machine. When my runtime version is installed it automatically becomes the default version to open .mdb databases. How can I prevent this from happening?? Maybe I am wrong to distribute it as .mdb should I convert it to .mde first?? I suppose this will make it the defult for .mde then, I don't want that either. How can I prevent my access version (2003) automatically changing any default?? Is it something I do wrong in the packaging wizard?? Thanks to anyone who can help. ... (more)

installing access runtime changes default program to open mdb's (by =?Utf-8?B?TmFzb3M=?= on 3 Jun 2004, 3 replies)

I have a runtime version of my application which I want to install on users machines, some of whom have already got another version of access on their machine. When my runtime version is installed it automatically becomes the default version to open .mdb databases. How can I prevent this from happening?? Maybe I am wrong to distribute it as .mdb should I convert it to .mde first?? I suppose this will make it the defult for .mde then, I don't want that either. How can I prevent my access version (2003) automatically changing any default?? Is it something I do wrong in the packaging wizard?? Thanks to anyone who can help. ... (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)

Duplicating Recordsets (by Andy on 3 Jun 2004, 6 replies)
I want to take data from a table, modify it and put it in a report without changing the original table data. OpenTable links the rst to the table data as does .clone. OpenSnapshot locks the records for modification. I ended ... (more)

error messages (by cgaalpha $removethis$ @sbcglobal.net on 3 Jun 2004, 1 reply)
Error Message: A fatal exception 0E has occurred at 0028:C02A0948 in VXD VWIN32(05) + 000012D0 When shutting down my computer, I get this error message ... (more)

Access00-02-03 (by Allen on 3 Jun 2004, 1 reply)
Hi All, Couple of questions, ... (more)

Setting physical form open locations in the Access window (by Eddie on 3 Jun 2004, 1 reply)
Hey, I have a series of forms set up to all open on a trigger. What I would like to do is get them to open in a block ... (more)

Maybe this can't be done (by Ritchie on 3 Jun 2004, 1 reply)
Can someone tell me how to put a close button on a form. I have a documents set up so that when they are opened the first thing that the user will see is a form but is there anyway i can put a "Close" button on this form. I ... (more)

Help (by Roger on 3 Jun 2004, no replies)
"$=A3&^ &^"& ^"=A3^&^)&(^"^("&^("%?><&"( ("((&**/-+?>~~@ ... (more)

Form does not access table data (by Tim on 3 Jun 2004, 1 reply)
We've been using Access for 5 years or so, with only minor hiccups... Monday, the person in the office most familiar with Access opened a form view to find that none of the records that it showed the day before were ... (more)

HELP! Delete query with multiple criteria (by anonymous on 3 Jun 2004, no replies)
Somethhing like Dif1, query ... (more)

access.lockfile.9 (by James on 3 Jun 2004, 1 reply)
How do I unlock the ldb file in order to exclusively open a mdb file, when the ldb file is listed as access.lockfile.9? ... (more)

Macro issues (by Susie on 3 Jun 2004, no replies)
Hi...I have recently converted all of my databases from '97 to XP. We have ongoing events that we just copy a database for each new event. I have a macro that simply outputs a file (daily)(in Rich Text Format) to a directory ... (more)

virus checkers (by Denise on 3 Jun 2004, 2 replies)
Will a virus checker slow the performance speed of a shared database? Any suggestions? ... (more)

removing relationships. (by FFira on 3 Jun 2004, 1 reply)
Hai, I would like some assistance. How do you remove relationships from tables created in access? These are the foreign key type relationships. ... (more)

Lookup Fields (by Ramone on 3 Jun 2004, 4 replies)
Hello Everyone, I havea table in the first field i enter the agent ID# ... (more)

reports (by Beth Mc on 3 Jun 2004, 3 replies)
When I create a report using the wizard, "Compact" is the format I use. I've done this for years and the print preview is exactly how it prints. Recently, the actual printout prints in a different font and weight, even ... (more)