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: *

  1. YellowOnline

    Filter IPAddress and write to a file

    ...-namespace "root\CIMV2" -computername $strComputer -EA Stop FOREACH ($objItem in $colItems) { write-host "Model Name : " $objItem.Model $CalcMem = [math]::round($objItem.TotalPhysicalMemory/(1024*1024*1024),2) write-host "Total RAM : " $CalcMem GB write-host } }
  2. YellowOnline

    Custom Filter Forms

    OK, I finally did it this way, lending some code snippets from a form in my DB made by someone else: Private Sub cmdFilter_Click() Dim AllFilter As String Dim Filter1 As String Dim Filter2 As String Dim Filter3 As String Dim Filter4 As String Dim Filter5 As String...
  3. YellowOnline

    Custom Filter Forms

    Uh, something went wrong copy/pasting. I didn't forget the FROM part, it just didn't got pasted here :) But I might have found the problem... apparently my cbo decided to forget the name I gave it and get a random "combo10" name.
  4. YellowOnline

    Custom Filter Forms

    ...suggestion as I really can't figure PHV's suggestion out. I'm not sure about the right syntax though. Right now I tried variations of SELECT * WHERE [Shop]=me![cboFilterShop].Value ... but I keep getting syntax errors. All info on the right syntax that I can find limits itself to numeric or...
  5. YellowOnline

    Custom Filter Forms

    Hi PHV, For the shop number this could indeed be a solution, as this number is unique. It would point directly to the record I want. For the Shops it is no solution however. It would just lead me to the first record that has a Shopname = to the one in the cbo. So your suggestion is not exactly...
  6. YellowOnline

    Custom Filter Forms

    Hello all, I feel bad about posting again, but this Access DB is driving me crazy. I finished my database, everything is fully working but it lacks some user friendliness. A thing I should really add is a custom filter. Let me show you first, schematically, how one of my forms looks (this was...
  7. YellowOnline

    4CoreDual-SATA2

    Well, your thread is quite vague really. If you mean "Does anyone have any issues combining a quad core with SATA2": I do not. I have a Q6600, 8GB DDRII and a few - of different brands - SATA2 disks. It would help if you specified the problem of course...
  8. YellowOnline

    What's the event I'm looking for

    I added the requery to the cbo's After Update for new ingredients and I also added it, as you said, to the Current Event from the form. that does exactly what I wanted. I forgot the forms theselves have Events too. Thank you very much PHV.
  9. YellowOnline

    What's the event I'm looking for

    This is probably a very easy question, but I just can't figure it out. I got a mainform with a cbo, showing 1 record at a time. Every record shows a subform with items connected to it. The names of these items are in a cbo dependent on the cbo in the main form. I made a button on the main form...
  10. YellowOnline

    Refer to Form and Subform properties and controls in VBA

    Hello everyone, This proved to be a great help for me when I wasn't sure how to refer form one (sub)from to another: http://www.mvps.org/access/forms/frm0031.htm I think this overview will be helpful for a lot of people. Kind regards, Yellow
  11. YellowOnline

    How to make a simulation tool

    OK, NM this thread. It is, in the end, so complex that I hired someone to do help me.
  12. YellowOnline

    Sometimes even a GURU needs help...

    I don't know what OS you are using, but you could take a look at these two MSKB articles: 123298 and 811259 (the latter also refers to a netsh winsock reset). Personally I would give this a try: remove the wireless drivers, shut down, remove the PCI card, power on, shut down, put the wireless...
  13. YellowOnline

    Windows.old Help

    If it's called .old I wouldn't worry about deleting it. If you're still not sure: rename it and put it elsewhere. If your system still works, its safe to delete. If not, you just need to put it back fror a command prompt or from a linux live-cd. Yellow
  14. YellowOnline

    Unistalled VMware, keyboard does not work

    Which drivers did you exactly reinstall? Drivers that came with your keyboard? About every keyboard is OK with the generic driver. Try a USB stick to see if other USB peripherals still work. If not, reinstall your USB drivers. Yellow
  15. YellowOnline

    HP PSC 2210 - It feeds the paper but won't print

    I have seen this problem before with exactly the same type of machine, but it is a few years ago so I must think really hard to remember how we solved it. At least you know that "youre not alone" ;-) The only thing I can right away think about is a setting that stays where it is, however much...
  16. YellowOnline

    THE OPERATING SYSTEM STOPS INSTALLING

    Try to run memtest from a bootable disk or cd-rom (http://www.memtest.org/) and you'll soon know if it is a RAM problem or not. If not, like BadBigBen said it can be pretty much any hardware. Even though 2 years is a short lifespan for a HDD, I'd guess it is the hard disk. you could try running...
  17. YellowOnline

    How to make a simulation tool

    Actually, I wanted to do that but Access keeps the file big, even when I removed all of the data :-/ As a zip, however, it is less than 1MB. You can find it with most of the data removed or dummied attached to this post. Thank you in advance.http://users.coditel.net/COD95493/demo.zip
  18. YellowOnline

    How to make a simulation tool

    Too late to edit. Just wanted to say I've read fneily's posts and the databasase is normalised.
  19. YellowOnline

    How to make a simulation tool

    Hello everyone, I made a big database that links countries, plants, formulas, ingredients and wholesale prices. Currently i have a form showing per formula what plant/country it is from and a subform showing the ingredients and prices. In the main form a total cost is calculated for each...
  20. YellowOnline

    Artifacting? Bad Video Card?

    Its definately artifacts and not a refresh rate issue. Wrong refreshrates, in my experience, look worse than this. You could try switching the monitor cable just to exclude that possibility. To me it seems to be an overheating issue though. I've seen uniform artifacts before on overheated GPUs...

Part and Inventory Search

Back
Top