Search results for query: *

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...

hi.. I want a Query to calculate the average of all the text boxes that have non-zero values in them. I have 16 text boxes that could potentially all be filled however i would like to be able to calculate only the average of what has been inputted. Im sure its fairly simple i just cant think of...

Ended up just doing a simple insert query on each table individually.. INSERT INTO XLAC SELECT LAC_QOD_40020.* FROM LAC_QOD_40020; took a while but Seems to work grand! Thanks for the help!

Sorry, Meant to say that the LAC(destination table) has all fields needed however the source tables may not have 1 or 2 fields as they would not have been needed! Can an Append query still be used or would i have to use a union query? thanks

Thanks sxschech, For multiple tables though how would i phrase that? My destination Table is LAC and i have about 60 Tables, each tables name begins with LAC_BP_xxx. Could I use a wildcard to pick out tables beginning with "LAC_BP_" and if so how would i go about doing this? Also when i...

Hi, At the moment i have roughly 200 tables in my DB, I am working on cutting this down to only 7 tables. Lets say you have two tables with the same fields in each, one of the tables is empty(fields only).. How could I import the data and structure of one into the other? When i...