Hallo an alle,

ich muss ein Diagramm mit Access erzeugen und weiß nicht, wie. Kann mir mal
jemand einen Tipp geben?

Hallo an alle,

ich muss mir ein Diagramm mit Access erzeugen und weiß nicht wie. Kann mir
jemand mal einen Tip geben?

I am developing a MS-Access stand alone application using MS-Access 2003,
which requires chart to be displayed. I can see chart control (
'MSCHRT20.OCX') available in MS-Access. I have used it sucessfully and
displayed the chart. Now, I want to distribute this application.

My question is :

1) Is this chart control ( 'MSCHRT20.OCX') part of MS-Access 2003
installtion ?
2) I have given some users to try out the application and they are getting
message while running the application - "Missing OCX file ( 'MSCHRT20.OCX')"
!!

What is the solution to it ?

3) In VB6, I can create installation file where I can include these OCX
files. Is there similar facility available in MS-Access 2003 ?

hello all,

I am trying to find books (or even one!) that would give a good
overview of using MS SQL Server for the backend of a database
application, using MS Access as the frontend. I've found a few
things, but it all appears to be years old.

Any suggestions welcome :)

Thanks

Nic

Hi,
my query is full, but I need more columns. Is there a maximum numbers
of columns you can have? On a similar note, say I was to "cut" columns
from the design of my query, how would I then "insert" more columns?

Thanks
Kate

Alguém ai fala em Português?

Abraços

Tatiane.

Hello,

I get a download from as/400. There is a particular field call "postdate" ,
which appears as 20080101 - year, month, day how do I convert this in
my query to 01/01/2008 in access 2002?

Cheers

Hi

I have a Table that have 4 Fields : ID, Serial_No, Status, Model_No.
Contents of my Table

ID Serial_No Status Model_No
1 11 Ship AAA
2 11 Ready AAA
3 11 Repair AAA
4 22 Receive BBB
5 22 Repair BBB
6 33 Ship CCC
7 33 Ready CCC

How can I delete all the Serial_No Records that have "Ship" status?
So, in this case only the Record with Serial No "22" in ID 4 & 5 will
remain. Since SerialNo 11 & 33 have "Ship" Status, all the related
records to "22" & "33" will be deleted. Record ID 1,2,3,6,7 deleted.

Final Table :
ID Serial_No Status Model_No
4 22 Receive BBB
5 22 Repair BBB

I have an access database that has a field (type memo) that keeps very
long strings. When the value of this field is very long, my Visual
Basic 6.0 code does not return the whole value and truncates it. I
just read it using standard code like this:

storeId = rstMsg!storeId

where is defined as: Dim stMsg As ADOdb.Recordset

Everything works fine if storeid is not very big.

Does anybody know why this happens?

Thanks,

-Jalil

my database looks like
http://www.filehive.com/files/080717/access.bmp
http://www.filehive.com/files/080717/report.bmp

is it possible to create an if statement where if
WSIB+Insurance Expires PRint report 1 else if
WSIB expires=print report2 else if
Insurance Expires=print report3

but where it'd print all the reports tht meet this critieria?
would i need 3 different forms to do that? :S

and does any1 know any good books to buy that are simple to learn and can
teach stuff like this? i'm getting into access alot over the summer. Thanks