[AccessD] Help Charlotte!

Charlotte Foust cfoust at infostatsystems.com
Fri Feb 20 10:22:36 CST 2004


Replace it with whatever version of the ADO Ext library for DDL and
Security you have on your machine.  As long as you have version 2.5 or
later installed, it should work.

Charlotte Foust

-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com] 
Sent: Friday, February 20, 2004 7:52 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Help Charlotte!


I kinda figured this was the problem, but to be honest, I don't know
much of anything about references. I know that given the level I am now
at, I should know this, and I am embarassed that I do not, but I've
never ran into it and I've learned most of what I know from doing, with
the help of this list. 
 
I am now doing a search on the archives on references.
 
In the meantime, I was getting the 'MISSING' on 'Microsoft ADO Ext. 2.6
for DDL and Security', if this means anything to anybody. 

 
Gotta go play and learn!
 
Take care!
 
John
>>> prodevmg at yahoo.com 2/19/2004 2:27:27 PM >>>

The database you downloaded may have some references that you don't have
on your computer. Go to any module, select tools, references and look
for one that says MISSING. Uncheck it and re-compile your db.

John Clark <John.Clark at niagaracounty.com> wrote:I downloaded your zip,
but as soon as I ran it, I got an error that comes up at the following
line

...If Left(strFrmName, 10) = "fdlgselect" Then...

the error is: 'Compile Erro: Can't find project or library. I've seen
things about this before, but I've never had any problems like this in
the past, so I do not know what to do. I'm looking now, but I figured
the list usually beats me to it....or usually, I'll find it, get on
Email and the answer is there waiting for me.


>>> cfoust at infostatsystems.com 2/19/2004 1:17:58 PM >>>

Actually, top make it easy, you can download a sample in either 97 or
2000 format from my samples here:
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Foust,Charlotte 

Charlotte Foust

-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com] 
Sent: Thursday, February 19, 2004 10:10 AM
To: Charlotte Foust
Subject: RE: [AccessD] InputBox sizing...leading
intoyetanotherquestion...using a drop-down for reports


Thanks for the offer Charlotte. I would be very interested in seeing
this! It sounds like it is exactly what I am looking for, and if it
isn't, well I guess I learn something new and maybe get more
ideas...which might be a dangerous thing!

Thanks again...I'll look forward to view this!



John W. Clark
Computer Programmer
Niagara County
Central Data Processing

>>> cfoust at infostatsystems.com 2/19/2004 12:39:17 PM >>>

What I do is create a custom property called DisplayName for each report
that should appear in a list like that. Then I populate a listbox on a
popup form with only the reports that have a value in DisplayName. 
That
way I can give the reports a user-friendly display name without
abandoning naming conventions. I believe I have a demo somewhere that
shows that and I can send if you would like. Let me know offlist.

Charlotte Foust

-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com] 
Sent: Thursday, February 19, 2004 8:55 AM
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] InputBox sizing...leading into yet
anotherquestion...using a drop-down for reports


Yeah, that's what I figured. Thanks for the help though. I figured on
doing something like the form Lambert had suggested, but I hadn't
thought to use check boxes. But this does give me another idea though.


I originally had this issue because the users quickly outgrew my reports
menu--they said they wouldn't need more that a couple and I had made
room for five despite what they said. Well they have come up with a
bunch that are very similar, but each has a different specialty--as a
bunch I am referring to them as 'Program Reports', since they each
feature a different program that the department runs. 

Since I am doing a separate pop-up, I am thinking of using a drop-down
list with the report names in it--there may be around 12-15 or so of
these reports. Is there a way of creating a table or query listing
available reports, or more specifically, but less probable, certain
types of reports--I could flag them somehow--and have them pipe into a
drop-down. Or will I need to place these in myself, which I think I will
probably have to do?

Thanks again!

John

>>> prodevmg at yahoo.com 2/19/2004 11:19:53 AM >>>

Bottom line, the Input Box IS NOT sizable. You will have to create your
own custom dialog box as suggested.

John Clark wrote:Caution--Potential
'Dumb
Question' warning!!!

I have placed an InputBox behind a command button, and it is a short
question: 

'Opt = InputBox("eport or abels", "Report Choice")'

My problem is that this box is huge compared to the needed entry, and I
would like to shorten it up, if possible. It isn't simply that it looks
dumb, but you just know user will try to type more if there is room. Is
there a way to control the size?

Thanks, John
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us 









---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 



Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us 









---------------------------------
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com 
http://databaseadvisors.com/mailman/listinfo/accessd 
Website: http://www.databaseadvisors.com 

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list