Search results

I tried the function yesterday, but it did not work. I typed in virtually every possible character for "Allowed" but it wouldn't work; however, I just tried it again, and, I don't know what I did differently, but it finally works. You people (Mike, D-Fresh, Raskew, and all the other people...

I changed the Data Type to text instead of memo, but it still doesn't work. I am storing product descriptions in this field. The field is updated through a text box on a form. The users tend to enter data like: TEXT BOX ****************************************** Product[A345X989] -Requested...

Once again, thank you for your time and efforts in trying to help me solve this problem. I tried using the new function, and I included every possible character that would be in the database as "allowed", but nothing showed up. As far making the memo field a text box, if it would allow me to...

Mike and raskew, Thank you very much for the help. The function you gave me does eliminate the spacing between characters that are close to each other, but the original field typically has one really big space (as it is a memo field), and the function does not eliminate this space. Those are...

Where would I put the function? Also, would I have to call it from another function? Thanks, Nick

This is probably the last question that I will ask for a while, but I really need to figure this out, so if you can, please help me figure this out. Thanks

For "The Stuff", would I just put cbodescription if this contains the values where I would like to eliminate the spacing? Thanks, Nick [This message has been edited by npierson (edited 06-15-2001).]

1. I created a combo box that contains values queried from a table field. 2. I created another combo box that auto populates with the corresponding value of the one selected in the first combo box from the same table (just of a different field). 3. This works EXCEPT: Since some of the...

Charity, I can't thank you enough for all of the help you've given me in the past few days. I finally works. Thanks again, Nick

I set the record source of the subform equal to the query, yet when I select a value from the combo box nothing happens (and the I'm sure the query works). As you stated, it does seem like an easy question to answer, so I must be missing the obvious. Thanks, Nick

I made a query that displays values based on a combo box (unbound) on a form, but I need to figure out the following since I want to display the queried values on the form then send the query or subform to a client (not important): How can I make a subform display values from a query? OR How...

I finally got it working. Thank you very much for the help everyone, Nick

After prompting for a password using a form, I would like to evaluate whether the password is valid (I know how to do this). If it is, I would like to load a certain form and make the password form dissappear, and if it is not, I would like to load a different form and have the current...

I tried that and DoCmd.Close acForm, "Form Name" but none of these work.

What is the code to unload a form? Thanks, Nick

I really need to figure this out ASAP so please, if you can, help me out on this one problem. Thanks

I used the current form (with the password) for "This Form Name" by the way. [This message has been edited by npierson (edited 06-04-2001).]

I'd like to send the subform

I can't thank you enough for all this help; however, the following line of code always receives an error: docmd.close acform "ThisFormName" Everything else works great, but I can't seem to figure this out. Thanks again, Nick

That worked great, thank you. . . But, could I accomplish the same thing using a subform? Thanks, Nick