Search results for query: *

Thank you. Once I made it PUBLIC, what you included showed me the correct format. Bobby

I created a NEW value in a VBA Detail 'on Print' EVENT PROCEDURE. It will have a numeric value (name is MyTot). How do I need to define MyTot in the VBA module to be able to reference it in an Unbound Text Box (name is PrtTot) in a Repor Footer ? I assume I would see it in the...

Thank You. Works great. That was just what I needed ! Bobby

Sorry, I didn't catch what you were asking for. The VisRegulars primary key is VisRegulars.Regulars. The primary key for the VisLog table is VisLog.Num. This is an autonumber field. VisLog.Num = (not sure how to select next sequence number) VisLog.VisDate = Date() VisLog.VisTime = Time()...

AceMan1 ... Thanks for the reply. I understand assigning the values to the table. The problem is that I don't know how to code such a query (and more important, WHY it works) or using SQL. I do know how to update the current table attached to the current form, but it's adding a new record in...

I have a pretty straight forward situation. Basic visitor login scenario. My form validates info in an existing table (visitor names) and has another unbound field for input (destination). When all fields are complete, user will press a button to add the record to the log table (there in my...

Thank y'all ever so much. The form method was exactly what I was looking for. Unfortunately, server side languages are not available with Cox, so ASP and PHP were not options. Thanks again for the help. [thumbsup2] Bobby

I'll try to explain my problem better...... In the working example below there are 2 input boxes. In the real applicaion there are actually 12. The objective is to get the information typed in the input boxes to be included in the body of the email some how, some way. This is about as simple...

Sorry, I guess I was trying to keep the example toooooo simple. I actually have about 12 variables that I want to include in the e-mail. It's pretty much a questionaire. I just thought if I could get an example of one variable being included in the e-mail, I would just follow the same idea...

There's nothing fancy here. It's all HTML. All I want to do is include whatever is typed in the input box to show up in the body of the e-mail. Thanks. Bobby

I know this has been asked numerous times, but I can't find the answer..... I am using MAILTO in HTML. I want to use a variable in my code, i.e., Input a field and include it in the message. Is this possible ???? I know there are better ways, but I would like to stick with this simple...

Gerry ... Thank you very much. Worked first time! Getting a basic macro running really opens up a lot of possibilities. Again ... Thank You ! Bobby

I am using Text Form Fields from the "Forms" Toolbar. Nothing real fancy, just fill in the form, print, and do it again ! Thank You. Bob

I am trying to automate a standard office form. My form basically has 2 fields. The form works great .... EXCEPT ... I want to enter data for field 1, then have the option to either accept the same value in field 2, OR overtype it with a different value. Thanks to previous help here, I know...

Thank you all very much for your help !!! Bobby

How can I print the same field twice on a form without having the user enter it again. It is a very simple form: tab to field, enter data, tab, enter, ... print, maybe save under a unique name. Nothing fancy at all. Exact usage is in a contract. User will enter name in the opening, then I...

Thank y'all very much. It is finally working !!! Bobby

Thank y'all very much. It is finally working !!! Bobby

I am trying to bold certain records in a report, based on the value of a field. From what I can get out of HELP, I think I should be using the On Format Event Procedure in the Detail section. It does not matter whether the bolding applies to the entire line, or field by field. It may be that...

Thank you both very much. My problem is now a non-problem and what little sanity I had before has been restored. Again, Thank You. Bobby