microsoft.public.access

Message Index 7 for Discussion Group microsoft.public.access

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
9c1f0243-f652-411f-9f43-bdfaa8248e38 ... (more)

Always on Top Function? (by =?Utf-8?B?SGFzYW4=?= on 11 May 2004, 1 reply)
Is there a way of setting a database to be "Always on Top" (The database window is constantly in view on the screen) regardless of what other programs and windows are also running? If so how? ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
ab44c8bf-aecf-4d73-a950-05db67c8376c ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
ac99e560-d5e2-4584-b277-2c0a82a555b6 ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
aca31059-2491-4797-8f0f-fdb8f54226de ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
af359a80-c2a7-47b1-b640-84c5059a2735 ... (more)

printing? (by =?Utf-8?B?bWFpbG1hbg==?= on 11 May 2004, no replies)
when I print does it make any difference if I start with odd or even pages ... (more)

Changing text colour OnChange? (by =?Utf-8?B?S2F0aGVyaW5l?= on 11 May 2004, 4 replies)
Hey is there any way to change the colour of a text box to start off as red text then change to black when the field is updated or entered? I want to open a form with a record for data input with a default date that is red and changes to black when it has been clicked on or changed? Thanks :) ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
c0f49f87-764e-45cd-9bcd-fdb5914e60ce ... (more)

how to address current database (by =?Utf-8?B?YWxla20=?= on 11 May 2004, 1 reply)
Hi, Set dbs = OpenDatabase("somedatabase.mdb") dbs.Execute "INSERT INTO ...." ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
c5cdc7d7-aadf-424a-b6b5-8870dec5b370 ... (more)

RE: Huge Relationship Problems (by =?Utf-8?B?U21pdGg=?= on 11 May 2004, 1 reply)
I have just experience similar problems. All of a sudden most of my relationships have disappeared. I try recreating & saving new relationships but after closing the relationship window and reopening it, the relationships are gone & are not saved at all. If anyone can help me with this problem, it would be much appreciated. (Using Access 2002) ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
caaf5894-888b-417d-89ce-f622f8a9afe6 ... (more)

Seemingly Simple Sample management (by =?Utf-8?B?Q0gzM0NI?= on 11 May 2004, 2 replies)
Hello- I have a main Table of 50,000+ magazine subscribers. Every so often I am given a list of 2000 or so contacts (name, company, addy, etc etc etc...) and asked to determine which and how many entries from the smaller table also exist in the main subscriber table, so the salespeople can attack those who are not subscribers. I already assume certain inherent caveats, like how many unique "John Smiths" we have, but it is well worth the small margin of error than having to go through the lists manually. I answered all of management's OTHER questions using the advanced filters in Excel, but I am stumped by this seemingly simple task. ... (more)

Seemingly Simple Sample management (by =?Utf-8?B?Q0gzM0NI?= on 11 May 2004, 2 replies)

Hello-
I have a main Table of 50,000+ magazine subscribers. Every so often I am given a list of 2000 or so contacts (name, company, addy, etc etc etc...) and asked to determine which and how many entries from the smaller table also exist in the main subscriber table, so the salespeople can attack those who are not subscribers.
I already assume certain inherent caveats, like how many unique "John Smiths" we have, but it is well worth the small margin of error than having to go through the lists manually.
I answered all of management's OTHER questions using the advanced filters in Excel, but I am stumped by this seemingly simple task. ... (more)

logon prompt (by =?Utf-8?B?S2V2aW4=?= on 11 May 2004, 2 replies)
We just installed new computers and the database which I am owner of no longer prompts me for my user name. It now recognizes me as "Admin", rather than my user name. I'm afraid this may pose problems in the future when I try to make changes to the database. How can I get the prompt to reappear when I open the database? ... (more)

=sum() (by =?Utf-8?B?Sk1vcnJlbGw=?= on 11 May 2004, 5 replies)
=([fsum]+[wsum]+[osum]) when fsum > 0 AND wsum > AND osum > 0 the =sum() returns a value. If fsum OR wsum OR osum = 0, =sum() returns nothing. ... (more)

Select Distinct (by =?Utf-8?B?TWFnZ2ll?= on 11 May 2004, 2 replies)
I have probably what might seem like a very simple question, but I have not been able to figure out how to do it. I have a database that has names and addresses of members of a club I belong to. We send out a monthly newsletter. Some of the members live at the same address. I was able to "write" a macro using Select Distinct to return only distinct addresses. However, I need the rest of the information too (ie, name, city, state & zip code). How do I "combine" macros to get all the information I need. ... (more)

Select Distinct (by =?Utf-8?B?TWFnZ2ll?= on 11 May 2004, 2 replies)

I have probably what might seem like a very simple question, but I have not been able to figure out how to do it.

I have a database that has names and addresses of members of a club I belong to. We send out a monthly newsletter. Some of the members live at the same address. I was able to "write" a macro using Select Distinct to return only distinct addresses. However, I need the rest of the information too (ie, name, city, state & zip code). How do I "combine" macros to get all the information I need. ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
db471c2a-db90-445b-ae51-c272c2c92dad ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
dc68418d-0d68-4519-9d61-b2484052f296 ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
de30baca-1e1d-413c-bbc5-2d2ab33441b7 ... (more)

Append problem in Datasheet View. (by =?Utf-8?B?QWxhbiBHcmVlbg==?= on 11 May 2004, 2 replies)
I copy records already in a table in datasheet view and append them. I then amend the appended records. If I do this one record at a time there is no problem. But if I do a batch, I lose all the appended records! Why? ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
e2c58c88-5824-40cb-83ab-3c33fa921329 ... (more)

OLE with image files and the resulting .MDB file size (by =?Utf-8?B?TWF0dCBDLg==?= on 11 May 2004, 3 replies)
I am using Access 2000 to create databases which include images. My understanging of OLE is a bit hazy - most of the books I've seen make the claim that using an embedded OLE object will insert the entire file contents of the embedded file into the database, while linking the file is supposed to store a pointer to the file without copying the contents of the file into the database. However, I've been putting together a database that uses a large quantity of image files, and the size of the database suggests that OLE doesn't work that way at all. I had tried to save space by compressing the files as JPEGs or GIFs (depending on the content - photos or line art), then linked the images in, and this seems to have backfired. The database expanded until its size on the disc easily exceeded the size of all the images stored in it by well over an order of magnitude. So, to see how much room the files take up, I created four databases to test the effects of using BMP files vs JPEG files, and linking versus embedding. Each one used a table storing six images combined with a simple form to input images. The images were identical, generated by running the source JPEGs through a converter to make BMP files. The total size of the JPEG files came to 585 kB. Linking them into a database resulted in a 16.6 mB MDB file, while embedding them caused the file to expand to 24.8 mB. With BMP files, the original files totalled 4.68 mB in size. Linking them into a database created a 9.62 mB file, while embedding them surprisingly caused the file to shrink to 4.83 mB. ... (more)

OLE with image files and the resulting .MDB file size (by =?Utf-8?B?TWF0dCBDLg==?= on 11 May 2004, 3 replies)

I am using Access 2000 to create databases which include images. My understanging of OLE is a bit hazy - most of the books I've seen make the claim that using an embedded OLE object will insert the entire file contents of the embedded file into the database, while linking the file is supposed to store a pointer to the file without copying the contents of the file into the database. However, I've been putting together a database that uses a large quantity of image files, and the size of the database suggests that OLE doesn't work that way at all. I had tried to save space by compressing the files as JPEGs or GIFs (depending on the content - photos or line art), then linked the images in, and this seems to have backfired. The database expanded until its size on the disc easily exceeded the size of all the images stored in it by well over an order of magnitude.

So, to see how much room the files take up, I created four databases to test the effects of using BMP files vs JPEG files, and linking versus embedding. Each one used a table storing six images combined with a simple form to input images. The images were identical, generated by running the source JPEGs through a converter to make BMP files. The total size of the JPEG files came to 585 kB. Linking them into a database resulted in a 16.6 mB MDB file, while embedding them caused the file to expand to 24.8 mB. With BMP files, the original files totalled 4.68 mB in size. Linking them into a database created a 9.62 mB file, while embedding them surprisingly caused the file to shrink to 4.83 mB. ... (more)

Formating Text (by =?Utf-8?B?SERpYXM=?= on 11 May 2004, 5 replies)
I am creating an access database which needs to have different words underlined, highlighted, and the fonts displayed in a different color. When I select a word and change the font, color, underline (etc.) the entire table changes to that particular format. How can I only make certain portions of words or certain words/numbers change and not the whole table? ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
e7f421f2-2e8a-4363-a2d6-d002976f952d ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
f0867c82-0692-4713-80ac-d33cfb43ccba ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
f35d1528-618e-4344-802b-82ac246163f9 ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
f3d2604d-86e1-47ce-b95d-f12c5546523a ... (more)

Switchboard option identification (by =?Utf-8?B?THlu?= on 11 May 2004, 1 reply)
I have three Switchboards containing a MAIN Menu, and ENTRY Menu and an EDIT Menu. Before I enter further data on a subject the first action is to open a form to enter the subject ID to check that the subject does exist in the database, then depending on what option had been selected, say for example the option to enter a follow-up, I would then wish to open the form for entering follow-up data, or if it was an Adverse Event I would wish to open the Adverse Event form. I therefore need to be able to determine which option had been selected on the ENTRY Menu Switchboard to determine which form should be opened. Is there a way of capturing the ItemNumber or OptionNumber or something. Any suggestions on how I can do this? ... (more)

Switchboard option identification (by =?Utf-8?B?THlu?= on 11 May 2004, 1 reply)

I have three Switchboards containing a MAIN Menu, and ENTRY Menu and an EDIT Menu.
Before I enter further data on a subject the first action is to open a form to enter the subject ID to check that the subject does exist in the database, then depending on what option had been selected, say for example the option to enter a follow-up, I would then wish to open the form for entering follow-up data, or if it was an Adverse Event I would wish to open the Adverse Event form.
I therefore need to be able to determine which option had been selected on the ENTRY Menu Switchboard to determine which form should be opened. Is there a way of capturing the ItemNumber or OptionNumber or something.
Any suggestions on how I can do this? ... (more)

CsWebNews3Test Test Message (by =?Utf-8?B?cG9wY29ybg==?= on 11 May 2004, no replies)
f96da2a0-8bf1-4609-8ea6-e0c06b9d72dc ... (more)

Access can't "see" a Paradox dbase??? (by JVRudnick on 11 May 2004, no replies)
I have a client who wishes to get their small 1000 record PARADOX dbase, converted to a MS Access one. I opened up MS Access 2000, and tried to File > Import the tables in ... (more)

How to do a Specific Search with " " (by Miracle on 11 May 2004, 2 replies)
Hey all... I have a database for a few thousand items with closely related item names... I am trying to do a "find and replace" to rename items in the database but here is the kicker.. when I do a search for item abc the search is finding item abcd, abcde and so on. Is ... (more)

Append record to another table with different field values (by Chadi Ghazal on 11 May 2004, 1 reply)
hi there, i have two tables materials and results i want to read all materials in a specific class from the materials table and append them to the result table. but in the result table i want to add ... (more)

Index error importing dbf from access. (by F�lix on 11 May 2004, no replies)
My problem is trying to import or linking dbf files from access. Access asks my for the index file I put the mdx file and I choose a field where I suspect to be the index, but although I try with all of them it fails. How can I link the dbf file without problems?. Can I use another database to see ... (more)

HowTo: work arround for the "Too many fields error" (by Joannes Vermorel on 11 May 2004, 3 replies)
I have some data currently in XML that I want to import into MS Access. It is very simple numeric data with roughly 700 fields (scientific data). When I try to import in MS Access the XML file, I got the "Too many fields" error. ... (more)

Recovering table (by John on 11 May 2004, 2 replies)
Hi Is it possible to recover a table if it has been deleted and before the mdb file has been compacted? ... (more)

Saving pictures (by Brad Allison on 11 May 2004, 2 replies)
I am using a small Access database as the back end of a VB .NET program. I am not a newbie to Access, but I have never had the need to store pictures until now. I have a field in a Master table named "Picture" and I have set the Date Type as OLE Object. I know that this might be the wrong newsgroup ... (more)

Problem opening access file (by Elsie on 11 May 2004, 4 replies)
Hi, my colleague was working on an access file, when the whole pc hanged. After re-booting, that file is no longer accessible. When I try to open it using MS Access 2002, a message: "The current user account doesn't have permission to convert or enable this database" appears. But when I try to ... (more)

reset (by Jorge A M Caneiras on 11 May 2004, 2 replies)
I don't know if someone can help me, but i'm having problems whit my computer... it reboots without me doing anything. i don't think it's a virus... i already formated the computer twice... ... (more)

How do I list values in a text box.... (by Dawn Pensiero on 11 May 2004, 4 replies)
I need to list all values from 1 field in a text box with commas separating the values. Can anyone help? Dawn Pensiero ... (more)

dates (by jjrmy1 on 11 May 2004, 2 replies)
hi everyone! does anyone know how to filter a recordset for a specific date. for example. i keep some dates in an access database of cpr training. i am making a repeating region listing the people whose cpr license will expire ... (more)

Record Locking (by Joyce on 11 May 2004, no replies)
Accessing linked tables via ODBC. I change a record. Then I decide I want to delelte the record, but I get the message that the record is being used by someone else and I can't make any changes. (I'm the only one on the ... (more)

into a live mailto link? (by joe thompson on 11 May 2004, 4 replies)
What is the easiest way of turning an email field in an access form into a live mailto link? Thanks ... (more)

Left zero fill on export of field (by jubejoie@aol.com on 11 May 2004, 6 replies)
I see on my table the left zero fill in a field defined as number 5 in length and format = 00000. When data entering a 1 in this field the table will look like this "00001", WHICH IS WHAT I WANT. But when I export the table, fixed ... (more)

Need to set up an audit table (by Tim on 11 May 2004, 1 reply)
Hi I need to set up an audit table. The idea is that this table is populated with data and time, user, old values ... (more)

Are there limits.... (by Jez Tibbetts on 11 May 2004, 1 reply)
I am trying to display record information using a pivot chart on a data access page in Access 2002. Despite my query on which the chart is based holding 23,000 odd records the chart will only display the first 10,000 ... (more)

After updated data is was encoding (by Visual on 11 May 2004, 1 reply)
In ASP after updating data (with ADO) in Access, data is base is was encoding and missing displayed. Please help me. ... (more)

Setting Access Table to Single User (by BLG on 11 May 2004, no replies)
How do I set up a table in Access so that only one person can enter data into the table at a time. If anyone else attempts to access the table while another user is working in it, they will only be able to view data as Read-Only. ... (more)

Split database (by Loi on 11 May 2004, 2 replies)
Hi, databases ________ relinked the Font-end. However, the table (A)isn't appear ... (more)

Annual Leave Database (by Bryan Gwynne on 11 May 2004, 1 reply)
I'm no expert in Access, not by any stretch of the imagination. However, I have been set a task that I think is just too complicated for me. ... (more)

Access 2003 and the web (by allie on 11 May 2004, no replies)
My company is thinking about using access 2003 (A03) to publish forms to the web so that users and enter data and run reports. ... (more)

Accessing DB is slow (by Brad on 11 May 2004, 8 replies)
I recently moved an Access database from a client workstation to a server. There are about 10 clients accessing the database on the server over the network via a share on the server. Since it was moved, accessing most ... (more)

VB window opens when DB opens (by Jay on 11 May 2004, no replies)
Every time I open the database, it opens not only the main whenever I click ... (more)

"Not Enabled" vs "Locked" (by el zorro on 11 May 2004, 2 replies)
What's the difference bnetween a form field being "Locked" and being "Not Enabled," as indicated by the property settings for the field (i.e., Enabled = No, or Locked = Yes)? ... (more)

split database (by Loi on 11 May 2004, 1 reply)
Hi, I have a database, and then I splitted it to two databases so more people can use it as the same time. ... (more)

multi users - corrupting database (by Fiona on 11 May 2004, 3 replies)
HI, Let me apologise now for the length of this post. I have designed a pretty basic database to record the results of ... (more)

Publish Access (by Jason on 11 May 2004, 1 reply)
I want to give my Access database a Web frontend so that users can have Web access for data entry on my intranet. What is the easiest way to do this? ... (more)

Pivot Table issues in Access (by Greg on 11 May 2004, no replies)
Hello all, I have an issue in access when I open most databases. The problem comes up when I view the output of a query in a Pivot Table view. When I select the dropdowns to change the data that I am looking at the ... (more)

MDAC (by webbs on 11 May 2004, no replies)
I am getting a 'Data cannot be retrieved from the source you have selected' message. Looking it up it appears that I needed to update my MDAC. After having done so, the problem still remains. Any help would be greatly ... (more)

Mdac (by webbs on 11 May 2004, 1 reply)
I am getting a 'Data cannot be retrieved from the source you have selected' message. Looking it up it appears that I needed to update my MDAC. After having done so, the problem still remains. Any help would be greatly ... (more)