microsoft.public.access

Message Index 20 for News Archive microsoft.public.access
Using a Query to enter data as well (by Craig on 25 May 2004, 1 reply)
I am trying to input data into one data table that is
linked to another table in another database. I want the
data I enter to show up in their table. Then they can
search for the data by using a dialouge box ( a select ... (more)
DOS command line execution (by lavanya on 25 May 2004, 3 replies)
I use ACCESS 2000.
I have a form that does some processing and then has to
run a command line utility based on form input, wait for
it to finish and then continue. What is the best way to ... (more)
file error (by trvlmuse on 25 May 2004, no replies)
i have been working on an access file and have saved it.
now when i try to open the file i get an error
message "unrecognized database format 'u:file name.mdb'
does anybody know what might have happened and how to ... (more)
Access 97 Conversion to 2002 (by Burt Arkin on 25 May 2004, no replies)
The 97 version of my database works perfectly, but when
converted to 2000 or 2002, after using a dropdown box
to "goto" a different record, I get the message "Microsoft
Access has encountered a problem and needs to close. We ... (more)
OLE error (by Chris K on 25 May 2004, no replies)
When we try to link a jpg into a data base using insert,
object, creat from file then navigate to jpg and click ok
we receive the following message... "The connection with
the ole server was lost, or the ole server encountered an ... (more)
Database design and normalization (by Wade on 25 May 2004, 1 reply)
Greetings,

I have a database that has a students information table
and a test information table. New tests are constantly ... (more)
Parameter Query (by Reggie on 25 May 2004, 1 reply)
I am trying to buid a parameter query, that will look for
the same value in multiple fields with one prompt, i have
been unable to figure it out..if it's possible, could
someone help me out ... (more)
Comp Survey Data Table (by Allen on 25 May 2004, no replies)
I am using access to evaluate compensation. The comp data
comes regionalized and I use 3 data regions from a list of
about 10 different regions. The problem I am having is
when a position doesn't have all 3 data regions I then ... (more)
Switchboard again (by Dazza on 25 May 2004, 2 replies)
Thanks Rosco for your assistance.

I have a switchboard form that has two pages; page 1
(default) and page 2. ... (more)
Access 2000 Barcode support (by Pete on 25 May 2004, 2 replies)
I am trying to develop a database for estimating repair
work. I want to use Barcodes to select which Tables to
gather information from. I can't find the word "barcode"
anywhere in the Access 2000 Help. Does anyone know if ... (more)
Access (by Joe on 25 May 2004, 1 reply)
What is the maximum column range for Access? ... (more)
disk or network error (by Andrea on 25 May 2004, 1 reply)
I have a user of a database I created that gets a "disk
or network error" AFTER he logs on. He has been using
the database fine until a couple days ago. He says he
hasn't made any changes on his computer. He has Windows ... (more)
data access pages and asp.net (by Mike on 25 May 2004, no replies)
Is there some way of using a built data access page in
side of and aspx page. And is it possible to get to the
data access page code? ... (more)
Access 97 Will Not Close (by WasAGuru on 25 May 2004, 4 replies)
I know about KB articles Q164455 and Q190074 - I am using
an If..Then statement that checks the return value of a
function. There are no subforms. All DAO datasets are
guaranteed closed and all variables used are double- ... (more)
Export data to Text file (by Adam on 25 May 2004, 1 reply)
Hi,

I want to export data from a query or table to a text file
by using a command button on a form. ... (more)
Record display (by Dazza on 25 May 2004, 1 reply)
Hi,

What property(ies) do I need to change on a form so that a
blank record (that can be used for inputting new data) is ... (more)
Customised Help File (by Gordon on 25 May 2004, 1 reply)
I would like to create a customised help file. MS Help
gives me the following info.

Create a Help file. ... (more)
'no current record' on delete (by Dan on 25 May 2004, 1 reply)
I recently ran a few Microsoft updates because my
database was a little unstable, and now I get an error
message 'no current record' whenever I delete a record
from every form. ... (more)
Remove Saturdays from list of dates (by Adam on 25 May 2004, 1 reply)
Hi,

I use a query to give me a list of records that includes
dates (long date format), such as Friday, 31 October 2003. ... (more)
If statement (by Antonio on 25 May 2004, 2 replies)
I have a form that displays in datasheet format. It
contains several fields, two of which are
called "SenderID" and "DateSent". I would like to change
the back color of both fields depending on what ... (more)
* DATE IMPORT FORMAT TO ACCESS 97 * (by =?Utf-8?B?Q2hyaXM=?= on 25 May 2004, 2 replies)
Hello can you help?

I am trying to import a Touchpaper (Helpdesk) date table into Access 97.
The sort of format the dates are in are is as follows: 131205913 ... (more)
Create Date (by =?Utf-8?B?TGF1cmE=?= on 25 May 2004, 6 replies)
How do I add a Create Date/Time field to a table that will recored the date/time a record is created? This has to be an easy one. ... (more)
Error number 3260 giving fits...Help please... (by =?Utf-8?B?Q2hyaXMgRC4=?= on 25 May 2004, 2 replies)
To all Access Gurus,

I have tried to look in all other places for an answer to a problem that I as well as other database programmers are having with Access 97. I have a database that three people are using at the same time. Every once in a while when someone is updating or adding a record, they get an "Error number 3260: Couldn't update; Currently locked by user 'Admin' on machine 'XXXX-XXXXX'" The user that gets the error sometimes gets kicked out and loses the changes they made. This of course makes the user very upset (rightfully so). ... (more)
Help needed (by =?Utf-8?B?dmVudXNhc2Fib3k=?= on 25 May 2004, 1 reply)
Hello,

I am developing a database for a temp agency. This is a business which collects employees and markets them to other businesses. They have one section for employee files (where most of the 5000+ records are stored) and another section for the employees that are actually in use. ... (more)
Mass update of Pass-Through Query ODBC settings? (by zoranlee on 25 May 2004, 1 reply)
I'm more of a "server side" guy but I have to deal with an Access
front end on a client site now.

I wanted to move the whole thing to my laptop as it's a small DB (both ... (more)
# of lines (by =?Utf-8?B?U0tC?= on 25 May 2004, 2 replies)
How many records will Access support ? ... (more)
Subform Wizard Error message (by Techsupport on 25 May 2004, no replies)
Hello, everybody,

Application-defined or Object-defined Error"...does anyone know what it's
going on? I am afraid to tell you that I have 844 forms (main and ... (more)
help with error message (by David on 25 May 2004, no replies)
I have this simple piece of code that works just fine, but when it is
Run-time error '2495':

The action or method requires a Table Name argument ... (more)
report containg fields with 256 characters (by geepeetee on 25 May 2004, 1 reply)
Hi

I have created a database for a course i am doing. It is a log of computer
problems. I have created a report to show faults and solutions but each ... (more)
Tab on Form Clears Data from Combo Box (by =?Utf-8?B?TWljaGFlbCBSeWxl?= on 25 May 2004, 2 replies)
I have a form with a text box on the left, a combo box on the right, and a list box below. When I tab out of the text box into the combo box, or out of the list box into the combo box, the data is cleared, i.e., removed, from the combo box. I've tried every combination of the the tab stop/tab index properties I can think of but I still get the same results.

Does anyone understand what is happening here? Thanks. ... (more)
Bold word high light (by =?Utf-8?B?Um9nZXIgSG95dA==?= on 25 May 2004, 1 reply)
Whenever I want to bold letter a word or sentence or colorize it the system will bold the entire data sheet. How do I get it to bold or add color to just what I have high lighted. ... (more)
Access 2003 Developer Which CD.....IS MSDN Contain (by Mohammad Kaludi on 25 May 2004, no replies)
Hello
My recent post to ask where to find Access Developer extension

I am asking I have April 2003 Verison of MSDN Is That Universal MSDN Called ... (more)
multiple field index (by =?Utf-8?B?dmVudXNhc2Fib3k=?= on 25 May 2004, 2 replies)
How do i set up a multiple field index? ... (more)
several group to show in subform (by =?Utf-8?B?bWFjZQ==?= on 25 May 2004, no replies)
I have a couple of tables one with contacts and a link to a table with grouptype, my contacts belongs to 6 different grouptypes. I have one form where I can select grouptype to send e-mail to and if I choose a group they nicely appear in the subform.

Problem is I want to select append /add maybe 1-3 more groups to that subform to send email to. Cant figure out how to do do this. ... (more)
Spell Check Problem (by =?Utf-8?B?RGFycmVuIEFiZWxz?= on 25 May 2004, no replies)
Hello

I am developing a MS Access database that allows users to track issues. I have a form where the user can add notes to the issue. On this form there is a SPELL CHECK button that runs this code: DoCmd.RunCommand acCmdSpelling. On this form there is also a SAVE button and a CANCEL button. The problem is, if the user types a note into the memo field and then hits the SPELL CHECK button and then hits cancel, the record (or note in my case) is added. After looking at this, I have found that the spell check logic is doing an auto save. Is there a way to just run the spell check without having it insert my record to the table? ... (more)
Is there a way to duplicate a field in a form? (by =?Utf-8?B?TG93ZW5uYQ==?= on 25 May 2004, 3 replies)
Could anyone please let me know if there is a way to create a button (?) to duplicate data? To explain: I'm about to enter large amounts of data for horse show entries and some horses enter more than one class. It gets complicated if I try and explain what I'm doing but if anyone has a vague idea what I'm trying to do - please help!

From,
A very confused Cornish woman! ... (more)
Exporting to Excel (by =?Utf-8?B?RnJlZHJpY2tB?= on 25 May 2004, 1 reply)
Hi
I am using "outputTo" in Access to Export a query to Excel - One of the Fields being exported is a MEMO field (some are over 255 chr long) when the query is exported the MEMO field is truncated to a max of 255 chr and a conversion error is generated in Access - "Field Truncation"

What am I doing wrong - can anyone help ... (more)
Option Button (by =?Utf-8?B?SmVubnk=?= on 25 May 2004, 4 replies)
I have 2 option buttons. How can I make the first button default on when the form is loaded? Many thanks. ... (more)
Forms and Tables (by =?Utf-8?B?U3Vuc2hpbmU=?= on 25 May 2004, 2 replies)
Information in a form is not displaying in a table ... (more)
Progress window bigger? (by Funktofugue on 25 May 2004, no replies)
Any chance of making the Progress window bigger. I look at it to see what I
want to keep and what is junkmail. Thank you ... (more)
REVISED Progress (by Funktofugue on 25 May 2004, 1 reply)
Any chance of making the Progress window bigger. I look at it when incoming
mail arrives to see what I want to keep and what is junkmail. Seems to be
the fastest way to sort mail for me. Any help would be appreciated. Thank
you ... (more)
Converting from Access 97 to Access 2002 (by =?Utf-8?B?VGVkIFNpZGVoYW1lcg==?= on 25 May 2004, 1 reply)
Missing or broken VBE reference to the file 'Funclib.mda'

I'm not sure if the two problems are related but I find it strange the user can enter data into the files, yet the conversion failed. In addition, the printing problem has me at my wits end trying to figure out what has happened. I'm new to Access and have been "volunteered" to figure this out. Thanks in advance.... ... (more)
Date conversion (by =?Utf-8?B?Q2hyaXM=?= on 25 May 2004, 1 reply)
Hello can you help?

I have imported some tables from Touchpaper (Helpdesk) database. All works except the date field e.g. the data comes in a format like: 131205913 or 131268892 ... (more)
how to set focus on a item in a list box? (by =?Utf-8?B?YWxla20=?= on 25 May 2004, 2 replies)
Hi,
how can I set focus on list box, but the focus should be set on, for examle, first item in list box.

Thanx ... (more)
option group data type (by =?Utf-8?B?RmxvcmE=?= on 25 May 2004, 2 replies)
Does anybody know how to set the field data type if the value will use an option group to display on a form. The value will be "Yes, No, Undetermined". I checked that in the design view, there is only an "Yes/No" for choosing in Data Type column.

Thanks! ... (more)
Hyperlink issues (by =?Utf-8?B?SmltIE1hYw==?= on 25 May 2004, no replies)
I have a make table query using a 4 digit stock symbol (AXCS) to make a series of addresses (about 8,000). It works great, only problem is that the hyperlink doesnt work. Then I change the hyperlink's table format to hyperlink and it still doesnt work. It looks like one but isnt and if I go to edit one individually i can see that my url is in the name not the hyperlink field.

Please help! ... (more)
Forever confusing software Licensing problem :( (by Kwan on 25 May 2004, 5 replies)
Hi All,

I am developing a tool which require to query and store some
information into a database. It will only be used exclusively by my ... (more)
Registrar ascensos de funcionarios (by Claudio Bogado Pompa on 25 May 2004, no replies)
En un departamento de empresa los funcionarios cobran por horas trabajadas.
Los funcionarios pueden tener dos cagorías (Oficial y Ayudante).
Hasta ahora tengo una tabla donde nombres, apellidos, si es oficial y la
fecha que ascendió a oficial; y otra tabla donde registro cuantas horas ... (more)
Conditional page breaks (by John on 25 May 2004, 1 reply)
Hi

Is it possible to give conditional page breaks in access reports depending
on a field value? ... (more)
attacments (by rickodonna on 25 May 2004, 1 reply)
Howdy, how do i access attachments that outlook express has regarded as
potentially unsafe. Have been sent alot of attachments but are removed
before seeing them. ... (more)
New need help (by firedog on 25 May 2004, 1 reply)
I have a table, it is linked to an excel sheet, but when I enter
information in the table it doesn't copy that info into the
spreadsheet. Why, and what can I do? Please give an easy to understand
answer, I don't know this well. ... (more)
SQL queries in Access 2000 (by luis on 25 May 2004, no replies)
Hello
I would like to know how can i do SQL queries in Access2000, i cant find the
option. ... (more)
problem with passwrd protect DB and using ASP (by jaberwocky on 25 May 2004, 4 replies)
Help! :)
I password protected an ACCESS DB. However now when i try to access any
of my .asp pages that link to the database i am getting the following
error. ... (more)
slow refresh of form when using large tab control (by kevinrea on 25 May 2004, 1 reply)
hi guys,

i have a form with a large tab control on it., it has about 60 tabs.
well, when i change which tabs show with code, it takes several seconds ... (more)
Print Design View for SQL Database Table (by Mike on 25 May 2004, 1 reply)
Hi All;

Is it possible to print the Design View of a SQL table?
ie. Field Name, Data type, Field Size, Indexed, etc. ... (more)
Unable to Publish with MS Word (by Vince on 25 May 2004, 2 replies)
New to the group.

I am unable to publish a Report within ACCESS for Windows vers 2.0
with MS Word97 by use of the toolbar button ... (more)
Form Creation (by RC- on 25 May 2004, 3 replies)
Hi all,
I am extremely new to Access and I would like to create a form that will
allow a user to click on a dropdown (combo box) select a location and then
the other three fields will be automatically populated. The other three ... (more)
Filter Error (by Evan McCutchen on 25 May 2004, 2 replies)
Hello,

To allow my users to search for companies in our system, i have written a
query that filters our form "companies" for critera specified on the form ... (more)
SPam from this list (by email administrator on 25 May 2004, 2 replies)
Will I get spam if I use my legitimate email address to post to this news
group?

Thanx! ... (more)
Help with file browser (by Dr. Selima on 25 May 2004, no 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)