Search results

The OP wanted to know how to "to create the form and buttons" I am wondering WHERE in the code would you put it? In this line? strOutputString = strOutputString & varSplit(intCount) & Chr(9)

I found this post searching for something else but I have a question about this code. Where in there does it do the Trimming of spaces? I don't see a Trim() anywhere. Where would you Trim the spaces?

I have your site bookmarked. Some nice information on there. Thanks!

I just happened to get the macro thing to work. I was trying to do to much with the condition statement. Here is what I ended up doing. Under the Condition column I just used this: cboFlexo=True I was trying to make an IF THEN statement but all I had to do is enter that code. This is the...

Thanks, I will try this out later today or tomorrow.

I am going to have to try the VBA part because I am getting nowhere with the macro thing. I would rather do it with VBA but this print macro is set up different than my other print buttons. This part is what I am not sure what to do about...

Hello all, I have a question/problem and I need your expert advice/wisdom. I have a program that prints out Work Orders. The original person who set all this up made a MACRO to do this. (See image) I need this print command to access an if statement and IF TRUE I need it to print another...

Is your form based on a query? Sounds like your form is only pulling those records where 'YES' is checked, which would be how you do it with a query.

Yeah I was trying to find something someone else wrote to use. I found this nifty program but the one feature I need won't work. http://xmlwrench.com/ maybe someone else could look at it and see if it will work for you. I already sent an email asking the author whats wrong but no answer yet...

I am trying to find a way to convert an HTML file into either an XML or an ACCESS db. I found a couple programs via google but they are not working as I need. Anybody have any idea? thanks Bottom line is I found a web site that had names and address listed but I want that in an access db to...

Is MS Access 2000 limited to how many computers you can install it on? Or is it a one install program, if you want it on 5 you have to buy 5 copies? What if a company that has not bought a new updated copy of Access still uses 2000, can they get away with installing it on several workstations...

I found the problem. Whoever set this up the first time put a space in between Perf and Up. everything is working great now. thanks

Thanks for the help. I am having one little problem so far. If I put this code in the Private Sub Report_Open, then the printout won't print - Nothing happens. txtPerfUp.Visible = False if I comment out that line then it prints. I have over 20 labels and text boxes and they all work except...

After reading this and looking into it myself I found this help file in access. 'Format Property — Number and Currency Data Types' It helped me understand where Ken got his answer. Just a shot in the dark but heres my try. =format(([On_Hand]-[Qty_Needed]),"#,##0[Black];(#,##0)[Red];0;0")

Might look here http://www.techonthenet.com/access/functions/numeric/format.php

I need to know if this can be done. I have a form that has a print button that prints a printout with all the info for the current record. What I want to know is, if I can make certain text boxes on the printout NOT show up if a check box on the form is checked. ei: If chkBoxOne.checked then...

cboFlexo = Flexo Box = check box = If Me.cboFlexo = True

Have no idea what happened but it works fine now. It did not work yesterday but it seems to be working now. I guess I will use it for a few days and see.

I have a problem. I have this code on one form and it works fine. When I go from one record to the next, if the flexo box is checked it show the flexo text boxes. If the Flexo box is not checked the flexo boxes don’t show up. I copied it onto a different form, same text boxes and same names...

I have a book at home that tells how to do a lot of what you are asking. WindowsXP Tips and Tricks. That is a must have if you want to know stuff like this. I think I remember reading a chapter about configuring keys for certain task like you want.