microsoft.public.access

Message Index 16 for News Archive microsoft.public.access

validation rule - default value (by =?Utf-8?B?bWFydGlhbA==?= on 20 May 2004, 4 replies)
Hi, I've a table with some date fields. I've to download data from an external source. For some records, there's no date specified, but a text string, like "NULL" or "Not available". If I set up a validation rule, all records with a non date field are rejected. What I'd like to do is to set up my table as following : accept all records, but replace the text string value by a default date. ... (more)

validation rule - default value (by =?Utf-8?B?bWFydGlhbA==?= on 20 May 2004, 4 replies)

Hi,

I've a table with some date fields. I've to download data from an external source. For some records, there's no date specified, but a text string, like "NULL" or "Not available". If I set up a validation rule, all records with a non date field are rejected.
What I'd like to do is to set up my table as following : accept all records, but replace the text string value by a default date. ... (more)

Fields vanish when Replicate selected for table! (by =?Utf-8?B?Smlt?= on 20 May 2004, no replies)
Table contains 2 memo, 1 text 128Bytes, 1 number, and 1 autonumber field. When replicate selected, only the text field following the autonumber is available, the others are no longer available. Moving fields around, I can get one of the memo fields to appear instead of the text field. Doc says 2048 for record length. Un-selecting replicate, and fields appear. Have I missed something in the docs? ... (more)

Fields vanish when Replicate selected for table! (by =?Utf-8?B?Smlt?= on 20 May 2004, no replies)

Table contains 2 memo, 1 text 128Bytes, 1 number, and 1 autonumber field. When replicate selected, only the text field following the autonumber is available, the others are no longer available. Moving fields around, I can get one of the memo fields to appear instead of the text field. Doc says 2048 for record length.
Un-selecting replicate, and fields appear.
Have I missed something in the docs? ... (more)

OPC Server (by =?Utf-8?B?TnVtYmVyMw==?= on 20 May 2004, no replies)
I'm wondering if any one has done this before. I have a software package that acts as a DDE/OPC server. I can poll data from production machines and display it Excel. What I want to do is bring this data into an Access table. I could link the Excel spreadsheet but I really don't want to. Anyone have an idea on how to make this link? ... (more)

mp3 playlist into excel (by =?Utf-8?B?TWFubmll?= on 20 May 2004, 2 replies)
hi guys i hope someone can help me with this...how can i import an mp3 playlist into excel? it's a winamp list, that i want to open in excel...any ideas? ... (more)

On Duplicate Entries (by =?Utf-8?B?dmVudXNhc2Fib3k=?= on 20 May 2004, no replies)
Hello, I am entering names into my database using a form. I am converting an old filing system into a new one, so I need to be able to check the names before I enter them as some are already logged. Suggestions for the best way to do this are much appreciated. ... (more)

A Specific Type of Access Report (by =?Utf-8?B?TGF1cmE=?= on 20 May 2004, 1 reply)
I have a reporting need to summarize the details from one table. The end user will need to enter 2 pieces of information that will be used to limit the amount of information reported. The reported information will appear on the same form the 2 pieces of filtering data are entered. The information for the report will come from 1 table. The table will have data entered from various users. The data comes from either option button groups with 3 values: yes, no, na; or yes/no check box fields. ... (more)

A Specific Type of Access Report (by =?Utf-8?B?TGF1cmE=?= on 20 May 2004, 1 reply)

I have a reporting need to summarize the details from one table. The end user will need to enter 2 pieces of information that will be used to limit the amount of information reported. The reported information will appear on the same form the 2 pieces of filtering data are entered.

The information for the report will come from 1 table. The table will have data entered from various users. The data comes from either option button groups with 3 values: yes, no, na; or yes/no check box fields. ... (more)

Linking to Outlook table (by =?Utf-8?B?a2JyYWQ=?= on 20 May 2004, 3 replies)
I am following the instructions in OL2000: How to Use Your Outlook Items with Other Office Programs (Microsoft Knowledge Base article - 196873 ) on opening an outlook item in Access. When I get to "4. In the "Files of type" list at the bottom of the Import or Link dialog box, click Outlook" I do not get a wizard just put back to the database window. Any idea why this might be? Something wrong in my Access set presumably. ... (more)

Linking to Outlook table (by =?Utf-8?B?a2JyYWQ=?= on 20 May 2004, 3 replies)

I am following the instructions in OL2000: How to Use Your Outlook Items with Other Office Programs (Microsoft Knowledge Base article - 196873 ) on opening an outlook item in Access. When I get to "4. In the "Files of type" list at the bottom of the Import or Link dialog box, click Outlook" I do not get a wizard just put back to the database window. Any idea why this might be? Something wrong in my Access set presumably. ... (more)

Subdatatasheet made up of 2 tables (by =?Utf-8?B?S2FzaWE=?= on 20 May 2004, 1 reply)
I have set up a database consisting of employees. The main table consists of employee names and the subdatasheet contains each employee's work history (temporary assignments and permanent placements). Currently, the history is on one table, but I would like to separate it so that I have a table for temporary assignments and a table for permanent placements, but still have the complete history on one subdatasheet. Is there a way to link the two tables so all the information appears under one subdatasheet? Any suggestions would be greatly appriciated. Thanks for your help! ... (more)

Subdatatasheet made up of 2 tables (by =?Utf-8?B?S2FzaWE=?= on 20 May 2004, 1 reply)

I have set up a database consisting of employees. The main table consists of employee names and the subdatasheet contains each employee's work history (temporary assignments and permanent placements). Currently, the history is on one table, but I would like to separate it so that I have a table for temporary assignments and a table for permanent placements, but still have the complete history on one subdatasheet. Is there a way to link the two tables so all the information appears under one subdatasheet? Any suggestions would be greatly appriciated.
Thanks for your help! ... (more)

Field expression , return a value from a date (by =?Utf-8?B?aW1iYWNrZA==?= on 20 May 2004, 1 reply)
I need to know how to return the diiference in months from two dates, please help ... (more)

Mouse wheel in VBA (by =?Utf-8?B?QnJpYW4=?= on 20 May 2004, 5 replies)
How can I get the mouse wheel to scroll the VBA window? I have to use the PageUp/PageDown keys or drag the vertical scroll bar. ... (more)

Filter (ADO) code - 2nd part (by =?Utf-8?B?Sm9l?= on 20 May 2004, 1 reply)
First of all, thanks to Brendan and Van for the help in my previous thread. I am successfully to filter a sub-recordset. After the filter, I want to do 2 things. (1) Debug.Print rst1.GetString (2) Me!ProductDescription = rst1.ProductDescription ... (more)

Can Access solve the following problem? (by =?Utf-8?B?TmFyd2U=?= on 20 May 2004, 1 reply)
On page 1 of a patient questionnaire, an individual fails to check a box that indicates that they are pregnant. However, on page 3, they are answering portions of the questionnaire that only those individuals who are pregnant should be responding to. What my manager needs is for the database to recognize, and direct the users attention to, these kinds of problems. Can Access do this? And, if so, where do I begin to learn how to deal with these problems? I am a c# programmer. Can I resolve these kinds of issues programmatically, or are there easier solutions? ... (more)

Can Access solve the following problem? (by =?Utf-8?B?TmFyd2U=?= on 20 May 2004, 1 reply)

On page 1 of a patient questionnaire, an individual fails to check a box that indicates that they are pregnant. However, on page 3, they are answering portions of the questionnaire that only those individuals who are pregnant should be responding to.

What my manager needs is for the database to recognize, and direct the users attention to, these kinds of problems. Can Access do this? And, if so, where do I begin to learn how to deal with these problems? I am a c# programmer. Can I resolve these kinds of issues programmatically, or are there easier solutions? ... (more)

codes with FILTER (by =?Utf-8?B?Sm9l?= on 20 May 2004, 10 replies)
I have a unbound form with 2 controls only. One control is ProductCode which is a combo box bounded to a query. Another control is the description which is a text box. When the ProductCode is selected from the pull down list, I want to retrive the description from the product master table. Here is my codes and the error says .Filter is invalid use of property. can anyone help me? TIA Dim cnn1 As New ADODB.Connection Dim rst1 As New ADODB.Recordset ... (more)

codes with FILTER (by =?Utf-8?B?Sm9l?= on 20 May 2004, 10 replies)

I have a unbound form with 2 controls only. One control is ProductCode which is a combo box bounded to a query. Another control is the description which is a text box. When the ProductCode is selected from the pull down list, I want to retrive the description from the product master table. Here is my codes and the error says .Filter is invalid use of property. can anyone help me? TIA

Dim cnn1 As New ADODB.Connection
Dim rst1 As New ADODB.Recordset ... (more)

Access closes (by =?Utf-8?B?YWNhcmxzb24=?= on 20 May 2004, 1 reply)
In a database that I've been working on something weird haapens when I try to access a certain record number. If I try to view it the whole program shuts down. I tried to delete it using a delete query but it can not find the record. What is going on? ... (more)

How to optimize Access db over WAN (by =?Utf-8?B?VGFzaGEgQg==?= on 20 May 2004, 4 replies)
I know having an Access db on the WAN is not the best option. I have people in two states that have to access this database. There are about 100 people who will have access although not more than 10 are ever on at one time. I have read about terminal services and SQL server. I am also possibly interested in replication. What would be the best option? Due to lack of funds I'm thinking replication or terminal services. I'm not quite sure how to implement them though. Can someone give me some ideas. Thanks! ... (more)

How to optimize Access db over WAN (by =?Utf-8?B?VGFzaGEgQg==?= on 20 May 2004, 4 replies)

I know having an Access db on the WAN is not the best option. I have people in two states that have to access this database. There are about 100 people who will have access although not more than 10 are ever on at one time. I have read about terminal services and SQL server. I am also possibly interested in replication. What would be the best option? Due to lack of funds I'm thinking replication or terminal services. I'm not quite sure how to implement them though. Can someone give me some ideas.

Thanks! ... (more)

Re: deploying Access application? (by =?Utf-8?B?R3JlYXRlciBEZXNpZ25z?= on 20 May 2004, no replies)
How do you know if you have the developer's edition? ... (more)

Access 2000 program will not open in Office XP or 2003 enviroment (by =?Utf-8?B?R3JlYXRlciBEZXNpZ25z?= on 20 May 2004, no replies)
We have several Access 2000 made programs at my company. Only one cannot be used by the Office XP or Office 2003 users. We double click it , but just hangs and nothing happens. Would this be a problem in forms, or what? Thanks, you guys are doing a good thing. ... (more)

adding values in a databse table (by =?Utf-8?B?TWF0dGhldw==?= on 20 May 2004, no replies)
Hello, I have recently created a web site that sends results of my poll to a database. I have set the value of each possible selection to "1". so when a user clicks a radio button and submits it puts the value of "1" in that items row and places a value of zero in each of the other item rows. What I get in my database is a long set of rows where of all the items in each row only one of them actually has a value. What I would like to do is create a data access page with a chart with total votes and number of votes for each item. So I need to know if there is a way access can add all the values in each items colum so I dont have to go through and add them all up myself. Thanks for any help or suggestions, Matthew. ... (more)

adding values in a databse table (by =?Utf-8?B?TWF0dGhldw==?= on 20 May 2004, no replies)

Hello, I have recently created a web site that sends results of my poll to a database. I have set the value of each possible selection to "1". so when a user clicks a radio button and submits it puts the value of "1" in that items row and places a value of zero in each of the other item rows. What I get in my database is a long set of rows where of all the items in each row only one of them actually has a value. What I would like to do is create a data access page with a chart with total votes and number of votes for each item. So I need to know if there is a way access can add all the values in each items colum so I dont have to go through and add them all up myself. Thanks for any help or suggestions, Matthew. ... (more)

Need help with AutoNumbering a field (NOT with Autonumber) (by BigG on 20 May 2004, 12 replies)
I need a database for recording incoming raw material (steel). What this database will need to do is allow me to enter and keep track of things like: (per item) ... (more)

Converting 2000 to earlier vesion (by =?Utf-8?B?SmltIFRpbmRlcg==?= on 20 May 2004, 1 reply)
With myrecordset => .FindFirst findcriteria End with ... (more)

Can Access 2002 solve the following problem? (by =?Utf-8?B?TmFyd2U=?= on 20 May 2004, 5 replies)
On page 1 of a patient questionnaire, an individual fails to check a box that indicates that they are pregnant. However, on page 3, they are answering portions of the questionnaire that only those individuals who are pregnant should be responding to. What my manager needs is for the database to recognize, and direct the users attention to, these kinds of problems. Can Access do this? And, if so, where do I begin to learn how to deal with these problems? I am a c# programmer. Can I resolve these kinds of issues programmatically, or are there easier solutions? ... (more)

Can Access 2002 solve the following problem? (by =?Utf-8?B?TmFyd2U=?= on 20 May 2004, 5 replies)

mail merge (by =?Utf-8?B?d2VuZHk=?= on 20 May 2004, 1 reply)
I cannot get unbound data in my table to show up in my word mail merge. The data is in the table and the fields show up in the insert field list in word, but when it is merged it is blank. Please help!! ... (more)

Are List boxes searchable? (by =?Utf-8?B?Um9zY28=?= on 20 May 2004, no replies)
Private Sub cmdFind() On Error GoTo Err_cmdFind DoCmd.RunCommand acCmdFind ... (more)

Numbers Pasting as Text into Excel from Access 2002 (by =?Utf-8?B?U0ZB?= on 20 May 2004, 1 reply)
Copying qry results into Excel values in number fields are pasted as text after row 611. Doesn't happen if use Office Link Tool to analyze qry with MS Excel. This is a recent developement, didn't happen before especially if I used the office clipboard but now it does no matter how I copy/paste. ... (more)

How to backup Runtime file (by =?Utf-8?B?TWlsZXM=?= on 20 May 2004, 1 reply)
How can a user backup a MS access runtime database (i.e. an .mde file installed with Access 2003 runtime code). If the user makes a file copy, will this copy also work under the same runtime licence/code on the same PC? Presumably this file copy won't work on another PC without MS ACCESS but will work on any PC with a compatible version of Access? ... (more)

Disabling SHIFT Bypass Key for Users, but Not Network Administrators (by Ghulam on 20 May 2004, 1 reply)
I am using an Access 2k ADP (Converted into ADE) front end and SQL 2K on the backend. Although I taught pretty much myself into these concept with the help of some publications and users group posts, some time I would like to seek some specific help from fellow members. ... (more)

need help with SQL Query.Maybe a SubQuery (by Garry on 20 May 2004, no replies)
Hi I have 3 tables in MSAccess. 1.Customers ... (more)

Header problem (by ANSWER on 20 May 2004, no replies)
Hi, I have report. In header of this report I want to input data from table. Because data in report header has to be changed occasionally and he can ... (more)

how are you (by chen duan on 20 May 2004, no replies)
nice to meet you ... (more)

docmd.sendobject alternatives (by Silvester on 20 May 2004, 1 reply)
I'm having problems with the docmd.sendobject command after upgrading from A2000. Has anyone worked out a solution that will check the user's default email ... (more)

news (by WONDERFULME888 on 20 May 2004, no replies)
news ... (more)

Word of Advice for New Users (by Nikos Yannacopoulos on 20 May 2004, 4 replies)
Dear Novice User, I'm posting this because I see postings in the newsgroups every day, from which it is evident that new users encounter problems in the development of ... (more)

Alternate address book (by John on 20 May 2004, 1 reply)
Hi Is it possible to create an address book, similar to outlook address book, but which picks up contact addresses from an ms access table? Basically I ... (more)

Windows XP Updates problem. (by Jules on 20 May 2004, 1 reply)
I am trying to do Windows Updates, they download, and appear to try and install but i keep getting the following message everytime: No Updates Where Installed, ... (more)

CurrentDb will not work (by George M on 20 May 2004, 5 replies)
I am building an application in access2000 as an adp connected to SQL server 7. In trying to open a record set in a module I can not get it to work like I have done many times before in an mdb file, should I be doing something ... (more)

Output from 2.0 to Excel (by Tommy on 20 May 2004, no replies)
When I output a report from Access 2.0 to Excel 2000 the columns come through out of order. Any suggestions for outputting the report to excel and maintaining the proper design of the report? ... (more)

Email from access (by KDS on 20 May 2004, 1 reply)
hello all, i want to send the output of a query to some people weekly using outlook. every time i send it i get the following ... (more)

What queries are using a certain table? (by AZEYE on 20 May 2004, 3 replies)
Is there a way to find what queries are using a specific table? I have a database with over 100 queries and I need to find out which ones are using a specific table. Is there anyway to do that besides going through each query? ... (more)

Using my own icons on access (by GarryE on 20 May 2004, 1 reply)
Hello, I want to package an access program and not show any access icons. None.I also want to get the word access out of any message boxes that appear. Thank-you. ... (more)

Concatenate string limit (by Curt on 20 May 2004, 3 replies)
I created a form which allows the user to select the criteria/group of people they wish to send an email to. After the selection a macro is used to concatenate the emails in the To section of Outlook. This all works fine, ... (more)

Find (by Tim H on 20 May 2004, 1 reply)
I have an acess database and the find function does not work, I can email this same database to a friend and it works there, any ideas? ... (more)

Meter Reading (by Bob Martin on 20 May 2004, 2 replies)
I need to prepare monthly usage reports for 200+ turnouts off our canal. Each turnout has a meter. Each meter is read every week plus on the last day of the month. The monthly report needs to show the beginning of month meter ... (more)

FAX from Access (by Sylvia B on 20 May 2004, 1 reply)
I have an application in Access 2003. I have reports that I would like to FAX directly from Access, with printing them. Is this possible? ... (more)

Help needed - Just starting VBA (by Rob on 20 May 2004, 3 replies)
I am just starting to get involved the VBA side of Access. Does anyone know of any good online course. I am looking for something that will start with the basics ... (more)

Access books (by Cary Shultz on 20 May 2004, 2 replies)
Good morning! Need some suggestions on any books for Access 2000 and Access 2002. I am going into a Support Postion and need ... (more)

Multiple Users (by Amy on 20 May 2004, no replies)
Let me start at the beginning and try this again becuase I am still extremely confused. I had a table and a form to enter data on. I told it to split the table and I got the original table with an arrow in front of it. ... (more)

Training/Tutorials (by Cheryl on 20 May 2004, 5 replies)
I am just starting to use access and need some help (baby steps). Can anyone suggest training, reference, or tutorials that start with the basics. Thanks, ... (more)

Multiple Users (by Amy on 20 May 2004, 1 reply)
Let me start at the beginning and try this again becuase I am still extremely confused. I had a table and a form to enter data on. I told it to split the table and I got the original table with an arrow in front of it. ... (more)

Development process (by John E on 20 May 2004, 1 reply)
I am preparing to develop an appllication. I am looking for a format to track and record the changes, versions, etc. that is made during this development. Can you recommend a form, process or method used to track these ... (more)

Opening databases (by Susie on 20 May 2004, 3 replies)
We have a database that will not open with a dialog box stating "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The odd part ... (more)

PLEASE HELP ME!! (by trese on 20 May 2004, 2 replies)
Question about multiple check boxes in a Form or Report. I am having a major issue with trying to create multiple check boxes in a form, table, or report. ... (more)

Default Pictures Folder (by Troy B on 20 May 2004, 4 replies)
I have an application ready for deployment. I have photos which is in the Current Path directory. I split the database and I want the photos in the Database directory so when I send out updates to the front end the Tables and ... (more)

Reply (by Susie on 20 May 2004, 1 reply)
Yes....we did a compact and repair ... (more)

access 2002 XP (by Antz on 20 May 2004, 1 reply)
getting this error 7748 reserved error ... (more)

Calendar report (by Michelle on 20 May 2004, 1 reply)
Does anyone know how I can go about generating a report that looks like a calendar? My users have asked for a report of employee absence that looks like a calendar to replace manual input on their paper calendars. The ... (more)

backend compacting (by Russ on 20 May 2004, 1 reply)
I've got my db split into front and backends. When the option of compressing the database upon closing is selected does the backend get compressed or does the front end get compressed? The front end normally gets no changes so I think compression will not help, but the ... (more)

have two color on bar graph. (by hin on 20 May 2004, 1 reply)
Hi, Employee work 44 hours in this week. Of that hours, 4 hours is overtime. ... (more)

Form Hangs up only on first open on Network (by Ed Finley on 20 May 2004, 5 replies)
My front end app startup opens a form that connects to a table in the backend. On our company network, the first time I open the app, the form hangs up (I think it's in the on open event where it's hanging up). I close the app and re-open it and all works well. If I put the back end on the ... (more)

Concatenating two rows (by Clyde Thorne on 20 May 2004, 2 replies)
I download a database using ODBC. Problem is if the information (data) is too long, it forms into another row, finishing out that data. (This is coming from the original database) Using the Query in Access 2002, design mode, is there a way to concatenate two rows that have the same column ... (more)

Prob when I use 'Analyse' (by KRISH on 21 May 2004, 1 reply)
Hi! everybody, When I use 'analyse' to my database and Item not found in this collection. ... (more)