Search results

do you know where I could post it.

Interesting, a lot of good things. So much to know with so little time. I have installed on my computer access 2007 and 2010, but I would say I often use 2010. No, I don't know what a continuous form is. :-(

Ok thanks so that means I have to create a state and postal code text box or combo box so the error won't show? And I tried to test it by opening the form in form view and then type in a few characters and it shows no result. Do you know what is wrong?

Also with the code I often get a Run-time error '94': Invalid use of Null if I close the form and then open it again. I suspect is because the Discontinued option button is blank. If Discontinued Then Me.ProductName.BackColor = vbRed Else Me.ProductName.BackColor = vbBlack End If

Ok, I created a access table, with field suburb, state and postcode. I've Attached an image file of the sample data I use as test. I then create a form called Postcodes, and created a comboBOX. I called this comboBox "Suburb". I left Row Source empty as Allen suggest. I have Bound Column as 1...

Compile time runs first and then the execution time right? Ok I will have to try those two and then I will find out. Thanks

Ok, thanks. How do you do a conditional formatting? And how do you know this is a continuous form, and what does a continuous form mean? Actually I think the reason why it only runs the code when I open in design view, then form view is because the code is in this Private Sub Form_Current()...

Ok, thanks. I have looked at Allen's Code and so far I tried it and it has not yield the result I was hoping for. Maybe I didn't use his codes correctly? I am still analyzing his code and see what I could do. However I did noticed a problem and that is, the code only runs when I open the...

with this code that you provided: and most of my codes are like this which is not efficient, is that it only works properly when I open the form in design view then open it again in form view, sort of like resetting it. It would be more effective if it is not like that, and it changes...

and I also wonder what is the difference between me!productname.backcolor =vbblack vs me.productname.backcolor = vbblack.

Ok, I noticed the code only work when I select the option box and then select the form into design view then click it into form view. I then see the color working. but when I have it as form view, and then I just click select and deselect the option box, the color for the text box doesn't...

Ok, thanks. The code I have is kind of weird, it doesn't run until I open or refresh the form. so I just close the form, set a break point and then open the form again, it runs to the break point and then I just press F8. Is a private sub form_current.

Ok, thanks. Interestingly both Jason and you have the same baldy, does it stand for something. Also I went into my code editor by pressing alt F11 and I press F8 to step into the code and it doesn't do it. In excel VBA, normally I just alt F11 to get into VBE and then I just press F8 to step...

I am pretty new to access, so I don't know much of it's use and functions. But I am wondering does MS access VBA has the step into function that allow me to run the code step by step to see what it is doing and what value is storing in the variable so is easier to trouble shoot and manipulate...

alright thanks.

I see 255 is also yellow as per the website but the 255 is on the Hex column and I don't really know what Hex, R, G, or B is? but I guess MSAccess means those color code is for Access and I tried a couple and it works. :-)

If Discontinued Then Me!ProductName.BackColor = 255 End If discountinued is an option button and productname is a textbox. I use a code like this, and 255 is red. But when I checked to see for other color options, I see 255 is also yellow as per this website...

Ok, thanks. I am still checking on the links and see what I can do. I have a question: Do you know if access text box or combo box have a feature similar to google, that when I type to search for a word, a drop down list of possible words/ list comes up and the user can then select from the...

Thanks pbaldy for your response to my inqueries I did it for the bidder, pulling uname from the user table. But I do have a questions, while my list is small of only 15 records, what if there are thousands of records or millions, then I don't think this would be efficient to choose with a...

I have a table called BID with the following fields bidder, seller, iid, starttime, bidtime, and bidprice bidder is an id number that is reference to uid of table USER the USER table have the following fields, uid, uname, city, and state I created a BID form for the user to enter data into...