Cause number to act as a string?

[chris-uk-lad]

What data type is the field 'Name' in the table?

The field is 'Text'

 

[KenHigg]

Can you post a sample db?

 

[KenHigg]

What happens when you paste that sql string into the qbe?

 

[chris-uk-lad]

Can you post a sample db?

would take me some time to put one together, has some sensitive records. As for QBE ive not heard of it?

 

[Rabbie]

would take me some time to put one together, has some sensitive records. As for QBE ive not heard of it?

QBE is just the standard Query design grid. No great mystery there

 

[Brianwarnock]

QBE is just the standard Query design grid. No great mystery there

The only mystery is why IBM called it Query By Example when they introduced DB2, Why not Query Design Grid - QDG

The other mystery is why Chris wont change the name of Name field.

Brian

 

[Banana]

The other mystery is why Chris wont change the name of Name field.

Indeed. I was wondering the same thing myself. For all I know, half of his problems could be rooted in this odd insistence of using reserved words. Granted, brackets may help, but why push one's luck?

 

[chris-uk-lad]

well its working now, i placed cstr() into the sql command around name and now it retrieves the numbers fine, i must have just been doing incorrectly when i put in name = cstr(name) before :s

and i shall revise my naming of Name, dont worry, thanks all fo rthe assist ^^

 

[DCrake]

Because IBM are IBM. Having said that I wonder if anyone knows where IBM got its name from? I am lead to believe it stands for International Business Machines. But in truth they represent the first letters after the robot in 2001 space oddessy HAL.

 

[KenHigg]

This is far fetched but I think it has something to do with the .SetSearchResults thing. I'd simply manipulate the form recordsource query...

 

[boblarson]

Indeed. I was wondering the same thing myself. For all I know, half of his problems could be rooted in this odd insistence of using reserved words. Granted, brackets may help, but why push one's luck?

Actually, it may be a big source of the problem. Most Reserved words you can get around by using brackets and all. But, there are places where NAME will still get you in trouble and that is the one place where I will insist that someone make a change because it will cause problems. Most noticeable is if you try to refer to a control or field named "NAME" in a form or report because Access assumes you want the name of the form or report, no matter how you try to bracket it (at least it has been my experience to this point).

 

[KenHigg]

well its working now, i placed cstr() into the sql command around name and now it retrieves the numbers fine, i must have just been doing incorrectly when i put in name = cstr(name) before :s

and i shall revise my naming of Name, dont worry, thanks all fo rthe assist ^^

Glad you have it working -

 

[KenHigg]

...But, there are places where NAME will still get you in trouble and that is the one place where I will insist that someone make a change because it will cause problems.

'there are places' <- 'that is the one place' ???

 

[Brianwarnock]

Because IBM are IBM. Having said that I wonder if anyone knows where IBM got its name from? I am lead to believe it stands for International Business Machines. But in truth they represent the first letters after the robot in 2001 space oddessy HAL.

Not to hijack this thread but IBM was around long before 2001, besides all purchasers of IBM equipment knew it stood for "I've Been Misled"

Brian

 

[gemma-the-husky]

IBM came before HAL. so Arthur Clarke actually did it as a humorous reference to IBM, which you obviously know

HAL did stand for something - Heuristic something/Human something - I forget which - I've read The Sentinel, but never watched 2001 all through.

I thought IBM was Its Better Manually
or even Itsy Bitsy Machines

 

[Rabbie]

IBM came before HAL. so Arthur Clarke actually did it as a humorous reference to IBM

I thought IBM was Its Better Manually

and ICL was It Cant Last.

IBM was around before computers. They produced typewriters (including the ones with the golf ball head) and othe office machinery.

 

[gemma-the-husky]

IBM tripewriters - seems such a long whole ago

what about comptometers - now there's a black art - the comp operator

or the big funny NCR bar machines - mechanical computing

 

[DCrake]

Brian

Not to hijack this thread but IBM was around long before 2001, besides all purchasers of IBM equipment knew it stood for "I've Been Misled"

Actually it was released in 1968.

 

[Rabbie]

Brian




Actually it was released in 1968.

The film 2001 was released in 1968. I remember it well. However IBM had been going for many years then so HAL was areference to IBM and not the other way round. However Arthur C Clark who wrote the original always claimed it was a coincidence.

 

[JANR]

IBM came before HAL. so Arthur Clarke actually did it as a humorous reference to IBM, which you obviously know

HAL did stand for something - Heuristic something/Human something - I forget which - I've read The Sentinel, but never watched 2001 all through.

I thought IBM was Its Better Manually
or even Itsy Bitsy Machines

From IMDB:

Incrementing each letter of "HAL" gives you "IBM". Arthur C. Clarke (co-screenwriter) claimed this was unintentional, and if he had noticed it before it was too late, he would have changed it. HAL stands for Heuristic Algorithmic Computer.

JR