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 Chriss Miller 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. broodis

    Linking Dates together!

    Could you help me modify it PHV?? Thanks. Really appreciate it.
  2. broodis

    Linking Dates together!

    Hi PHV, I'm really useless at SQL. I've tired editing it several times but I can't get it to work. This is my current SQL for my report: SELECT tblStore.RefDate, tblStore.StoreID, tblStore.PartsID, tblStore.[BalanceAtStore(8AM)], tblStore.BadPartsReceived, tblRepaired.TechID...
  3. broodis

    Linking Dates together!

    Hi PHV, Still can't get the thing to work. Is there a way I can send you my database so that you can look for it? Or do you know how to open a report using a combo box with the record source tblDate.RefDate??? Thanks!
  4. broodis

    Linking Dates together!

    SELECT * FROM (tblDate D LEFT JOIN tblRepair R ON A.RefDate=R.Date) LEFT JOIN tblStore S ON A.RefDate=S.Date WHERE D.Date Between [Forms]![name of form]![txtDateFrom] And [Forms]![name of form]![txtDateTo] Just want to know whats : D , R ,A, and S. Sorry about that. Thanks PHV
  5. broodis

    Linking Dates together!

    To dhookom, Is there another way to link the dates without creating a table for dates? Thanks To PHV, Where do I write the code in?Thanks
  6. broodis

    Linking Dates together!

    HI All, Now I'm trying to link the dates for 3 tables tblDate, tblStore and tblRepair. So far I've tried this approach: tbl Date tblRepair RefDate Date Date RepairID PartsID Repaired TechID 1 1/26/2005 1 1 cable 3 John 2...
  7. broodis

    How to preset an AUTONUMBER from 1 to 100?

    Hi, Just want to find out how to create an autonumber field from 1 to 100. Any ideas??
  8. broodis

    Any Ideas on improving database??

    Hi All, This is basically what my database looks like. It's a bit messy. Just wondering whether anybody could give any advice on how to improve it. Basically what I want to see is who repairs(TechID) the parts(PartsID) and on what date and later link the TechID,PartsID and...
  9. broodis

    Ideas on improving database!

    Hi All, This is basically what my database looks like. It's a bit messy. Just wondering whether anybody could give any advice on how to improve it. Basically what I want to see is who repairs(TechID) the parts(PartsID) and on what date and later link the TechID,PartsID and...
  10. broodis

    Clearing data in a textbox by using a Command button

    Is there a way I can clear the data in a textbox without coding???
  11. broodis

    Selecting multiple data and saving it in a field!

    It's okay guys. I got it working already. Thanks fiep, GingerR,PHV and RoyVidar for all your advice. It really helped me.
  12. broodis

    Selecting multiple data and saving it in a field!

    Okay I think I managed to fix the problem. But now its not saving it into the field Findings. Do I need to make an update command button to update it?? And if so, how do I do it??
  13. broodis

    Selecting multiple data and saving it in a field!

    Is there an example for this type of problem? Sorry I confused all of you.
  14. broodis

    Selecting multiple data and saving it in a field!

    Oh that was what Finding was. I thought it was a field where I saved the data in. But after I changed StrFound to String it says "The value you entered isn't valid for this field" Hmm is there any way I can share my Access file with you all? So that everybody can see it???
  15. broodis

    Selecting multiple data and saving it in a field!

    Now it keeps on saying "Type Mismatch". I thought it was because I referenced the findings as follows RefFind Findings 1 part A stuck 2 part B not working (etc) and it only reads the RefFind. So I changed StrFound to an Integer. But its not working. Any ideas...
  16. broodis

    Selecting multiple data and saving it in a field!

    Hey Fiep, Can you explain to me how your code works. Thanks.
  17. broodis

    Selecting multiple data and saving it in a field!

    Does anybody know how a variant works. Because I think thats what varItm is.
  18. broodis

    Selecting multiple data and saving it in a field!

    Thanks RoyVidar and GingerR, I think I'll stick to my initial plan. But can anybody explain to me fiep's code, like where they are all linked to. Especially 1.varItm 2.Me.SelectionList.ItemsSelected 3.Me.SelectionList.ItemData(varItm)
  19. broodis

    Selecting multiple data and saving it in a field!

    To RoyVidar, Using your way I have to key in the problems one by one and that will be very inconvenient for the user. (Eg. Machine1 - part A not working Machine1 - part B stuck Machine1 - part C not working What I want to do now is combine all this problems together. eg. Machine1 - partA...
  20. broodis

    Selecting multiple data and saving it in a field!

    Do you mean I have to create a listbox and store this code into it??? Thanks.

Part and Inventory Search

Back
Top