Search results

Hi all, i'm having problems deletign data from a local table with a query that *should* delete a range of records selected from another query. The code is below: DELETE tblFinal.* FROM qry0555SELInvref LEFT JOIN tblFinal ON qry0555SELInvref.INVREF = tblFinal.INVREF; Now I have a...

Communications failure Hi all, a bit of a strange one this. I have a table directly linked in via ODBC from a AS/400 DB and I can actually open and view the data from that table, I can also create a basic select statement on the fields I am really interested in and view the results without...

Yup, like a dream !! Thanks again.

Thanks Ken, yes, 'code' is a bad field name but I dare not mess with it myself being the new guy here. I usually play it safe with field names. Cheers again. Mitch.........

Hi all, I have a local table that has data imported from a spreadsheet and we have discovered that one of the fields brings in trailing spaces. Since the Access DB has some querys to manaipulate the data I thought I would just create a qry that would trim the value of that field but I...

Ahh... that did the job. It would have taken me another few weeks to figure that out !! You're a Genius, thank you very much !!!

Thanks SQL_Hell, but I am having problems trying to mix it into my existing code. The error mesage I get is a s follows, Msg 207, Level 16, State 1, Line 4 Invalid column name 'hire_date'. and the code I tried using is use pubs if (LEN(convert(varchar, datepart(mm,hire_date)))=1) SELECT '0'...

Hi all, I am reading through a SQL Server 2005 book and has this code exercise which create a XSD file, but when I try to run it I am getting an error message re line 3. Msg 102, Level 15, State 1, Line 3 Incorrect syntax near '‘'. This line :- ‘<?xml version=”1.0”...

You *should* be able to play LAN games using a crossover cable, it depends on the game itself. If the PS2 does not have any LAN games then get yourself a XBox 360, there are plenty for that..........

No, not personally, but date conversion. I have this lovely bit of code to convert date SELECT convert(varchar,convert(varchar,datepart(mm,tmpdate))+ '/' + convert(varchar,datepart(dd,tmpDate),101) + '/' + convert(varchar,datepart(yyyy,tmpdate)),101) AS TheDate from tmpTbl but I noticed that...

Thanks SQL_Hell, i'll play around with that too :)

Cheers PDX, that fits the bill !! "select SUBSTRING(CitySt,1,LEN(CitySt)-4) AS 'City' FROM tblAddress"

Hi all, I have created a form in Acess 2002 that will clean up the value of some fields in a table. There are spaces after the value and the value ( which is City, state as "Los Angeles,CA") itself needs to be shortened to take out the state so only the City is shown. I managed to do this...

Thats it !! Thank you very much. Mitch.......

Hi all, I have a form that has two fields, date from and Date to, the user enters the dates in these fields then hits a button to display the results from a query. The code for the criteria of the query is as follows Between [frmName]![txtdate].[value] And...

Thanks. I just tried Conditional formatting and it still highlights all the records for that field in blue, and this is probably due to the fact I am using continous forms to display the records so I may have to re-think the display. Thanks again though.

Awp yeah, I have changed the control and the field name to HType. OK, I have placed the code to the on Current event ( the form is a continous form view) but still no joy but I shall look into conditional formatting since I am using Access 2002. Thanks, Mitch.........

Hi all, I'm having a problem getting a txtbox to display the font color blue if the value of another specific txtbox is equal to "Computer", if the value is anything else the text color should remain black. However when the form is open all the Asset fields font color is blue. The code I...

Hi all, I have the following code in a module "Sub exeProperties() Dim db As Database Dim tbl As TableDef Dim prp As Property Dim str As String Set db = CurrentDb Set tbl = db!Books str = "" For Each prp In tbl.Properties str = str & prp.Name str = str & " = " & prp.Value str =...

Hi all, I am experiencing problems trying to put together what I thought was a simple form that would allow users to search for data from a field on one table and display the results in a data grid style from the query I have created. However the query is'nt working and I am sure it is...