microsoft.public.access

Message Index 23 for News Group microsoft.public.access

Wizard help? (by =?Utf-8?B?bWFieW4=?= on 27 May 2004, 5 replies)
I created a Contacts Database with one of the wizards. Then, I went to the Contacts form and switched it to "database". Line by line, I have been cut and pasting info from an Excel file that is "way wacko out of order from this wizard database" and placing it individually in each cell. I didn't do all of the info because I wanted, of course to make sure it worked. Well, the information winds up in a nice table once saved however, when I exit the program and re-enter the info is not showing up under the database form Contacts. Is there a way to link it back? If so, can you direct me? I was trying to short cut the entry because there is so much to enter. Thanks for the assistance. ... (more)

Wizard help? (by =?Utf-8?B?bWFieW4=?= on 27 May 2004, 5 replies)

I created a Contacts Database with one of the wizards. Then, I went to the Contacts form and switched it to "database". Line by line, I have been cut and pasting info from an Excel file that is "way wacko out of order from this wizard database" and placing it individually in each cell. I didn't do all of the info because I wanted, of course to make sure it worked. Well, the information winds up in a nice table once saved however, when I exit the program and re-enter the info is not showing up under the database form Contacts. Is there a way to link it back? If so, can you direct me? I was trying to short cut the entry because there is so much to enter. Thanks for the assistance. ... (more)

Please help with this: Subform selection (by Dr. Selima on 27 May 2004, no replies)
Dear all, I have a data base for My patients with the first form about the patient data like [Name], [Age], [DOB], [ADDRESS], [PTID]...etc, this is linked to a subform about the visits: through The [PTID] (1--->?), the fields in this ... (more)

Disable macros? (by Billy R. Moon on 27 May 2004, 2 replies)
Has anyone ever come up with a way to disable macro creation within MS Access? Not just on a project level, but to prevent macros from being created and/or ran on a particular PC or by a particular user. ... (more)

User groups in VBA Code (by Jim Franklin on 27 May 2004, 3 replies)
Hi, Can anyone tell me if it is possible to determine whether the current user is a member of a particular user group by using code. I want to modify the ... (more)

Calculations using dates (by Ant on 27 May 2004, 4 replies)
I am putting together a bit of a HR database but I am struggling with a couple of date calculations. The First ... (more)

Force Access to create non multilanguage database. (by Homa on 27 May 2004, no replies)
Hi all, I want to know how to force Access 2000 to not create the database in multilanguage even if the OS support multilanguage. Be specific, ... (more)

Access and Switchboard (by knausen on 27 May 2004, 1 reply)
Hello i have an Accessfile with a Switchboard I have removed the toolbar and menues from this and I cant get it back. ... (more)

General approach? - Reducing Inventory (by Ken on 27 May 2004, 10 replies)
I have an Item table which includes a 'UnitsOnHand' field. I have a Transaction table and a TransactionLineItem table, as each Transaction can have 1 or more TransactionLineItems. ... (more)

QUESTION (by juror on 27 May 2004, 1 reply)
WHAT INCOMING AND OUTGOING MAIL SERVER SHOULD I USE TO SET UP A MAIL? ... (more)

How many records will Access handle efficiently? (by Woody Splawn on 27 May 2004, 1 reply)
I have a client that needs a custom database application written for a non-web type application. The question is whether to do it in Access or perhaps with Visual Basic.net and SQL Server 2000. Access would be simpler but it is not clear to me the number of records that Access may handle well. ... (more)

Comparing Data (by Daniel Biancuzzo on 27 May 2004, 2 replies)
I am maintaining a large amount of data with respect to Product and Pricing information, and as such we continually update products/prices from over 300 separate vendors. ... (more)

Cannot insert form result to Access DB more than one records (by xfile on 27 May 2004, 1 reply)
I am trying to come up an ASP page for processing form input and to send form results to an Access database and an email. I have been stuck to the following procedures and simply don't know how to ... (more)

Access references (by hin on 27 May 2004, 1 reply)
Hi Do I need to have a reference to "Microsoft Shell Controls and Automation"? ... (more)

Fastest/best way to look up a record by key? (by MyndPhlyp on 27 May 2004, 3 replies)
Assuming a unique value on an indexed column and ADODB.Recordsets (cursor = adUseClient), what is the fastest or best way to retrieve a row - .Filter, .Seek or .Find? ... (more)

Removing Close Control from Access 2002 Application (by caretta on 27 May 2004, no replies)
I have an access 2002 application. I want to prevent users from close the application by clicking close button accidently. So i want to remove close button from the title bar or writing a code part that asks users for verification close request. ("Do you really want to exit " etc) ... (more)

sorting primary key properly (by Kevin on 27 May 2004, 2 replies)
Must be simple, but can I please know how to set Access to sort its pk in a human way, recognizing all the characters in the pk number, and not sorting just on the first character? ... (more)

Urgent File browser (by Dr. Selima on 27 May 2004, 2 replies)
Dear All, thanks for your great Help, I have a problem here, I have a Database for endoscopy, In which i want to 1-make a picture field with a command button to open a file browser so that ... (more)

Change keyboard language (by Alain Gagnon on 27 May 2004, no replies)
I get an english keyboard " Labtec" : Can I configure it in french to get the accent touch? Thanks ! ... (more)

my home page change unexpectedly (by iraj on 27 May 2004, 2 replies)
I need help to get my home page fixed ... (more)

Retrieve autonumber (by Efrain Flores on 28 May 2004, 2 replies)
I would like to know how to retrieve the autonumber value assigned by access 2002 using vba. If you know any online resources wher I can find this or you have any code that could help me, I will really appreciate it ... (more)

New to Access (by =?Utf-8?B?RG9ubmll?= on 28 May 2004, 4 replies)
Hey all.I am building a dispatch database project in Access, that will hold all of our customer records, their dispatch history, their HVAC equipment information, etc... Basically, it is going to be a large relational database with probably four or five tables. We know what we want it to do, its just up to me to get it designed and functional. My problem has been that I cannot find any good information on building the type of database that I want to build. The books that I have dont really go too in depth about designing forms that will be able to have sort of dynamic queries. For example, I want to have a field on one of the forms where you could enter a customers name, address, or phone number, and then do a search to retrieve that customers dispatch history and equipment information. I also need to find a way to e able to enter a dispatch into a form, and have that information go into that customers dispatch history, as well as display the dispatch on a schedule board for the technician that will be doing the service call. These are only a few of the problems that I have not been able to find info about. I know what we are trying to do is possible with Access. Can anyone point me to a good source of online information, tutorials, etc? Also, is there a really good sort of all in one "teach Yourself Access" book? Like a Sam's book? Thanks for your time. Donnie ... (more)

New to Access (by =?Utf-8?B?RG9ubmll?= on 28 May 2004, 4 replies)

Hey all.I am building a dispatch database project in Access, that will hold all of our customer records, their dispatch history, their HVAC equipment information, etc... Basically, it is going to be a large relational database with probably four or five tables. We know what we want it to do, its just up to me to get it designed and functional. My problem has been that I cannot find any good information on building the type of database that I want to build. The books that I have dont really go too in depth about designing forms that will be able to have sort of dynamic queries. For example, I want to have a field on one of the forms where you could enter a customers name, address, or phone number, and then do a search to retrieve that customers dispatch history and equipment information. I also need to find a way to e able to enter a dispatch into a form, and have that information go into that customers dispatch history, as well as display the dispatch on a schedule board for the technician that will be doing the service call. These are only a few of the problems that I have not been able to find info about. I know what we are trying to do is possible with Access. Can anyone point me to a good source of online information, tutorials, etc? Also, is there a really good sort of all in one "teach Yourself Access" book? Like a Sam's book? Thanks for your time. Donnie ... (more)

can't get Export Wizard to run (by =?Utf-8?B?ZGViYmll?= on 28 May 2004, no replies)
I am trying to export a database to a .txt file. I want to be able to specificy the delimeter but I'm unable to because the export wizard never appears. In my researching this problem, the sandbox mode seemed to be the culprit. I installed Jet 4 SP 8 plus I changed my security level to 2. This did not help. All I want to do is to be able to export a dbase and designate the delimeter. (it should NOT be this difficult) Any help is appreciated!! ... (more)

can't get Export Wizard to run (by =?Utf-8?B?ZGViYmll?= on 28 May 2004, no replies)

I am trying to export a database to a .txt file. I want to be able to specificy the delimeter but I'm unable to because the export wizard never appears. In my researching this problem, the sandbox mode seemed to be the culprit. I installed Jet 4 SP 8 plus I changed my security level to 2. This did not help. All I want to do is to be able to export a dbase and designate the delimeter. (it should NOT be this difficult)
Any help is appreciated!! ... (more)

How to assign to a recordset (by =?Utf-8?B?V0MgTG8=?= on 28 May 2004, 2 replies)
I am using ADO to open a recordset. After opened, I need to inner join this recordset with another ADO recordset. How can I assign this recordset to a variable? Thanks. ... (more)

Year Fraction (by grace on 28 May 2004, 6 replies)
Excel has a function named yearfrac() which calculates number of days between two dates. You can specify if you want it to use a 360 or 365 day year. I would like to use this in Access. Access help lists the function but it is ... (more)

lost records! (by Tim on 28 May 2004, 1 reply)
I'm working with a database of about 60,000 students and each have a number of lessons that are stored in a separate lessons table. This table has about 460,000 records. ... (more)

Parameter Query (by Reggie on 28 May 2004, no replies)
trying to build a parameter query that will look for the same value in multiple fields with one prompt for the criteria for all(the criteria will be the same for all)...Mr Seach was gracious enough to respond with: ... (more)

Has anyone created a Minimum Basline Standards document for MS Access database applications? (by anonymous on 28 May 2004, no replies)
Ive created two. I use this machine that I bought at Sports Authority. You load it up with chalk, and you wheel it down the 1st and 3rd baseline, and it leaves a straight white line between home plate and the two ... (more)

Locking Fields (by Judy on 28 May 2004, 1 reply)
If a form field is locked form editing, does that mean it is locked for all other forms created? Thanks ... (more)

Append Query not Working Properly (by Brian on 28 May 2004, no replies)
I currently have a very simple database with a "Products" table and a linked Foxpro table. Basically, the DB is scheduled to run two queries once a day that deletes the records in the Products table, then appends the values in ... (more)

Application Errors (by Pete on 28 May 2004, no replies)
I am receiving error messages when I attempt to access fields w/in a certain Access 2000 database. The file opens but there is no response when attempting to open a field. The application shuts down showing 2 ... (more)

Creating an Outlook appointment (by Michael D. Wallen on 28 May 2004, 4 replies)
I am able to create and Outlook appointmernt (as shown in Microsoft Knowledge Base Article - 160502) but this creates the appointment in myu own calendar. does anyone know how to create an apointment in someone else's ... (more)

Validation Rule (by nl on 28 May 2004, 1 reply)
How can I create a validation rule in a table, example Table name: ccgc Field name: Status ... (more)

Export Error (by Steve on 28 May 2004, 3 replies)
The formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing from the Windows Registry. ... (more)

360 vs 365 Day Years (by Grace on 28 May 2004, 2 replies)
Excel has a function named YearFrac() which I would like to use in Access. It is listed in the Access help, however, when I include it in a query it says it is not defined. Can this function be used in Access? ... (more)

Checking for duplicate data & creating error msg if exist. (by jdtivoli on 28 May 2004, 1 reply)
I have a table with serial number fields which I have set as indexed in order to prevent duplicate entries. I have created a form for data entry. When I enter data ... (more)

sql view (by Byron on 28 May 2004, no replies)
The sql view you are refering to is one of the ways to veiw a query when using the QBE to create or view a query. If you have an sql statement as the record source of a ... (more)

Future of Access? (by Debbie on 28 May 2004, 6 replies)
Hi all, Has anyone seen a statement of direction for Access? Moreover, how does it fit into the .NET schema? Any info or direction would be great. Thanks, ... (more)

Import, Delete Append Macro (by Dennis on 28 May 2004, 2 replies)
I have a database where I import, delete and append records into a table. It seems to work except when I press the button that activates the macro and the import disk is not in the A:Drive. I then delete all of the records that ... (more)

QBF (by anonymous on 28 May 2004, 5 replies)
Can any one help!! I am using Access to run quesries. My queries have a least 5 prompts. I thought that using a form would be ... (more)

Table Design (by Ken on 28 May 2004, 1 reply)
I am using 2000 XP. I have quite a few different databases with several tables each. I noticed that in some of the tables the Unicode ... (more)

Can Access perform batch files? (by Tiffany on 28 May 2004, 2 replies)
Can Access perform dos commands like activating a batch command to copy files from one drive to another? If so how? I will need an example if possible. Thank you in advance. Tiffany ... (more)

Table off page (by =?Utf-8?B?VHJldm9y?= on 28 May 2004, 5 replies)
After I make an edit to the design of a table save and close it, the table moves in the relationship window. Now normally this is not a problem, but occasionaly the table moves off the page beyond the scroll bars. How can I retive the table without having to re-order all my relationships? ... (more)

RE: error 2495 (by David on 28 May 2004, no replies)
Sub NewKits() Dim RelNum DoCmd.SetWarnings False ... (more)

#of fields (by jjrmy1 on 28 May 2004, 3 replies)
does anyone know what is the maximum number of fields that can be updated at Microsoft JET Database Engine error '80004005' Too many fields defined. ... (more)

gnant charts (by =?Utf-8?B?S2VsbHkgV2lsbGlhbXM=?= on 28 May 2004, 3 replies)
we are looking into software that we could produce gnant charts for our construction development company. Any suggestions or is there a template in access we could use? Thank you, ... (more)

How to put query result in the textbox of a form 5or in a dynamic report)??? HELP REQUIRED!!! (by =?Utf-8?B?Q2xpY2tvbw==?= on 28 May 2004, 4 replies)
Hi, I've got a problem and I need help urgently. I'm using combo boxes to set up the criteria for my queries. Once specifying the required parameters in the combo boxes on my form, the query is automatically run coming up with the query result. What I am trying to do is to put the result of my query in a textbox present in the form. The problem is that I just can't manage to do that!!! I've already tried setting the control value of the textbook as the value of the query using the Expression Builder, but it isn't working! Can anyone PLEASE help me as soon as possible? ... (more)

How to put query result in the textbox of a form 5or in a dynamic report)??? HELP REQUIRED!!! (by =?Utf-8?B?Q2xpY2tvbw==?= on 28 May 2004, 4 replies)

Hi,

I've got a problem and I need help urgently. I'm using combo boxes to set up the criteria for my queries. Once specifying the required parameters in the combo boxes on my form, the query is automatically run coming up with the query result. What I am trying to do is to put the result of my query in a textbox present in the form. The problem is that I just can't manage to do that!!! I've already tried setting the control value of the textbook as the value of the query using the Expression Builder, but it isn't working! Can anyone PLEASE help me as soon as possible? ... (more)

Restrict input in combo box (by =?Utf-8?B?QW5uYQ==?= on 28 May 2004, 4 replies)
I want to restrict user to type in combo box but must select from the list. Appreciate if anyone can help me. Thanks. ... (more)

Auto select the first item of a combo box (by =?Utf-8?B?QW5uYQ==?= on 28 May 2004, 2 replies)
Is it possible to display the first item of the list in a combo box when the form is loaded? ... (more)

Mail Messages (by Niko Kauffman on 28 May 2004, 2 replies)
How do you get e-mail messages from one e-mail program to another? ... (more)

Combox additions (by =?Utf-8?B?VHJldm9y?= on 28 May 2004, 4 replies)
Is it possible that a combox can accept both entries selected from the list as well as new entries? i.e if the user can not see a valid entry in the list they can input new values by typing in the field. Cheers. ... (more)

Upgrade from Access95 (by =?Utf-8?B?bWlrZSByZWV2ZXM=?= on 28 May 2004, 1 reply)
As this is a pre-historic version, can anyone advise of an upgrade path to something newer (e.g. 2000,2002). Our organisation runs Win2000 and WinXP but WinXP is the preference. Can we convert to Access2000 without losing data or programs? ... (more)

Data Page 2003 doesn't work with 2000 version (by Christiane on 28 May 2004, no replies)
HI, I made a data access page with Access XP, using Access 2000 format. The page is on our Intranet server. Users could access it without any ... (more)

How can I check to see which Web componenets are installed on my PC? (by Christiane on 28 May 2004, no replies)
HOw can I check to see which Web componenets are installed on my PC? Thanks Christiane ... (more)

VBE hangs ..... (by =?Utf-8?B?V0MgTG8=?= on 28 May 2004, no replies)
I have the below code. The VBE got hanged when I add the code "Dim qry1 As Recordset". After complete typing the line, the VBE hangs when I move the mouse cursor away to another line. This is quite strange. Any idea? Thanks Private Sub cboProduct_AfterUpdate() ... (more)

Versions 2002 and 2003 (by =?Utf-8?B?S3Jpc3Rlbg==?= on 28 May 2004, 2 replies)
Hi- Can someone please tell me: are there distinct differences between Access versions 2002 and 2003? Any information would be greatly appreciated. ... (more)

Criteria to open form (by =?Utf-8?B?YmRlaG5pbmc=?= on 28 May 2004, 1 reply)

I have a form that is used to update several fields from different tables.

SELECT DISTINCTROW [Account Information].[Account Name], [Account Information].[Policy Number], [Account Information].[EAP], [Account Information].[X-Mod], [Account Information].[Underwriter], [Account Information].[Agency Name], [Account Information].[Agency Contact], [Location].[Location Address], [Location].[Location City], [Location].[Location State], [Location].[Location Zip Code], [Location].[Location Contact Name/Title], [Location].[Location Phone], [Location].[Location Email], [Location].[Assigned Consultant] FROM ([Account Information] RIGHT OUTER JOIN [Location] ON [Account Information].[Policy Number] =[Location].[Policy Number]); ... (more)

No Security level tab (by =?Utf-8?B?Unlhbg==?= on 28 May 2004, 5 replies)

After updating to Office 2003, the Access databases started opening giving a message about 'this file may not be secure. Are you SURE you want to open it?' These messages are unwanted and unneeded. I searched the help, and found that by changing the security level to 'low' it might prevent these messages. However, on the Security menu, there is no 'Security level tab' seen. I went through the process of adding the 'Security' to the menu, but in it there's no sign of a security level tab, so there's no obvious way to fix the bug (another Microsoft bug) without going into the registry. I am interested in learning if there is another way to fix this problem. Most of the other messages here regarding this problem have not had the problem of no 'security level tab'. Any ideas (other than going backwards and re-installing the older but less bug-infested version of Microsoft Office)? ... (more)

How to Lookup (by JGM22 on 28 May 2004, no replies)
Not sure how the best method would be but here is what I am trying to do. Table 'Paper' includes fields - vendor, paper size, paper weight, cost ... (more)

Can't export files. (by Sam on 28 May 2004, 1 reply)
Hi, First, thank you to Cheryl Fischer for telling me how to open Access. Below is copy of my original post, and her reply. Here is my an addition to ... (more)

uninstali office2000 prem edt (by Arjang on 28 May 2004, no replies)
long time ago i had loaded beta ofc2000 that expired long ago, and i don't have original cd's any more, now even with ofc2003 on my system, i still can't >uninstall< ofc2000, keeps asking for the cd that i don't have, any one can help?(like when spell checking or other document stuff, it prompts ... (more)