Search results

Hello, Happy Holidays! I have a database that includes many currency fields. I generate invoices from this information. My company produces training programs for other companies. There is a program fee which is charged to every client; however, there are other expenses that may or may not...

Nope. I may have messed up the registration process, although all appeared to be fine......I'll try again and let you know.......Thanks for your "live" assistance and have a great day!!!!

yes.....i'm using Access 2000 (if that makes a difference).

WOW!!!! You're fast!!! Yes I did. Do you think it's possible that not all gifs would work?

gif89 won't work Hi, I followed the instructions above, registered the dll and registered the active x control, but the gif does not appear on a form. Any suggestions? Thanks so much. Pat

No luck. I give up. Thanks anyway!

getting error message...."invalid SQL statement" rst.Open "tblMagicEightBall", CurrentProject.Connection, adOpenStatic, adLockReadOnly and yes, the code is in a module. Thanks.

wrote the code, travis. But I'm having trouble calling the function.

Hey, I'm having a little fun with my co-workers. I'm trying to set up a button on a form that will display messages in a random fashion (like the old toy, "Magic Eight Ball") I want to write several messages and have a different one appear each time the button is pushed. Is this a...

thanks.....can i also make the mask conditional at the table level? Sorry....i'm fairly new to all of this.

Hi, I'm trying to use a telephone input mask (999) 000-0000 that would activate only if the Country ID = US or Canada. The problem is that the input mask will appear, but it won't save the form in that format. Also, how do I write the code to include US and Canada. Visual Basic seems to...

Form not saved with input mask Hi, The code worked just fine, but the form won't save with the input mask. What am I doing wrong? Thanks again!

Thanks! What would I do without you guys?????

Hi, I would like to use a telephone input mask of !\(999")"000\-0000;0;_ that would change to a text field if the country ID is anything other than the US. Can anyone give me the proper code? Thanks so much (as usual)!!!!! Pat

Hi, I would like to create a command button on a form that will automatically open a report........can I create a button that will open this report and convert it to doc. or rtf. format? This is a report that will be sent to various people (not all of whom have Access). Does anyone have any...

Hi, I'd like to be able to have a little fun in one of my forms. I would like to display a round red button that, when pushed, would respond to a yes/no question. I would like to make it look like a panic button. Can it be done???? Thanks!!! Pat

Thanks, Pat. Does this mean I would also need a table for Roles?

Hi, I've spent hours on this one and I'm still getting it wrong. I'm working on a database for a consulting/training company. I have (for the sake of example) 2 tables. I have one table that lists the many company locations around the world and another table that contains basic program...

Hello, Is it possible to have an input mask only in certain circumstances. I would like an input mask to appear for the phone in a table but only if the country address is in the US. Otherwise, it would need to be just a text field. Is there some code I can write for this? Thanks so much...

Hi, I have a mysterious new compile error message appearing in my Access Database. As I am running a serious of make table queries to update records, a message pops up that says. Function or Interface marked as restricted, or the function uses an Automation type not supported in Visual Basic...