Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: joebox888
  • Order by date
  1. joebox888

    Form Takes really long time to close

    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!
  2. joebox888

    Form Takes really long time to close

    where do i do that?
  3. joebox888

    Form Takes really long time to close

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

    Form Takes really long time to close

    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!!
  5. joebox888

    "Record is deleted"

    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?!
  6. joebox888

    "Record is deleted"

    Cheers Ace!
  7. joebox888

    "Record is deleted"

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

    combine two option groups..

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

    combine two option groups..

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

    Loop through Tagged text boxes on form??

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

    Average of non-null text boxes on form?

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

    Average of non-null text boxes on form?

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

    Huge IF statement I suspect should be a lot simpler

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

    Huge IF statement I suspect should be a lot simpler

    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!
  15. joebox888

    Huge IF statement I suspect should be a lot simpler

    ..."LAX_BP_35020", "LAX_BP_35030", "LAX_BP_37515" If AVG_3SIGM.Value >= 15.5 Then PASSFAIL1.Value = "Pass" Case "Like 'LAH_BP_45*'", "VIV_BP_4008", "VIV_BP_40012", "VIV_BP_40015", "VIV_BP_40018", "VIV_BP_40021", "VIV_BP_40025", "VIV_BP_45008", "VIV_BP_45012", "VIV_BP_45015"...
  16. joebox888

    Changing average Query?!

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

    import from one table to another in Access 2003

    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!
  18. joebox888

    import from one table to another in Access 2003

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

    import from one table to another in Access 2003

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

    import from one table to another in Access 2003

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

Part and Inventory Search

Back
Top