microsoft.public.access

Message Index 19 for Discussion Group microsoft.public.access

Table (by Dazza on 24 May 2004, 1 reply)
I have a copy of Access 2003 when i enter data via Forms it does not appear on my table and therefore I cannot retrieve in report...can anyone advise? ... (more)

Access connecting to Oracle (by Jason. on 24 May 2004, 3 replies)
I have created an access database to query an Oracle Database. When I distributed this access database to other members of my team, they received the following error message upon trying to open it, ... (more)

Diff between On Open and On Load (by Joyce on 24 May 2004, 2 replies)
Does it make a difference where I place a command in reguards to on open and on load? I also want the field for Revised to automatically change ... (more)

FRUSTRATED - DATA ENTRY IN A FORM VIA NETWORK (by Vic on 24 May 2004, 4 replies)
If anyone can give me an answer I would really appreciate it. Totally frustrated with this one. Here's the problem. User A opens the database at 10:00am. ... (more)

Message Box Help MsAccess 2000 (by John on 24 May 2004, 3 replies)
I am new to using access so forgive me if this seems like a silly request I want to be able to put duplicate name entries into a table (Requests) but have ... (more)

Sending Email from MS Access (by Tim Brown on 24 May 2004, 2 replies)
Does anyone know of a different way (other than CDO) to send email from MS Access 2003 (to or via Outlook 2003)? Some email will be a simple message, others will have a ... (more)

Accessing MS Access 2002 database on win 95/98 OS (by alan on 24 May 2004, 2 replies)
Is it necessary to encode a VB6 software program (SP4) that accesses a MS Access 2002 database on a "clean" Win 98 system with special database access controls, or can this be done by distributing (and registering) DLL's? If ... (more)

Leading zero's???? (by Bob on 24 May 2004, 2 replies)
Is there an easy way of displaying leading 0's to numbers in a report?? For instance: 00042 ... (more)

Saving a file (by NFJimc on 24 May 2004, 4 replies)
I currently have a file on a floppy that I want to transfer to my hd. If I try to send copy it or save as, I get a message saying "cyclic redundacy error" and it won't save it to my hd. Any ideas as to what this means ... (more)

Check Box Control (by Diane on 24 May 2004, 7 replies)
Has anyone ever tried to change the size or properties of a Check Box in a form? I wanted to make the actual checkmark larger. ... (more)

numbers (by =?Utf-8?B?YXk=?= on 24 May 2004, 3 replies)
How do you hide numbers in Access so that when you view the record it has XXXXXXX2302? Like an account number or phone number. ... (more)

KnowledgeBase (by =?Utf-8?B?QnJhZEB6ZWxsZQ==?= on 24 May 2004, 1 reply)
Has anyone ever created a KnowledgeBase in Access. Similar to MS Knowledgebase. I just want an idea of the difficulty. ... (more)

MY Pictures transferring Comments to a CDR disk (by =?Utf-8?B?R0FJTlNDT05TTFRAQU9MLkNPTQ==?= on 24 May 2004, no replies)
May 24, 2004 I use Microsoft XP Professional. ... (more)

Multiple Worksheet question (by =?Utf-8?B?S29wcGVsYQ==?= on 24 May 2004, 2 replies)
Very basic question (not for me however). I am trying to write a formula that calculates an answe across multiple worksheets. I just don't know how. Inputs appreciated ... (more)

Update, Append, and ID field (by Techsupport on 24 May 2004, 1 reply)
Good morning, all. Here's my question: I have a CustomerDB table, which lists all the customers and titles they subscribe to. There is of course, a CustomerID ... (more)

computer name and LAN userid (by =?Utf-8?B?S2Vu?= on 24 May 2004, 1 reply)
Does anyone have idea of how to capture the computer (workstation) name and LAN logon id? Thanks. ... (more)

Limiting View to Forms and Reports (by =?Utf-8?B?U0NITllERVM=?= on 24 May 2004, 3 replies)
Is there a way that I can set up access so no user can view items behind the scenes in Access? I have it set up so there's a start screen and the database window is hidden, but people have gotten wise to open their Database utlizing the shift key. Is there a way to prevent users from doing this and viewing items behind the scenes from the forms? I hope I didn't confuse anyone with the question, its early ha. ... (more)

Limiting View to Forms and Reports (by =?Utf-8?B?U0NITllERVM=?= on 24 May 2004, 3 replies)

Is there a way that I can set up access so no user can view items behind the scenes in Access? I have it set up so there's a start screen and the database window is hidden, but people have gotten wise to open their Database utlizing the shift key. Is there a way to prevent users from doing this and viewing items behind the scenes from the forms? I hope I didn't confuse anyone with the question, its early ha. ... (more)

Access 2003 Developer IN Which CD...... (by Mohammad Kaludi on 24 May 2004, 2 replies)
Hello All Hi I am building Application in Access 2003 I am looking for making EXE to distribute. ... (more)

ActiveX component can't create object (by =?Utf-8?B?RmFkaSBIYWRkYWQ=?= on 24 May 2004, 2 replies)
Hi I have newly installed MS office 2003 and used Access to create a new database useing a Template on my computer installed when I setup office. ... (more)

populate field using command button? (by =?Utf-8?B?bWlrZTI3?= on 24 May 2004, no replies)
This seems simple, but I just can't map it out. I have a form showing records for a simple parts/drawing database. The form is based on the main table. I want to use a command button that will run a macro to automatically populate the part number field with a new autonumber from another table, but only when necessary. In other words, not every record will have a part number. But I need the ability to go back later & create a part number for the record if necessary. Can this be done with a macro? Perhaps there is an easier way to do it, like using a "option" button to disable/enable an autonumber field in the main table when an auto number is required? I appreciate any suggestions! Thanks ... (more)

populate field using command button? (by =?Utf-8?B?bWlrZTI3?= on 24 May 2004, no replies)

This seems simple, but I just can't map it out.
I have a form showing records for a simple parts/drawing database. The form is based on the main table. I want to use a command button that will run a macro to automatically populate the part number field with a new autonumber from another table, but only when necessary. In other words, not every record will have a part number. But I need the ability to go back later & create a part number for the record if necessary. Can this be done with a macro? Perhaps there is an easier way to do it, like using a "option" button to disable/enable an autonumber field in the main table when an auto number is required? I appreciate any suggestions!
Thanks ... (more)

Sharing (by =?Utf-8?B?RG91Zw==?= on 24 May 2004, 1 reply)
Not really sure if this is a Access thing or windows 2000. Anyway I am running Access 2k on a network, the file resides on the server and I have set up databases on everyones machines linking the tables. Now the problem it only allows one user at a time stating that it is locked by user123, I have set user permissons (maybe that's my problem) but it blocks all users out .As one closes the database another can open it. I never had this problem before but before everyone was win98 and now they are win2k all pc are NTFS except the file server and it is fat 32. Any ideas/ ... (more)

Sharing (by =?Utf-8?B?RG91Zw==?= on 24 May 2004, 1 reply)

Not really sure if this is a Access thing or windows 2000. Anyway I am running Access 2k on a network, the file resides on the server and I have set up databases on everyones machines linking the tables. Now the problem it only allows one user at a time stating that it is locked by user123, I have set user permissons (maybe that's my problem) but it blocks all users out .As one closes the database another can open it. I never had this problem before but before everyone was win98 and now they are win2k all pc are NTFS except the file server and it is fat 32. Any ideas/ ... (more)

background colors (by =?Utf-8?B?bGluZ2VycGlsb3Q=?= on 24 May 2004, 1 reply)
Is it possible to add background colors to a one note document like in word. If so how do you do it. ... (more)

Close Form With No Update (by =?Utf-8?B?TWljaGFlbCBSeWxl?= on 24 May 2004, 4 replies)
I have searched high and low but I can't find a way exit a form without saving the record associated with that form. The only way out is by using DoCmd.Close, but if I set the "Save" parameter of of DoCmd.Close to "AcSaveNo", it still saves the record. I can't see that it makes any difference. Can anybody enlighten me? Thanks. ... (more)

Select combobox (by Mohamed Selima on 24 May 2004, no replies)
Dear All, I have a problem, here, I have solved it before but I can't remember how could I, I have a query based on two tables for a hospital administration, ... (more)

lookups in a form (by =?Utf-8?B?QmFycnk=?= on 24 May 2004, 1 reply)
At present i have 2 tables - a customer table that holds all the details of the customer and an order details table that lists all the details of a customers order. So far i've created a form which takes details such as the customer name and number from the customer table. I also have a subform within the form that takes the details of an order from the order table. However, currently i have to manually input the customers details into the form. Is there anyway i can lookup the customers name and number details from the customer table? ... (more)

lookups in a form (by =?Utf-8?B?QmFycnk=?= on 24 May 2004, 1 reply)

At present i have 2 tables - a customer table that holds all the details of the customer and an order details table that lists all the details of a customers order. So far i've created a form which takes details such as the customer name and number from the customer table. I also have a subform within the form that takes the details of an order from the order table. However, currently i have to manually input the customers details into the form. Is there anyway i can lookup the customers name and number details from the customer table? ... (more)

problem formatting times (by =?Utf-8?B?ZnJhbms=?= on 24 May 2004, 1 reply)
i am having trouble displaying times in reports... it occurs when the hours go over 24. I have the format of the field set as 'short time' so 1 hour 55 mins shows as 01:55, but 35 hours 20 mins is showing as 11:20 because ACCESS treats 01:55 as 01/01/1901 01:55 and 35:20 as 01/02/1901 11:20. In EXCEL you can enter a custom format of [HH]:mm to overcome this but it does not work in ACCESS. any ideas? ... (more)

problem formatting times (by =?Utf-8?B?ZnJhbms=?= on 24 May 2004, 1 reply)

i am having trouble displaying times in reports... it occurs when the hours go over 24. I have the format of the field set as 'short time' so 1 hour 55 mins shows as 01:55, but 35 hours 20 mins is showing as 11:20 because ACCESS treats 01:55 as 01/01/1901 01:55 and 35:20 as 01/02/1901 11:20. In EXCEL you can enter a custom format of [HH]:mm to overcome this but it does not work in ACCESS.

any ideas? ... (more)

Info from my web DB to my local DB from my local DB to my remote DB (by =?Utf-8?B?VGFt?= on 24 May 2004, no replies)
Okay, I have this access database on the web that is populated by the client. I want to use the information for mail merges into word docs. The problem is the only way I see I can get the information is by publishing the database from my remote to local. This is not a problem, but what happens when I need to change the status of an account or put in notes? If I publish from my local to the remote site, won't the remote database lose any new information clients have put in? What is the solution? Thanks. ... (more)

Info from my web DB to my local DB from my local DB to my remote DB (by =?Utf-8?B?VGFt?= on 24 May 2004, no replies)

Okay, I have this access database on the web that is populated by the client. I want to use the information for mail merges into word docs. The problem is the only way I see I can get the information is by publishing the database from my remote to local. This is not a problem, but what happens when I need to change the status of an account or put in notes? If I publish from my local to the remote site, won't the remote database lose any new information clients have put in?

What is the solution? Thanks. ... (more)

Converting an Integer into a Date (by =?Utf-8?B?Sm9obg==?= on 24 May 2004, 3 replies)
Dear All, NumberVar Yyyy; NumberVar Mm; ... (more)

Design Master Corruption (by =?Utf-8?B?SGFucw==?= on 24 May 2004, no replies)
Hi , I have set up a design master with a couple of replicas at a client's premises. ... (more)

Access/Excel (by =?Utf-8?B?RmVsaXBl?= on 24 May 2004, no replies)
I want to know how I can create a relationship between a data base in Access and Excell that by just entering the first number the rest of the coluns related to this number automatically appears and complete the sheet. ... (more)

Clean up a form (by =?Utf-8?B?SmVycnk=?= on 24 May 2004, 5 replies)
Is there a method to initialize all controls in a form? That means move blanks to text control or zero to numeric control. ... (more)

Combo box selection updating text box? (by =?Utf-8?B?Q2gzM2No?= on 24 May 2004, 1 reply)
Hello there- I have a number of text boxes that I need to update from a choice the user has made on a check box. I have been able to bring out different columns using the bound column deal, but I can't seem to replicate it to update other text boxes. My cbo is bound to a Last Name field and I'm looking to update other txt boxes (First Name, DOB, etc...) with each selection of the Last Name . ... (more)

Combo box selection updating text box? (by =?Utf-8?B?Q2gzM2No?= on 24 May 2004, 1 reply)

Hello there-
I have a number of text boxes that I need to update from a choice the user has made on a check box. I have been able to bring out different columns using the bound column deal, but I can't seem to replicate it to update other text boxes.
My cbo is bound to a Last Name field and I'm looking to update other txt boxes (First Name, DOB, etc...) with each selection of the Last Name . ... (more)

Re: Email Links (by =?Utf-8?B?VGVyZXNh?= on 24 May 2004, no replies)
This is a nice work-around to avoid the dreaded "hyperlinks can be dangerous" message. Important question -- do you know how to change the cursor from the arrow to the pointer? It changes automatically when it's an actual hyperlink but this approach only makes it look like a hyperlink. thanks in advance for your response. ... (more)

Error Message Upon Closing Application (by =?Utf-8?B?Q2hhcmxlbmUgSG9mZm1laXN0ZXI=?= on 24 May 2004, 3 replies)
Getting the following message when trying to close application. Table TempMSysAccesssObject already exists ... (more)

Access 2003 common file open dialog (by Matt Gauch on 24 May 2004, 1 reply)
For many years I have been using the function declaration below (from Getz/Litwin/et al's Access Developer's Handbook) to use the Windows common file open dialog box to get a file name. However, I just ported my code utilities library (which contains this code for the common file dialogs) to ... (more)

Frustrating data entry problem (by John on 24 May 2004, 2 replies)
Hi I have a very frustrating problem. I had a perfectly working app with a sub form on a main form. I added a few fields in tables here and there and now I ... (more)

consequetive numbering (by Polly on 24 May 2004, no replies)
Hi there, [Date] [ClientID] [CourseNumber] [EmployeeID] [VersionNumber] 0504 111 300 123 V3 ... (more)

How do I preserve three dots? (by Brian Kastel on 24 May 2004, 6 replies)
When I attempt to enter three consecutive dots into a field, Microsoft Access insists that I REALLY wanted to enter an ellipsis character (Alt+0133) and proceeds to change them to it. Access is so insistent that this is my REAL intention that it has thwarted every attempt I have made to ... (more)

Looking for a slick way to test for an unopened recordset (by MyndPhlyp on 24 May 2004, 6 replies)
I've tried IsNull() and IsEmpty(), but both return false. If rs = Nothing Then ... ... (more)

Testing if a string is Ucase or not (by Scotty on 24 May 2004, 2 replies)
Hi, Can anybody tell me how to test if a string is Uppercase (Ucase) or not ? ... (more)

Re: Bug/Feature?! (by Dirk Goldgar on 24 May 2004, no replies)
"Micah Miller" <micah.miller@privacy.me> wrote in message news:10b4db0pj4ufp6f@corp.supernews.com I'm working on an app right now that uses linked SQL Server tables, and ... (more)

help with database . (by GabrielG on 24 May 2004, 1 reply)
Hello everyone , approximately 20 columns. The columns have an entry of Yes or no base on a questionnaire from survey. What can I do to get a result of my table I would like to know how many "Yes" and "no" I have. I don't know how to add them or ... (more)

New and need to learn how to Copy (by firedog on 24 May 2004, 1 reply)
Hello, I�m new to access and have done pretty good so far but have run into a problem. I have 4 different tables. Table 1 is the main table that I ... (more)

LoGGeD USeR??? (by killerkamatis on 24 May 2004, no replies)
can i know the users who logged onto the DB (username, time, etc.) and - Thanks!!! ... (more)

FYI new version of Auto FE Updater (by Tony Toews on 24 May 2004, 3 replies)
This utility is designed to automatically update the front end MDE and associated files from the server to the client workstation or directory on the server. The utility will, if required, create the directory on the workstation, copy files to workstation, create a shortcut on the desktop and update registry keys. It will then ... (more)

Emergency combo box (by Dr. Selima on 24 May 2004, 4 replies)
Dear All, I have a problem, here, I have solved it before but I can't remember how could I, I have a query based on two tables for a hospital administration, ... (more)

help: archives? (by G. Sahakian on 24 May 2004, 7 replies)
hello, this is probably not the right place but I cannot see where to ask; would anyone be so kind as to tell me if and where there are archives for microsoft.public.* NGs, since they are not in Googles; thanks a lot. ... (more)

HOW CAN I VERIFY WHEN WITHDRAWING AN ITEM FROM A STORAGE IF IT EXISTS IN THE STORAGE? (by Chris on 24 May 2004, 2 replies)
I have a database for an existing stock in a warehouse. I made a table with the entries in the storage, and a query with the total of materials which are in the repository at a moment, for each name of the material, quality dimension, measurement unit and price. ... (more)

HELP! Verifying the existence of an item in a storage before taking it out (by Chris on 24 May 2004, 1 reply)
I have a database for an existing stock in a warehouse. I made a table with the entries in the storage, and a query with the total of materials which are in the repository at a moment, for each name of the material, quality dimension, measurement unit and price. ... (more)

use weeknum, networkdays (other functions in msowcf.dll) (by Preston Miller on 25 May 2004, 1 reply)
I would like to use the "weeknum" or "networkdays" functions in a Query but they don't show up on my list of built-in expressions. The Access help file says I need to install msowcf.dll to use these functions. ... (more)

restore data (by =?Utf-8?B?ZWRhdmlz?= on 25 May 2004, 2 replies)

One of our users inadvertantly changed data using an update query. 871 of our clients now have the same last name. Is there any way to restore the correct last names? I have a back up disc but it is 3 weeks old (I know, I know). I would rather find a way to undo her error rather than overwrite and reenter data. I have heard that there is a maintenance command to get access to go back to a previous date and give you the information from that date. Any help would be appreciated. ... (more)

Switchboard (by Dazza on 25 May 2004, 1 reply)
Hi, I'm not sure if this is the appropriate forum but I have a switchboard that has two levels. I have an input form that I'd like to add a control button that would take the user to the second level of the switchoard not ... (more)

Hyperlink help (by millie6169@hotmail on 25 May 2004, 1 reply)
"Hyperlinks can be harmful to your computer and data.To protect your computer, click only those hyperlinks from trusted sources. Do you want to continue?" ... (more)

Shared Code (by Dave Ruhl on 25 May 2004, 3 replies)
I am creating a new application and want to use many of the functions I have created in modules of another application. Is there a way I can store these modules so they can be accessed by multiple apps ? If I modify a ... (more)

Problem readin Numbers (by John on 25 May 2004, 4 replies)
my database has to be able to generate a VIN number. the last 6 digits of that VIN is a serial number. ex: 000083 ... (more)

error code 3197 (by BarryP on 25 May 2004, 1 reply)
How do I access the database after the jet engine locks me out with this error code 3197? ... (more)

File Time Stamp (by Bob on 25 May 2004, 2 replies)
The 'Last Modified' time stamp being added to an Access DB is four hours behind the system time. Can this be adjusted somehow? Thanks. ... (more)

mdb file created in yr 1763??? (by Cheri on 25 May 2004, 3 replies)
My file is obviously corrupt or something. I've tried to compact and repair the database, but no dice. Things still don't work correctly. I've gone to my backup, and tables/queries/reports are intact, but that file too has a ... (more)

top value question (by Ramone on 25 May 2004, 2 replies)
Hello All, I have a query that sorts dollar amounts and i would like to create a field that assings a 1 to the top value and 0 ... (more)

Switching Modes at Runtime (by ZooBaby on 25 May 2004, 2 replies)
Is there a way to dynamically (using VBA) switch RUN mode in Access97 to EDIT/Design mode without holding down the SHIFT Key upon start up? ... (more)