Search results

Hi again guys. Trying to Compact and Repair my database however it keeps asking me for the password. After having to re-enter the password 3 times I get the 'Not a valid password' message. Ordinarily when performing and Compact and Repair you're prompted for the password once, you enter it...

Hi guys. Not sure why but one of my Forms is allowing Edits after I have set the 'Allow Edits' property to 'No' both in the Form design and in the 'On Load' event. Anyone have any ideas why this might be occurring? I'm not having this issue with any of my other databases. Thankyou in advance.

I did have the code in the 'On Current' event. I've moved my 'End If' comments as you have illustrated. For some reason I though if you had multiple 'If' statements you placed all the 'End If's' at the end. My bad. Thanks again Arnel.

So i've added in more of the fields to be updated but only the first field that is 'True' is being updated. Clearly if missed something :-(

Fixed!! Damn label property was 'Transparent' and not 'Normal'. Thanks so much Arnel (y)

No it's a single record form. Only 1 record displays at a time.

Aha, being down under that 'US' spelling catches me all the time. No error now but code not working i.e. nothing is happening..

Thanks for your reply Arnel. I get the following error:-

Hi all. I have a bunch of yes/no fields on a form and I would like to set the background colour of the associated label when the field value is true. The code i've tried on the first label isn't working properly in that it is setting the background colour for every record not just the record...

Thankyou for this post Uncle Gizmo. Couldn't figure out why I was having the same issue.

Can't you just use a 'Combo Box' wizard? Much easier and no VBA required.

Many thanks Pat.

As an extra point of note, the end user wants to be able to see current 'Floor Stock', 'Base Stock' and 'Backorder' information (all of which is calculated in the background) for all stock items in the continuous form of which there are over 2500 which is why I've gone down this path. Couldn't...

It's actually for an individual user (only 1 staff member), but I acknowledge your point. The idea is that as multiple items are ordered on each order, once the 'Add To Order' box is ticked and all items have been selected, the user then clicks the 'Save Order' button which does everything ni...

yes it is.

It's being used as part of a Inventory and Ordering System and I want to reset this yes/no box on each record every time I open this [New Order] form so the user then clicks the yes/no box for each item they wish to order.

Hi guys. I have a yes/no (checkbox) I want to set to 'No' each time the form loads. I've tried {me.fieldname = No} in the OnLoad event. This only works for the first record on teh form. Anyone know how I can apply this to every record on the form? VBA beginner here.. thankyou in advance...

Thanks So Much Arnel!! Syntax sensitivities always bring me undone. Thankyou to everyone for your assistance. Gigitty

So now it's having an issue with the Index I created on that field. Ok to remove the Index??

Thanks for your prompt reply Arnel. Placed the code in but absolutely nothing happens when trying to trigger the code..