Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 99
Search took 0.33 seconds.
Search: Posts Made By: legendv
Forum: Modules & VBA 02-23-2003, 07:31 PM
Replies: 5
Views: 3,158
Posted By legendv
I didn't, but I do now... thanks!

I didn't, but I do now... thanks!
Forum: Modules & VBA 02-19-2003, 05:55 AM
Replies: 5
Views: 3,158
Posted By legendv
Thanks for your input George. "Use Special...

Thanks for your input George.
"Use Special Access Keys" is unchecked....

What I found:
Open Microsoft Access
Press Alt-F11 - (this opens VBEditor)
Go back to access shell, press file-Open,...
Forum: Modules & VBA 02-18-2003, 07:10 PM
Replies: 14
Views: 14,874
Posted By legendv
Thanks all!

Thanks all!
Forum: Modules & VBA 02-18-2003, 07:07 PM
Replies: 5
Views: 3,158
Posted By legendv
prevent Alt-F11 entry

does anyone know how to prevent users from entering a mdb by hitting alt + f11
Forum: General 02-17-2003, 01:04 PM
Replies: 1
Views: 825
Posted By legendv
Question how to remove toolbar?

How do you remove the toolbar?

It doesn't show in my db's but when I put it on another pc, it comes up with the toolbar showing.
I tried to set the toolbar control to =1
like you do to remove...
Forum: Modules & VBA 02-17-2003, 12:04 PM
Replies: 14
Views: 14,874
Posted By legendv
I'm not worried about improper dates. when an...

I'm not worried about improper dates.
when an improper date is entered a microsoft msg occurs, I want to suppress the microsoft msg.
Forum: Modules & VBA 02-17-2003, 11:47 AM
Replies: 2
Views: 661
Posted By legendv
invalid URL - do you have a copy of that sample...

invalid URL - do you have a copy of that sample db you could email me?
Forum: Modules & VBA 02-13-2003, 03:20 PM
Replies: 2
Views: 661
Posted By legendv
calling menu bar controls

I want a cmd button on a form that lets the user "compact and Repair" the database.
The menu's have been removed.
There is a hidden menu, called "Developer" which is only accessible thru a password...
Forum: Modules & VBA 02-13-2003, 01:05 PM
Replies: 2
Views: 1,036
Posted By legendv
Mile, You are wonderful! Thanks! Jon

Mile,
You are wonderful!
Thanks!
Jon
Forum: Modules & VBA 02-13-2003, 12:41 PM
Replies: 2
Views: 1,036
Posted By legendv
Inputbox

On the doubleclick event I have an input box that asks for a password.

I want the form to open if inputbox = txtPassword and cancel if it doesn't.

I can't seem to "call" the inputbox string.
...
Forum: Reports 02-12-2003, 03:56 PM
Replies: 2
Views: 561
Posted By legendv
Thanks Pat, again, and again, and again.

Thanks Pat, again, and again, and again.
Forum: Forms 02-12-2003, 10:27 AM
Replies: 11
Views: 1,105
Posted By legendv
Wayne, Bless you for years to come. ...

Wayne,

Bless you for years to come.

Do you know how to make previously entered data un-editable in the memo field....

Memo:
2/12/03 : Data Entered
2/13/03 : Entrys can be added but...
Forum: Reports 02-12-2003, 09:10 AM
Replies: 2
Views: 671
Posted By legendv
build own reports

I would like to give the user the option of what fields they want on a report. For instance if they wanted to print out a sales report they could choose, before printing, what fields they wanted......
Forum: Forms 02-12-2003, 08:41 AM
Replies: 11
Views: 1,105
Posted By legendv
Question Memo Fields

I want to add info to a memo field without being able to change info that was already added, and with a date/time stamp. Is that possible?
Forum: Modules & VBA 02-12-2003, 08:17 AM
Replies: 14
Views: 14,874
Posted By legendv
It didn't work - (possibly I'm doing something...

It didn't work - (possibly I'm doing something wrong)

ok, there is a formated date field that works great when entered correctly. But if you enter 000000, you of course get an error message. I...
Forum: Modules & VBA 02-12-2003, 07:52 AM
Replies: 14
Views: 14,874
Posted By legendv
What I did: On Enter, DoCmd.SetWarnings...

What I did:

On Enter,
DoCmd.SetWarnings False

On Lost Focus,
DoCmd.SetWarnings True

This didn't work, I'm I using it in the wrong area. (Obviously my logic is off ;-)
Forum: Reports 02-12-2003, 07:43 AM
Replies: 2
Views: 561
Posted By legendv
Calc's in report footer

I want to count the number of orders due for today at the end of a report. The report lists orders due for past future and present dates, but I want to count only the orders due for today.

So...
Forum: Modules & VBA 02-12-2003, 07:09 AM
Replies: 14
Views: 14,874
Posted By legendv
suppress error messages

How do you suppress Microsoft Access error messages?
For instance, when user enters date format incorrectly I would like my own msgbox to appear instead of access. But I don't know how to suppress...
Forum: Modules & VBA 02-03-2003, 10:32 AM
Replies: 2
Views: 749
Posted By legendv
Thanks, I'll try it

Thanks, I'll try it
Forum: Modules & VBA 02-02-2003, 08:04 PM
Replies: 2
Views: 749
Posted By legendv
Question Generate new records by code?

What I need to do is generate a new record(s) based on selections made by the user that gets calcualted by a query then the appropriate number of records become generated. For instance:
Form 1: ...
Forum: General 01-19-2003, 09:44 AM
Replies: 0
Views: 1,298
Posted By legendv
Question Access 2 VB

Has anyone every tried the Access 2 VB program, to convert A2K into VB?
Forum: Modules & VBA 12-12-2002, 01:50 PM
Replies: 4
Views: 940
Posted By legendv
Tried it... It switched to the VB code and...

Tried it...

It switched to the VB code and said

User defined type not defined
The heading was highlighted yellow and
the Dim db as Database was highlighted blue

any ideas?
Forum: Modules & VBA 12-11-2002, 10:38 AM
Replies: 4
Views: 940
Posted By legendv
No. No records are being added. I'd like to,...

No. No records are being added. I'd like to, but don't know how.

Private Sub Combo27_NotInList(NewData As String, Response As Integer)
MsgBox "Please Select A Patient From The List ", vbOKOnly,...
Forum: Modules & VBA 12-11-2002, 05:36 AM
Replies: 4
Views: 940
Posted By legendv
Invalid use of null

How do you suppress this error? It's occuring when a user types something in a combo box - it doesn't appear in the list - the backspace their entry - then try to leave the combo box. I don't want...
Forum: Forms 12-10-2002, 09:20 PM
Replies: 6
Views: 776
Posted By legendv
This took the title out: MsgBox "Couldn't Find...

This took the title out:
MsgBox "Couldn't Find ", vbOKOnly, "Please Retry"

Didn't even think about it... sorry...

But now I get the "invalid use of null" any ideas on how to suppress it?
Showing results 1 to 25 of 99

 
Forum Jump



All times are GMT -8. The time now is 01:11 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World