Search results for query: *

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

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

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?

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.

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

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.

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

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

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

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.

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

Hi, See thread705-297798.

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

...I am using this code: matchorg = Forms![frm_customer_changed]![OrganisationID] Set db = CurrentDb() Set rec = db.OpenRecordset(&quot;SELECT * FROM tbl_customer WHERE ((tbl_customer.OrganisationID)= &quot; & matchorg & &quot;);&quot;) If Me!txtOrganisation <> rec(&quot;Organisation&quot;)...

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

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

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

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

That seems to work! Thanks very much.

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