Recent content by joebox888

Thanks MajP that worked a treat. I had a "help" button that simply opened up a JPEG image of the form and how to use it. Would a JPEG image have caused all this? Ive left it out now and all seems good so thanks again!

where do i do that?

On mine anyway the tables are allowing the displaying of subdatasheets and also the Name autocorrect option is not checked.. :(

Im having the exact same problem.. my form takes 1minute 43seconds(a lifetime!) to close. It takes this amount of time switching from design view to normal view. It takes the same amount of time whether i repair and compact or not... Any help would be great!!

Its happened again. I had to delete the whole table contents the last time however thats not working now, That pesky record just wont go away! Any ideas on how to delete this "#Deleted" record?!

Cheers Ace!

Hi, I just opened my newly created Database there and got this error message on loading the form. It WAS ok yesterday. The entry that's causing the problem reads #DELETED for every field for that one entry. It seems to be a Data corruption problem. Any ideas? I've tried deleting that record but...

Thanks PHV, I have them numbered 1-27 however i only want 1 to be selected at any time between the two groups where at the moment i can select one from each group. Also Im trying to hide/unhide a subform when one of the options is ticked. I have it working so when the option is not in focus its...

hey! Is there any way to combine two option groups? I have a list off 28 options that need to be cycled through individually on my form however the option group limit seems to be 20. Is there some way to have the 1st option group list 1-14 and the 2nd to list 15-28? thanks

Hi... I'm new to access! Hopefully someone can help. My DB has one table, Its not very big however I have roughly 50 fields in it. 32 of the fields are named x1, x2, x3, x4, ....x32(corresponding to 32 text boxes on my form) I have Tagged each text box with "T". How would i work it so I can...

Thanks for the help Gamma! Regarding the user input q, I have an Input-mask(00.00) and Required tags setup however that will now have to change because all the boxes now don't have to be filled.. The dots are a resultant of converting a Macros to VB code, Thought it was normal.. they are...

Hi there!...I have a fairly easy problem(i think!), Just wont work.. Up to now my basic average system was just fine.. I have 8 text boxes that HAD to be filled before any calculations could begin! .AVG = (.x1 + .x2 + .x3 + .x4 + .x5 + .x6 + .x7 + .x8) / 8 Now they don't all have to be filled...

That way looks so easy however im gonna stay away from it if that's ok(just dont really get it and also trying to stay away from a new column).. I had this working yesterday however now it seems not to be! Is it okay to have an IF statement like this? If Me.typecombo = "BP" Then If...

PassFail1 = Mid("PassFail", 1 - 4*(AVG_3SIGM < SizeCombo.Column(1)),4) can u explain that to me please gamma? im trying to do a very similar thing as Seadna!

would this be work? can you guys have a look at this code to see if its ok? Select Case Me.sizecombo Case "LAC_BP_40015", "LAC_BP_40020", "LAOH_BP_40015", "LAOH_BP_40020", "LAX_BP_40015", "LAX_BP_40020" If AVG_3SIGM.Value >= 15 Then PASSFAIL1.Value = "Pass" Case...