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

    Incorrect Athlon identified

    You were all right it was the speed setting. Thanks for your help. Sorry for my stupidity.
  2. whiffy

    Incorrect Athlon identified

    Oh ok, but it doesn't identify it as 1800Mhz - it says "Athlon 1800+" as a product name rather than a speed. I was of the understanding that Athlon CPUs had an identifier in them and was wondering if this could possbily be wrong? Or would increasing the speed to 2000Mhz make it say...
  3. whiffy

    Incorrect Athlon identified

    Hi, I've got an Athlon 2400+ but on boot up the MOBO says I have an Athlon 1800+. The MOBO is an AOpen AK79G-1394. Any ideas why this is?
  4. whiffy

    Earth hum

    Thanks everyone for your help. I shall try the power supply solution. The dodgy capacitor theory sounds likely as the laptop has not always made this noise. Thanks again.
  5. whiffy

    Earth hum

    Hi, Please forgive me but I know very little about electrics. My problem is that I have a laptop that creates a static like humm/hiss with added squelchy noises when the mouse is moved or when the built in LCD screen refreshes. I don't get this noise when it uses it's battery (which lasts for...
  6. whiffy

    Summing Text Boxes

    Hi, Are the numbers stored as text? you could try =CLng([Name of 1st box])+CLng([Name of 2nd box])etc. I thought Access did this automatically anyway so I could be wrong.
  7. whiffy

    Highlight fields

    Hi, Danvlas- There's more than enough colours, but I like your thinking! ChrisCalvert- Right, well the message box came up with -2147483643 then it came up with 10088675 indicating that the colour has indeed been changed, then the form opens and the colour hasn't changed. However, I tried...
  8. whiffy

    Highlight fields

    Wow, even with the default backcolor set to 10088675 via the properties window and no test applied to the field it still appears white! Bizzare.......
  9. whiffy

    Highlight fields

    Hi, The default BackColor is -2147483643 but just to be on the safe side I added the 'Else' statement as you suggested, but still no joy. I have also tried altering the fontweight property which didn't work but strangely the specialeffect property does. The backcolour change works perfectly...
  10. whiffy

    Highlight fields

    Hi, Your suggestion is much appreciated but for whatever reason it's still not changing the background. I must admit I hadn't done that for ages.
  11. whiffy

    Highlight fields

    Hi, Thanks for your suggestion, unfortunatley it's still not highlighting the field. Strangely, If I change the action from: Me!emailfield.BackColor = 10088675 to: MsgBox ("!!!!!") The message box pops up as expected, whereas the backcolor one doesn't. Now I'm really confused..........
  12. whiffy

    emailing attachment

    Hi, See thread705-297798.
  13. whiffy

    AuditTrail/Imaging

    Hi, Without going into too much detail I think what you'll need to do is to create another table called something like ContractActualArchive with these fields: ContractActualArchiveID (autonumber, primary key) ContractActualID (foreign key linked to ContractActual's primary key) WeekEnding...
  14. whiffy

    Highlight fields

    I have 2 tables (that admittedly go somewhat against the normalisation rules) called tbl_customer and tbl_customer_changed. tbl_customer holds details of all our customers, tbl_customer_changed holds temporary information on address changes that gets deleted once it has beeen approved. This...
  15. whiffy

    Disappearing info

    It's ok. I worked it out. I needed a right join. Thanks for responding so quickly. Cheers, Ian
  16. whiffy

    Disappearing info

    Here it is, as generated by Access using Design View. (I'm no good with SQL). It looks rather more complicated than it needs to be I think. SELECT DISTINCT tbl_CustomerQuery.queryId, tbl_QueryCat.QueryCat, tbl_QueryType.QueryType, tbl_QueryCon.QueryCon FROM tbl_QueryType INNER JOIN...
  17. whiffy

    Disappearing info

    Hi, I should know this. But I don't. obviously. Can anyone help me? I have a table called tbl_customerquery which, amongst others, has three foreign keys queryconid, querycatid and querytypeid which link to the tables querycon, querycat and querytype respectively. The thing is there is only...
  18. whiffy

    email from within form

    Hi, this is how I did it: ---------------------------------------------- Dim emailto As String Dim messagetext As String Dim subjecttext As String emailto= Me!emailfield messagetext = "Customer: " & customername & Chr(13) & Chr(10) & Chr(13) & Chr(10) & _...
  19. whiffy

    Report fomatting

    That seems to work! Thanks very much.
  20. whiffy

    Report fomatting

    We have a database of customers which amongst others includes schools. We want to send a letter to all schools (who are identified by customertype = 27) to ask them to let us know when they will be closed for the school holidays. Each school has a varying number of departments, which are...

Part and Inventory Search

Back
Top