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!

  • Congratulations Mike Lewis 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: *

  1. Smeg77

    3070 Error Message

    PHV Thanks for that, also does the trick nicely, and with a fraction of the lines of code :) It's been too long since I've had to play around with all this stuff, so at most of my code is done in a logical fashion which also mean lots of un-necessary lines of code.
  2. Smeg77

    3070 Error Message

    dhookom thanks that worked. I have to admit I'd tried everything I could think of apart from doing that :)
  3. Smeg77

    3070 Error Message

    Can someone possibly help with this. I've done a bit of looking around and I can't find something that quite matches my problem. This is the code I'm using; Dim L As Recordset Set L = Me.RecordsetClone L.FindFirst "[tblStolen]![ID] = " & Me![Combo_Stolen_Lookup] Me.Bookmark = L.Bookmark...
  4. Smeg77

    Updating Multiple Fields from a Combo Box

    PHV Thanks for that, such a simple little solution, but one that has been doing my head in. It works a treat so thanks again
  5. Smeg77

    Updating Multiple Fields from a Combo Box

    I have a Combo Box that is run from a simple query. All it does is look up the Workers from tblWorkers and gives me a list of the names. Currently I have it set so that the ComboBox records this value in on of my table fields, and I would also like to do is get it to record the ID value from...
  6. Smeg77

    Copying ID into new table

    Just noticed I was in the wrong forum section. Can a mod please move this to the Microsoft: Access Section please (if possible)
  7. Smeg77

    Copying ID into new table

    I have a simple DB with three tables, two of them I have linked together, one for Workers and one for Equipment. I've created a third table to record any equipment that gets stolen. To try and keep things simple I want to take the ID from the Worker Table and Use it as the ID for the Stolen...
  8. Smeg77

    Either Un-Doing or Not Saving a Record

    I was dabbling earlier and managed to find the properties bit where you can Link Child / Master fields, but no matter what I've tried I always get the same message. You can't link an Unbound Form. I'm not sure where I've gone wrong or what is required to make the Form Bound.
  9. Smeg77

    Either Un-Doing or Not Saving a Record

    It's been a real long time since I learnt how to use Access, so I'm just piecing things together as I go. It's just meant to be a really simple DB, there's only two normal tables and one lookup table, and a User Access Table. All of the Tabs I am using have a sub-form in them, the Master Child...
  10. Smeg77

    Update tab control fields from another tab

    Barbola, You can try this, as I am also using tab pages, and have mine set so that a value from one Tab enters it itnto another. now my coding skills aren't great so there might be an easier way but try this: Dim Name As String If Me!TabCtl0 = 2 Then...
  11. Smeg77

    Not Returning Records

    I have a Main form I've called MainMenu, and then Stuck a TabCtl in it. So basically I have one form which currently has about 6 tabs, form which I was going to do everthing. Most things I now have working, so I've got a nice login tab, and 2x Data Entry tabs, where the Worker.ID is linked to...
  12. Smeg77

    Not Returning Records

    I'm having a complete mental block on why this isn't working. I have two lookup tabs, in that they will be deisnged soley for looking up information and not changing. I have managed to get it so that the Worker.ID is linked to the Equipment.ID (as they are the same) the only problem I now have...
  13. Smeg77

    Either Un-Doing or Not Saving a Record

    I currently have a tab structure for a simple DB, and after a little bit of fiddling I've managed to get two of the tabs to link up in the way I want. For example, the Main.ID is taken from Table 1 and then when Page2 (of the tab) is opened it passes the Main.ID into the Sub.ID field, allowing...
  14. Smeg77

    Tab Controls and Combo Boxes

    Redwoodly, it worked perfectly, and was simple enough for me to get my head around so thanks.
  15. Smeg77

    Tab Controls and Combo Boxes

    Redwoodly, thanks for that it makes perfect sense. I'm not back at that site until Monday so I'll give it a bash. If it works I'll be giving you a big Man hug (a kiss is out of the question) :)
  16. Smeg77

    Tab Controls and Combo Boxes

    Andy Thanks for the response, and you'll have to bear with me here. My programming skills have well and truly lapsed, and so although I can read things written and work out how they work, developing things from scratch is proving to be quite hard. I don't really have any code to post, as I'm...
  17. Smeg77

    Moving Data Between Two Combo Boxes

    I found this in my recent searches for help with Access, I think it does waht you are asking, one Independant Combo Box, and one that Depends on the other. http://www.blueclaw-db.com/download/dependent_combo_box.htm
  18. Smeg77

    Tab Controls and Combo Boxes

    I'm in need of a little assistance if someone could possibly help me. I'm trying to create a simple little db, using tabs. I've already managed to piece together a nice little login facility, with access rigths. So that I can dispaly whih tabs I want depening on your access. I'm now having a...

Part and Inventory Search

Back
Top