I have a form with a subform. Text0 and Text2 are on the main form. PercentageTotal is on the subform. I'm trying to make an if statement where it will do one thing if the total of all 3 fields is below 101, and another if it is not. Here is my code...Please help me!
Private Sub...
I have 3 elements concatenated together to form a string, but I am looking for a way to make the middle element appear in bold text. Any ideas or solutions?
I have 3 items I want to concatenate into a single paragraph.
1.Openening sentence fragment (in text form)
2.Dollar value (in currency value)
3.Closing sentence fragment (in text form)
My problem is that I can't get the Dollar Value to retain it's currency formating in the resulting string...
In Form1, I have a currency value as the default value in a text box that has been grabbed from a text box in another form. My problem is that I keep getting a messed up response when I send this value to my query. Instead of the value, I get 2 little boxes. I assume this is because Access is...
I have a form, with a multiselect list box (simple) on it. I also have a button that opens a query, and one of the columns in my query looks back at the listbox for it's criteria value. Well, I can't get this to work at all. I've read other posts, but I still can't seem to get it working. Can...
Right now, the company database has 2 copies: 1 networked version, and a replicated one used on laptops when away from the office. Is it possible to make the 2 versions automatically synchronize when his laptop is plugged back into the network, like the WinXP sync, but amalgamating rather then...
I've built an application to enter and print out reports for my company. To choose which report to print, I've entered [Enter Invoice #:] into the criteria field of a query the report pulls the invoice number from. Is it possible to set the criteria field to some statement that will give a list...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.