microsoft.public.access

Message Index 24 for Usenet Archive microsoft.public.access
adCmdTableDirect (by George Hester on 28 May 2004, no replies)
Why doesn't the first example here

http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;248255&Product=3D=
odb ... (more)
User Permission Problem (by Jim Walker on 28 May 2004, 9 replies)
I have MS Access 2000 running on a laptop with Win XP and I am having
trouble getting users to have access to some databases. I have two
databases that seemed to need repair so I used the repair utility and it
worked, but I now find that the Administrator can access the databases but ... (more)
textbox with scrollbar and not focus (by Richard Kurzban on 28 May 2004, 1 reply)
Is there a way to have the scrollbar in a text box always be displayed even
if the textbox does not have focus? Also is there away not to have reverse
video when the text box first gets focus? ... (more)
Getting column names of a table in C# using OleDbConnection (by Joe on 28 May 2004, 1 reply)
Hi All,

I am new to using the Access DB and I need some help if someone
is able to give it to me. What I want to do is get the names of ... (more)
Re: Has anyone created a Minimum Basline Standards document for MS Access database applications? (by Tony Toews on 28 May 2004, no replies)
What is a Minimum Baseline Standards document?

Minimum CPU Mhz, RAM, HD capacity? ... (more)
password related question (by SomSallyX on 28 May 2004, 1 reply)
Hi

I'm trying to write a simple viewer to display the tables and records in the
MS Access database. ... (more)
Help!-Match problem (by Chengfu on 28 May 2004, no replies)
Hi, group.

I need your help. ... (more)
Close debugging window (by Richard on 28 May 2004, no replies)
Hi

What is the code to close the debugging window? I would like to close the
window when I open the database. ... (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 2 ... (more)
Restricting entries in a ComboBox (by Duncan Edment on 28 May 2004, 19 replies)
ControlSource = tblTimeSheet.fldProjectID
RowSource = SELECT tblProjects.fldProjectDescription, tblProjects.fldProjectID
FROM tblProjects
WHERE (((tblProjects.fldValidUntilDate)>Date())); ... (more)
webcam help (by katie on 29 May 2004, 1 reply)
Can anyone tell me how to fix my webcam. I downloaded the drivers that I
required for it as I was having problems with it not starting ,but now when
I start it up everything on my desktop comes up in safe mode.
it works to a certain degree although the pictures are all negative. ... (more)
Re: sql view (by Albert D. Kallal on 29 May 2004, no replies)
if you base the form on a sql statement, or query..then YES, you can most
certainly view/edit the sql used for the form.

While looking at the form in design view..look at the data tab in the ... (more)
Can SELECT be used on recordset? (by =?Utf-8?B?S2Vu?= on 29 May 2004, 5 replies)
Hi, I am looking for help. Can the SELECT statement be used on ADO recordset?
For example : SELECT * from <table>; Can <table> be ADO.record instead of a table name? ... (more)
How to: automatically generate details in a form (by shoa on 29 May 2004, 1 reply)
Hello all

I have a table in an Access database with some records in it. Now I have to
create a Form for that table (the form show the details of a record or to ... (more)
pocket access (by ZGraves on 29 May 2004, 1 reply)
How do you convert an access database to pocket accesss,
like word to pocket word and excel to pocket excel ... (more)
files not avaliable offline (by ke4tex on 29 May 2004, no replies)
We are trying to put all of our user documents on a file
server.
We want to be able to make the files avaliable offline
for laptop users. ... (more)
output report to HTML without getting multiple files (by Jennifer on 29 May 2004, 3 replies)
What do I need to set in my report to just get one page
rather than multiple pages (to output to HTML)? I cannot
find any way to set page length to something other than a
regular form and it paginates the report on HTML, giving ... (more)
How to check the result of a SELECT query (by =?Utf-8?B?SmFjbHlu?= on 29 May 2004, 6 replies)
I have a SELECT query and use .EXECUTE to execute. How can I check if any record has been selected by this query? Thanks. ... (more)
Control table (by =?Utf-8?B?bWFieW4=?= on 29 May 2004, 2 replies)
Since my question may have become lost, let me ask again. I apologize if I've double dipped. I have a database (based on the Contact Managment Wizard) that I entered data into through the table rather than the form. The table that the information is in is "contacts". I had lots of data to input from a different source which was cut and pated in. Now, I need to just input normally through the form but my data doesn't show up. It is like it is not linked. Can someone direct me in how to check this? Thank you.

mabyn ... (more)
I need a shortcut--PLEASE HELP!! (by =?Utf-8?B?S2VsbHk=?= on 29 May 2004, 2 replies)
Is there a way to add an increase of $2.50 to every amount in an Access database table all at once instead of changing every amount individually? I'm trying to update A FedEx shipping rate table. Any help would be greatly appreciated. ... (more)
DLOOKUP() function help!!!!! (by =?Utf-8?B?Y2xpY2tvbw==?= on 29 May 2004, 10 replies)
Hi there,

I basically need to put my query result (single number) in a textbox and eventually in a report. However, Expression Builder just can't copy the query result neither in my textbox on the form nor my report. ... (more)
hola (by FELIX HERRAEZ DIAGO on 29 May 2004, no replies)
hola ... (more)
Blank lines in report (by =?Utf-8?B?R29yZG9u?= on 29 May 2004, 1 reply)
I have a question I hope you can answer. I have produced a invoice report which incorporated the customers names and addresses. However some of the data in the field on the table are emply and this of course is coming out as a blank line in my report

The fields I have at present read like this:- ... (more)
Attendance (by =?Utf-8?B?QWFyb24=?= on 29 May 2004, 3 replies)
tbl_Students
_______________________
Student_ID(Primary Key)
Name ... (more)
Access 2003 (by Neil Ginsberg on 29 May 2004, no replies)
I have a client who is using Access 2002/2000 (the database itself is
written in 2000), and is considering migrating to Access 2003. Any
recommendations on whether Access 2003 is worth the migrate, or should he
stick with 2002? ... (more)
Combox in criterium in query? (by Henro on 29 May 2004, 1 reply)
I have a query with a field called [Engineername] based on the table
[RegHours]

I have as a criterium on the field [EngineerName]: [Which name?] ... (more)
scanner (by sheilaowen on 29 May 2004, 1 reply)
How do I get my scanner to work? ... (more)
Re: sql view (by Van T. Dinh on 29 May 2004, 1 reply)
Do you mean the SQL that creates the Table struture like in SQL Server?

This is not available in Access. The SQL View is only available for Queries
in Access. ... (more)
Help help please (by MyndPhlyp on 29 May 2004, no replies)
More specifically, WinHelp API help.

Can you point me to a good (read: thorough) tutorial on how to put together
some Access 2000 VBA to fire up WinHelp given the HelpContext and HelpFile ... (more)
HELP (by papycool on 29 May 2004, no replies)
Je veux héberger mon site sur le serveur de Microsoft. comment le faire? quel est le dossier hôte ? comment et ou s'inscrire et le
référencer? et ou mettre les balises META? Cordialement ... (more)
111 (by lyljsz on 29 May 2004, no replies)
00000 ... (more)
debut (by papycool on 29 May 2004, no replies)
Je viens de créer un tout petit site . Ne rigolez pas!!!. je voudrais savoir comment le transférer sur le serveur de Microsoft, ou
s'inscrire, comment le référer et comment incorporer les balises META. soyez explicite, je ne comprends pas toujours rapidement.
Cordialement, Papycool ... (more)
news (by zg on 29 May 2004, no replies)
123 ... (more)
DLookup (by Chris on 30 May 2004, 3 replies)
Can it be used multiple criteria for the DLookup function in the validation
rule for a control on a form?(Ex:For every control except the first one,
the values for the precedent controls from the form are equal with the
fields having the same name in a query) ... (more)
Problème de carte son. (by Inès El Bahja on 30 May 2004, no replies)
J'ai pas de carte son ou elle n'est pas sélectionnée. Comment puis-je régler
ce problème ? merci ... (more)
Dlookup Returns Error (by =?Utf-8?B?U2FtYWE=?= on 30 May 2004, 1 reply)
I need help in doing the below.
I have a table called Item where i have Item Field and a Code Field. i need to create a form where a combo box lists the Item and when any record is selected the code is reflected ina code text box in the form. can any one help me with that? ... (more)
combo box need help (by shoa on 30 May 2004, 5 replies)
Hello all

I created a simple table of Customers with three fieds: Customer ID (primary
key), name and address. I have some records in that table. ... (more)
Trouble with Form, please help !!!! (by shoa on 30 May 2004, no replies)
Hello

I have two tables: one is "Sale Table" with Invoice No (primary key), Date,
Customer ID. This table is empty. ... (more)
Access Wizard (by Kary on 30 May 2004, 2 replies)
For some reason I'm not able to use any wizards in access.
Does anyone know how I can fix the problem?

Thanks ... (more)
Using a macro to open a pdf document (by Dazza on 30 May 2004, 1 reply)
Hi all,

Can someone show me a method whereby a control button on
a form will open up a specific pdf document? I have tried ... (more)
Filter by selection (by Antonio on 30 May 2004, 1 reply)
I have a form that displays several records in Datasheet
form. On the form header I would like to place to
buttons. The first would "Filter By Selection" and the
second would "Remove Filter". I know this can be done by ... (more)
Text boxes on Help Menus do not pop up (by David on 30 May 2004, 1 reply)
Text from help has highlighted words or expressions that
once clicked on a text box with a brief description of
the item shows on scrren. ... (more)
Size of the database (by Alex on 30 May 2004, 2 replies)
What is the size limit of the Access 2002 database?
If I need to convert to an SQL Server type, do I need to
purchase additonal software or just use access 2002.
Please help....I have no clue! ... (more)
Calculate the total number of days remaing (by Steve R on 30 May 2004, no replies)
I have set up a personnel database and I want to record
for each employee their 1) holiday entitlement for the
year 2) the holiday year period 3) the dates the holidays
were taken. ... (more)
importing dos-hebrew files into access (by Saul on 30 May 2004, 1 reply)
Hello,

I have text file (DOS) with hebrew characters on it.
When I am importing the file into access db, the characters "(" are swapped ... (more)
Automation Acess to Word (by Bob W on 30 May 2004, 9 replies)
I am using Access 2000 9.0.6926-SP3 and Word2000 9.0.6926 SP3 with Reference
to Microsoft Word 10.0 Object library running in Windows XP
D:\AC_Probation\Test.doc exists.and opens under word ... (more)
Query question!!! HELP REQUIRED!!! (by =?Utf-8?B?U2NhcnR5?= on 30 May 2004, 4 replies)
Hi,

I've a li'l problem and I was hoping somebody could help me out here. ... (more)
DLOOKUP error AGAIN!!! (by =?Utf-8?B?U2NhcnR5?= on 30 May 2004, 2 replies)
Hi there,

I've to thank people here in this discussion group for helping me out. However, now I've run into another problem and I would really appreciate if somebody coule help me out. ... (more)
subform with ADO recordsets (or Query) (by =?Utf-8?B?SmVmZg==?= on 30 May 2004, 10 replies)
Can anyone help me with this, please !
I have a subform which is unbound to any query. In my code, I have a query called qry1. I would like to assign this qry1 to the Record Source of the subform. This qry1 is based on other control values on the main form. I have tried this for hours but still do not get it right. Thanks. ... (more)
Switching to a multi-user scenario (by =?Utf-8?B?ZG9nbWVsaXNzYQ==?= on 30 May 2004, 2 replies)
The database I am managing (I didn't create it) is currently running as a single-user scenario. The whole program, data & all tables are kept on the server, but it's not split. We have 12 computers (users) that access this database, and usually they are all in it at once. What we want to do is break the users into groups and put passwords on the "group" and give them access to different information in the database.

I know that I need to split the database in order to do this, but what I'm looking for is a general idea on how much work it is to do what we're trying to do, as I am writing a report to indicate if this is a plausible option in our organization and how long it might take to do it (I'm not doing it for free!).
Does anyone have any thoughts on this? I'm not sure if what I want to do is possible, or easy, or if it would be easier to start over and re-build the database completely. ... (more)
Combo Box Value (by =?Utf-8?B?TWF0dA==?= on 30 May 2004, 3 replies)
Hi,

I am working on a searchable database using a form as my interface. I want to have a combo box that contains the names of the queries that I want, not the values that are inside 1 particular query. I do not see a feature that allows me to do that with the wizard. I thought of typing the names of the queries into the combo box, but then how would I link those names to the names of the actual queries. Let me know if you can help, thank you very much. ... (more)
Running Sum (by =?Utf-8?B?TGl6YQ==?= on 30 May 2004, 11 replies)
Hi everyone, there is Running Sum control in Report. Does anyone know is there a the same for form? Thanks ... (more)
wordcount (by =?Utf-8?B?c3RlcGg=?= on 30 May 2004, 1 reply)
Can anyone tell me how to printout the wordcount on my assignment ... (more)
Carnegie23 (by =?Utf-8?B?RmlsdGVyIGJ5IHNlbGVjdGlvbg==?= on 30 May 2004, 2 replies)
I am an Access novice and am having trouble creating a specific filter. In form view, how can I select a specific building in one combo box and have the next combo box , "aparments", show only those apartments in the selected building? ... (more)
Recombine Split Database (by Sam Stark on 30 May 2004, 4 replies)
What's the easiest way to recombine a previously split database? I want to
test speed on the network split and combined. ... (more)
HELP!!! Validation rule (by Chris on 30 May 2004, 3 replies)
I have to introduce in a table some data, using a form with contrtols: combo
boxes and text boxes. The fields need to follow some VALIDATION RULES, and
to display the VALIDATION TEXT as the error message.
The validation rules must to fields from a query, because the that table is ... (more)
Time difference (by John on 30 May 2004, 2 replies)
Hi

I am trying to find difference between two time values in hours. I have
tried the following? ... (more)
Good books on Access (by Docknet on 30 May 2004, 3 replies)
I am self myself access. I picked up Microsoft "Step by Step" for Access
2003, it was a start but I need the next step up. Can I get a
recommendation on a few good manuals. ... (more)
Type Conversion Failure (by Aaron on 30 May 2004, 8 replies)
I'm trying to import data from an Excel file to an Access table. When I
try to do this, I'm told that all data was not successfully imported.
Upon viewing the error log, I'm told that that there was an error for
many of the records due to a "Type Conversion Failure" for one of the ... (more)
Numbers into words (by Ana on 30 May 2004, 1 reply)
Hello, everybody

I need to convert a number into the same number written in words in an
Access. ... (more)