Search results

additem Just playing around with Access 2000, i notice the additem and removeitem functions are not supported?? it works only with 2003 upwards.. what is the workaround in older versions of Access please?

hello Thankyou. Problem resolved!

re: Yes that works dave, Thankyou. But as soon as i enter cboxbox1, i want to clear the current value showing in cbobox2?

hello Thanks, but im getting a syntax error with the above code in the rowsource. it dont like ; ?

Hi all, I wish to use vba to complete 2 combobox selections, rather than use a query. so far i have Combo1 = AAA BBB Combo2 = CCC DDD EEE FFF So if i choose AAA in combo1 then combo2 gives me the chioce of CCC or DDD and if i choose BBB...

re: fixed it by simply redoing the validation mask in the property. Can you believe :)

re: something is definately strange in my ac2003! i tried both variants and still no joy.It wont accept todays date! I went into the table, BTW this is linked to a repository in Ac97 format in another database and inserted the validation rules as suggested above into them. saved everything and...

re what do you mean m8? i tired <date() it wont accept todays date, so something is missing?

re thanks mate!

I've got a date validation in a property box, basically i want to accept a date entry that is equal to or before todays date. This is what i have so far Validation rule: <=Date() Validation text: Cant be higher than todays date Looks ok right? but if enter todays date, i still get the message...

Still no joy!! its this blooming "Description",with no text entered in , it does the docmd.cancelevent and then straight to end if, bypassing quantity and else save record etc! - i give up !

re: its weird, the cancel event gives this error: run-time error 2001 - you cancelled the previous operation, so it dont like that. The database im working on is a big beast, so cant really email it, but the form is simple. 3 text boxes, a comand button save, and the code, and a table.

re: tried that mate and still no joy, i have now singled stepped through the code to see whats going on. it appears that the problem is with the elseif isnull() statements. if it detects something in the textbox, then its ok, and goes to the next elseif, however, if nothing is in the textbox...

Tried it again.. no luck yup just tried your suggestion rainman89, exactly as you suggested. Still, it continues to write a record in the table! So i don't know whats going on

Tried it Even with the following, a new record is being created. Note the acSaveRecord is now before the endif ? Private Sub save_rec_Click() PART.SetFocus If IsNull(PART) Then MsgBox " Please enter a Part" PARTNUMBER.SetFocus elseIf IsNull(DESCRIPTION) Then MsgBox "Please enter a...

I'm learning it slowly, but getting there! When a user clicks the save button on my form the bit of code below will check for empty fields and show a msgbox if the textboxes are empty. That all works fine, but, it appears that a record is being created in my table if i say only one field is...

re: yep that works. Thanks uncle

re: yes i understand what you say, but it doesn't seem to work with the code im using below.. i've tried commenting out the filter, still no joy. Below, i'm trying to order the filter results by Input dates. Thanks lngLen = Len(strWhere) - 5 If lngLen <= 0 Then 'Nah: there was...

re: Can the orderby command sort the records ascending or decending? if so, hows it done? thanks

Hi all, i'm using the following two lines in VBA to return filtered results on my form. What do i need to add to this to have the flexible in sorting the data asending or decending by say any column heading i.e "Parts" or "Date" I'm not using a query in this particular case. Thanks Me.Filter...