microsoft.public.access

Message Index 9 for Usenet Archive microsoft.public.access

LIST , COMBO, PULLDOWN BOXES (by REGGIE on 12 May 2004, 1 reply)
i need to insert one of the above onto a form, i don't want the whole list to show initially, and i want to be able to select multiple items...is this possible, and if so what would i use and how ... (more)

upcase and cursor at the first position in a text box. (by jen on 12 May 2004, 4 replies)
Hi, Can anyone tell me how to do the following:? 1. Whatever characters(either upcase or lowcase) a user ... (more)

error w/ copying a record to a new line... (by Ruben on 12 May 2004, 2 replies)
When I add a new record at the end of the db I first type in the first field (which is numbered sequentially) but in the next field when I want to copy the field above it I use my arrow key to go up. Now when I do this, the whole ... (more)

Getting columns to total in Access (by s_pdavis@sbcglobal.net on 12 May 2004, 1 reply)
Can anyone tell me how I can get Access to total columns in a report, like Excel does? I am really at lost on this one. Any suggestion, I will be glad to try. ... (more)

Multiple Instances of Access (by Michael Johnson on 12 May 2004, 1 reply)
I have computer that will open only one instance of Access can anyone tell me how to fix this problem. ... (more)

ODBC tables and Task Scheduler (by Kelly on 12 May 2004, 2 replies)
Our database has linked ODBC tables that are linked to Oracle tables. The mdb database only does some basic file processing, i.e. there is no real user interaction. I have set up Tasks via the Windows Task Scheduler to ... (more)

Permissions (by Bruce B on 12 May 2004, 1 reply)
Hi, I'm working on setting permissions on an Access Database at the folder and file level. I've found out previously that in order to make an mdb read-only it's folder has to have "full control" while the read only is ... (more)

Data on a Command Button (by Mariagloria on 12 May 2004, 3 replies)
Hello, can anyone help me with this? I need to display a data field on a command buttom. The same button I'll use to display the datail. ... (more)

Access limits (by Nick on 12 May 2004, 3 replies)
I have been requested to import a lot of text files into Access. The number of rows (5 columns) would be in the millions. Anyone have a guess at the practical max number of rows I can put in a table? ... (more)

MSACCESS PAGE FAULTS (by J.W. Armstrong on 12 May 2004, no replies)
GETTING THE FOLLOWING MESSAGE: MSACCESS CAUSED INVALID PAGE FAULT IN MODULE KERNEL32.DLL AT 017f:bff8585c SOFTWARE HAS BEEN WORKING FOR A NUMBER OF YEARS ... (more)

Changing Sub Form RowSource (by Dave Ruhl on 12 May 2004, 3 replies)
Hello, I'm trying to change the RowSource of an un-linked subform based on search criteria entered on the main form. The main form uses the criteria to show the results in one format, the subform shows it in another ... (more)

Web Application Guidence... (by Squid on 12 May 2004, no replies)
I want to build a database driven web page but unsure how to get started. I want to have printed reports to be printed to file ... (more)

Access forms on PDAs (by Randy Wayne on 12 May 2004, no replies)
I am looking for either an application or advise on creating forms for a Windows based PDA to sych with my Access project (adp). ... (more)

trail for access (by Karen on 12 May 2004, 1 reply)
If I download the free trail for 30 days, can I do it again when the 30 days is up? I'm taking a class online that requires this. I only need it for 8 weeks. ... (more)

Access/Outlook Error: Object not found (by Tim Brown on 12 May 2004, 1 reply)
Hi, I have an Access database (Access 2003) that sends email via CDO to Outlook 2003. Both are running on a Win 2003 ... (more)

remote access (by Robjim on 12 May 2004, 1 reply)
How do i know if my computer is set up for "remote access" without my knowledge? Will i know if someone is remote;y accessing my computer while i am on it? ... (more)

Method 'CurrentDb' of object '_Application' failed (by KramarDanIkabu on 12 May 2004, 1 reply)
Yeah, whenever I try to create a form using a wizard I get this error, does anybody know what this means and if so please send me the answer. ... (more)

date validation (by helena on 12 May 2004, 3 replies)
I have an unbound date field that is masked "99/99/0000;0;_" (short date). What I want is to provide my own error message instead of using the default system error message. Where does the error "trigger" when ... (more)

Access 2003 Importing missing File types (by Tony T on 12 May 2004, 1 reply)
I have tried everything to resolve this issue with Access 2003 Importing missing most File types. Currently when selecting GET EXTERNAL DATA / IMPORT ... (more)

A couple of questions that an expert could help me with (by David Carter on 12 May 2004, 2 replies)
Hi, How do I enforce business rules in a table to automatically link 2 attributes in a table i.e. - if a change is made to an attribute in a table to ... (more)

Faulting application msaccess.exe (by AnandAmmu on 12 May 2004, 1 reply)
Hai all, i am getting the following problem once per week with MSAccess Application which runs 365 days and 24 hours on a ... (more)

Data taken from one record and placed into another record (by Jon on 12 May 2004, 1 reply)
I have a database that mysteriously takes information from fields in one clients record and places it into the fields of another client record. This happens sporadically. I end up finding data all over the place. ... (more)

Access 2000 Create Table Wizard (by RG on 12 May 2004, no replies)
I am trying to invoke create table wizard and nothing happens. Would anyone know the reason for this? Is there settings enabling it? ... (more)

create table? (by js on 12 May 2004, 1 reply)
Hi, SELECT Last_Name,First_Name,Phone_1, count(*) AS Counter INTO #holdkey ... (more)

whatswrong? (by jjrmy1 on 12 May 2004, 3 replies)
does any one see anything wrong with this? I'm trying to select all records in which it is only 30 days untill the date entered in column nextcpr. i use format mm/dd/yyyy. it must always select the records 30 days or less, greater than the current date. ... (more)

Problem deleting a record in a SQL Server linked table! (by Nuno Almeida on 12 May 2004, no replies)
Hi, Sometimes, when I try to delete a record in a SQL Server linked table, through a Microsoft access form, I get the following error message: "The ... (more)

How to test for "#Error" condition in calculated field in a query (by Ivan Starr on 12 May 2004, 2 replies)
Hello, thank you for helping. I have a Calculated field in a query that refers to another field in the query that may or may not be NULL, or uninitialized or whatever. The ... (more)

Price Dependant on Quantity (by jagstirling on 12 May 2004, 1 reply)
If I have a table of customers and the prices they are charged for a product depending on the quantity they purchase (such as); 0-10 Items $1.00 ... (more)

Jet Database Engine Error (by Sylvan Jonas on 12 May 2004, 6 replies)
We have a database in Access that was created in an earlier version. It was migrated to Access XP and has worked fine for the past several months. It "The Microsoft Jet Database engine stopped the process because you and another user are attempting to change the same data at the same time." ... (more)

Delete file outside access (by Richard on 12 May 2004, 1 reply)
Hi Are we able to delete files from access through code? ... (more)

using Access 2000 can I convert a dbase file (by L. T. Portella on 12 May 2004, 3 replies)
With Access 2000 I can easily read a dbase file. but can I save that dbase database file as an Access 2000 table? thank you ... (more)

Include query criteria in report (by Mack on 12 May 2004, 3 replies)
I have a report that is generated with a query with "between dates" criteria in the query. How can I include the dates used for the query criteria in the report? ... (more)

Simple Syntax Question (by Tony Ciconte on 12 May 2004, 1 reply)
"Application.DoCmd.Minimize" seems to only minimize the active screen. What I need is a VBA code equivalent of the action when you click the minimize ("-") button at the very top right of the Access screen. ... (more)

WINDOWS XP (by harry bowling on 13 May 2004, 2 replies)
I just installed windows xp this spring. It worked alright but now it is crazy. This thing will tie up without the least bit of use. Then I do a control alt del and stop the program from running and I am back to the desk top. ... (more)

.NET Framework (by Rajika Somasiri on 13 May 2004, 1 reply)
Is there any thing in the .NET framework which provides the capabilities of "struts" in Java. ... (more)

changing color of tabcontrol (by meir rotfleisch on 13 May 2004, 2 replies)
Hi Does anyone know how to control the color of the tabcontrol ? ... (more)

I WANT duplicates (by =?Utf-8?B?U3RldmU=?= on 13 May 2004, 3 replies)
Last_Name,First_Name,Emp_ID,Hours_Day,Days_Week,Week_Number,Project,Cost_Type All fields come from a form. On the form is a Start_Week and Duration combos. I can create a table with the fields listed above with a start week (number). Then add a record with the same information changing the start_week number by adding the duration to it. The problem arises when I need to fill in the records in between. I tried to pass off the above table with just the addition of a Duration field in it, but the boss said I needed to populate the table with individual records that increment the week_number field. ... (more)

I WANT duplicates (by =?Utf-8?B?U3RldmU=?= on 13 May 2004, 3 replies)

Last_Name,First_Name,Emp_ID,Hours_Day,Days_Week,Week_Number,Project,Cost_Type

All fields come from a form. On the form is a Start_Week and Duration combos.
I can create a table with the fields listed above with a start week (number). Then add a record with the same information changing the start_week number by adding the duration to it. The problem arises when I need to fill in the records in between. I tried to pass off the above table with just the addition of a Duration field in it, but the boss said I needed to populate the table with individual records that increment the week_number field. ... (more)

excel viewing options (by =?Utf-8?B?Um95YQ==?= on 13 May 2004, 1 reply)
I have an excel workbook. I want to share it with other people in the company. I have remove all viewing possibilities from each sheets, for example formula bar, sheets tab...I don't want anyone to change that even when they open this sheets on their computer. How can I do that? ... (more)

What I would like to do is create a report from data stored with in a table (tbl_consultations) with the following criteria:- (by Barry McConomy on 13 May 2004, 4 replies)
Hi New user. ... (more)

Re: Access 2K Error: too many fields defined. (by =?Utf-8?B?TWVsYW5pZQ==?= on 13 May 2004, no replies)
Sorry for replying so late. I solved the problem by creating a new database and importing the data. ... (more)

Re: Date Format Question (by Rick Brandt on 13 May 2004, no replies)
Generally when you need to "massage" imported data, it is best to import into a work table and then do the cleanup on the work table data. In your case if the work table stored the value as a number you could then use a query expression of... ... (more)

Calendar popup other than MS one? how to code into a solution? (by StargateFan on 13 May 2004, 2 replies)
Hi, Larry Daugherty so kindly recommended not using the MS calendar component for user input for dates. He said, and it sounds imminently logical, that version differences and OS differences affect how it works and that I'd have to adjust for each type of change (I'm ... (more)

Audit Trail (by =?Utf-8?B?Sm9zaHVh?= on 13 May 2004, 1 reply)
I have a form bounded to a query with multi tables. Because of the audit purpose, we need to generate a transaction to a audit table every time. The query bounded to the form has not direct relationship to the audit table. Please advise how can I append record to the audit table. Do I need to write a "connection" to connect this audit table? ... (more)

Action Failed Error Message (by =?Utf-8?B?TUFDT04=?= on 13 May 2004, 1 reply)
I have a command button that opens up a form. Sometimes when I click on the command button it display a message saying " Action Failed; Macro Name (Macro Name); condition: True; Action Name: OepnForm; Arguments: (frmname), datasheet, , , , Normal". My macro is there and the form is there, what causes this message to display and how can i fix this? Thank you! ... (more)

The Reverse Record (by =?Utf-8?B?SmltQm9i?= on 13 May 2004, 2 replies)
I have a database of Issues being worked. One table lists related issues. My form allows you to pull down the exisiting issues and select the related Issue. What i'm trying to do is to create a record to show the backward relationship. new Record 1 -> 2 one is related to two Would also create 2->1 Two is related to one record. ... (more)

Logging changes (by =?Utf-8?B?U0NITllERVM=?= on 13 May 2004, 1 reply)
Previously I saw a post on logging changes within a database, meaning who changed them and what was changed. I can't find it, any help? ... (more)

Getting data from table 1 to a form and then to table 2? (by =?Utf-8?B?TXIgQg==?= on 13 May 2004, 1 reply)
Howdy, I have a bunch of text boxes that are bound to fields in a table. A user can search on the ID field or just scroll through the data to find the item he wants to view. What I need to do is then have a button that when clicked, will take the data from certain fields being displayed, and add a new record to a different table. ... (more)

excel toolbar (by =?Utf-8?B?cm95?= on 13 May 2004, no replies)
Is there any way to force a customized toolbar for one specific file only. For example, when I open rep.xls, I want a customized toolbar to open with it but I want my regular to open with all the other file. In addition, is there a way to avoid any one opening rep.xls to change this? Thank you for your help on this. ... (more)

How do I get rid of the hyperlinks warning message? (by =?Utf-8?B?VGVyZXNh?= on 13 May 2004, no replies)
"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?" How do I get rid of this message? ... (more)

Access & QuickBooks Compatible? (by =?Utf-8?B?VGVyaQ==?= on 13 May 2004, 2 replies)
Does anyone know of a good program to use to link the information from Access to Quickbooks? ... (more)

Image Filters (by =?Utf-8?B?RiBEYW5pZWxz?= on 13 May 2004, 1 reply)
I have a form from which users can select their company logo which is then displayed on a subform on all forms. Dim fileName As String Dim result As Integer ... (more)

Re: How do I only accept a MONDAY date on a Form? (by =?Utf-8?B?UnVzcw==?= on 13 May 2004, no replies)
=(Date()+2-DatePart("w",(Date()))) ... (more)

Excel Toolbar (by =?Utf-8?B?Um95YQ==?= on 13 May 2004, 1 reply)
Is there any way to force a customized toolbar for one specific file only. For example, when I open rep.xls, I want a customized toolbar to open with it but I want my regular to open with all the other file. In addition, is there a way to avoid any one opening rep.xls to change this? Thank you for your help on this. ... (more)

Access as a Front End to SQL (by =?Utf-8?B?SmVmZg==?= on 13 May 2004, 2 replies)

I have a SQL view that is based on a SQL table and another SQL view that selects distinct records. SQL does not allow me to edit the columns from the first view which are based on the second views distinct records, however I can edit the portion that is based on the table. If I create an access form based on the first SQL view I cannot edit any column. Is there an easy way around this.

Thanks ... (more)

Fields in Checkboxes excluded in Analyse It with Microsoft Excel (by =?Utf-8?B?eWFubg==?= on 13 May 2004, 1 reply)
I was using the "Analyse It with Microsoft Excel" Function in Access and just realised that all fields that are in checkboxes are excluded in the XL file exported. Is there anyway to include the checkbox fields? Thanks yann ... (more)

Excess spacing within a field (by =?Utf-8?B?U0Q=?= on 13 May 2004, 1 reply)
Data that was imported from another source contains spacing within the text. For example, I imported several records and many of the fields contain text such as "This is only a test". How do I remove the spaces between "is" and "only". Neither of the Trim functions (LTRIM, RTRIM,TRIM) works for this case. Any ideas on how to remove the excess spaces in the middle of the text field? ... (more)

This is a reallt tough one! For me anyway (by =?Utf-8?B?S2F0aGVyaW5l?= on 13 May 2004, 1 reply)

I'm trying to put the access calendar control on a form which is fine but I want to be able to shade out certain days on the calendar...is there any way to do this ...I doubt it because I can't even get it to set at a default date...but this is not possible, is there some other calendar contol that I can get that shades out certain dates on the calendar so that they cannot be selected as a date? ... (more)

Seriously? (by =?Utf-8?B?Si1kb2dn?= on 13 May 2004, 2 replies)

I recently purchased a laptop and am going to need to use office XP on it. I was browsing through the Xp user agreement and it sounds like Microsoft says you cannot use the same copy of Xp for your home computer and your notebook. That can't be right is it? You are "suppose" to buy two copies of XP if you own a notebook and a home computer is that right? I don't believe it.
_jordan Johnson ... (more)

Error When Opening File (by =?Utf-8?B?S3JhbWFyRGFuSWthYnU=?= on 13 May 2004, 2 replies)
Whenever I open any database (.mdb) of any sort, it gives me this error message: This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation? This happens on ALL files. ... (more)

Can't figure out page set up in report (by =?Utf-8?B?Y29keQ==?= on 13 May 2004, 2 replies)

I created a report using the wizard. Once I selected the fields I wanted, it appeared in design view. The fields extended way beyond the amout that would fit on one page. I rearranged all my fields so that each category would fit going across the page in landscape view. When I look at my first page in print preview, it looks good but when I click to see the next page, there are several pages worth of blank space and grey lines before I hit my next page of data. I know that this is because once I moved over my fields to fit in the page, the grid was still there. For example, my data ifts within say, 10 grids but the amout of grid space showing in design view is about 21 columns. How do I delete these extra grids? I have tried right clicking but I do not get any option to delete and I have also tried to drag my mouse to move the grid in but nothing happens. Also, is there anyway to make sure that my pages don't stop and start in the middle of data? For example, I have a report that lists peoples names and their information below each name. I would prefer to not have someones name on one page and then their information half on the next page because of the page break. Thanks so much! ... (more)