hog

Nope, that dont work either I get an error message to do with the As statment and to do with one of the )

I am trying to use the query builder to concatenate an autonumber field with a date field so the are displayed in a combo box. SELECT [log_no] & " " & [dated] AS logno FROM tblLogNumbers; works fine in Access, but not in VS? I have tried many attempts including; SELECT str(log_no) + ' ' + str(dated AS logno FROM tblLogNumbers; which all fail:(

Well I just got their greatest hits for Father's Day cos I like some but not all their music. But the one which just blows my mind and always has is Lullaby :rolleyes: :rolleyes: :rolleyes:

Ah samsmithnz I needed a laugh today...lol thnx m8 :)

LOL you can please some of the people all of the time and you can please all of the people some of the time, but you can please all the people all the time ;)

Well I got a shock! Thought I was on the wrong site:( Haven't been here for a while as work is going crazy. I have to say I preferred the old look, but as with everthing we will soon get used to this look:-\ PS I really don't like the pop up context help when you move the mouse over a post in the listings :mad: Keeps getting in the way :mad: :mad:

Well my view is that one day something big will happen that will make computers and basically anything with a chip in it useless and we shall all be forced back into Victorian times. Just think about it, the world as we know it would just end and chaos would rule supreme until such time that society evolved to deal with the new way of life. Every day on my way to work the traffic is worse, the way people drive is getting worse all due to impatience and being ruled by time! Yes I know it would be absolutely terrible and life would be hard but we are on a road where something has got to give. We just can't keep on making things faster and faster. Oh woe is me.....it's Friday, I'm tired of the rat race........I want to live out in the wild like that Grizzly Adams fellow...... :(

:)

SELECT addr1 + addr2 As Address

Mmm very interesting, but not sure how to take it, or whether lil ole me would worry about it, supose the big boys would tho. I thought this a weird comment to make tho by ASP.NET Pro Especially the being too cheap.. This argument could be used for anything from a £14 piece of software to VS.NET 2003! Like I'm only using it cos work bought it for me. If I was Joe Bloggs on my own, I probably not have any version of VS.NET. So if I was never going to buy a copy, MS haven't lost anything, so no harm in having a pirate copy then...apart from the morality of it of course!

Have u checked the NVidia site for any issues?

I don't know how to do this, but would be interested in how it would be done. Could be handy:)

lol:)

Are you talking about IE? If so go to Tools->Internet Options->Custom and scroll down there you will see things like Prompt against ActiveX, Scripts etc. But do you really wanna do this? I use BulletProofSoft Spyware Adware remover to clear the nasties of my laptop:)

You vcan do it this way; Dim proAnim8or As Process ' startup an anim8or session proAnim8or = New Process proAnim8or.StartInfo.FileName = Application.StartupPath & "\anim8or.exe" proAnim8or.Start() There is also a shell command, escapes me at the mo, which is a single line you execute with the file name to start DOH....he beat me to it :(

:)ThnX:) It was unknown to them that she was 8 years old, only that she was a newbie!

Kool I haven't seen this in years oh the memories:) ThnX I agree, I spent days playing Wolf3D for example! But going back further in time...ah PacMan on the Atari home console:D I lived, eat and slept it....

I have written a VB.NET app which uses an Access 2002 database on a server which is used by 6 users and no problems are experienced. I also have for that matter an Access97 server database used by 60+ for enquiry, not writing which has been in use since 1999 and no problems have ever been encounterd.

Have you thought about populating the combo box with the values from the file? This will restrict the user to pick only valid entries. If they want to add a new record then you can provide this fuctionality elsewhere, say with an Add New button?

OK, I have worked on times etc in an application here that calc user time spent on a given assembly run. First thing tho, why hve you quoted this bit of code? & "'" & strEmployee & "'" & ") rather than & strEmployee & ")" can you give me a bit more detail and I'll see what I can do:)

I think it has something to do with proportional fonts or something? This I think is where in a given font it spaces the letters evenly, W I for example. Not sure if thats a good explanation but I think it is close:)

This post is NOT I repeat NOT directed at any individual on this or any other forum! I am cool calm and collected, so hope this thread remains purely to incourage meaningful thought in all who read it. I remember the days at school where I and probably others would not raise a hand in class to say "I don't understand" to avoid the ridicule the teacher and to some extent my peers would inflict on me just because to them the particular topic was easy to undestand. I am now 40 and still this happens to me, I have no formal qualifications and yet but luck and hard work I am in a very good job writing programs for my employers and for fun that others just would not have a clue. My problem is similar I am sure to many, I can learn something and understand it, somethime quicker somethimes slower, in order to obtain the desired goal. But and this is the thing, if I don't use it I loose it. And come the time I need to do it again, I have to learn it all over again. A few examples: In 1993 I taught myself C++ and the required math to enter into the program the dimensions of any box and any size battery. The program calculated how many of the given batteries would fit in the box in the most efficient way possible. Not rocket science to many, but I did it all the same. If I wanted to do the same again now, I would have to learn it all again because I have forgot how to do it. In 1995 a turning point in my life I wrote SpaceInvaders in C++ and assembler. YES assembler! I taught myself how to write a keyboard interrupt handler to enbale faster user input response. This taught me a valuable lesson, I am not thick, I do not deserve to be ridiculed by others for not understanding things straight away. I have two brothers, one a senior system analyst the other a financial director who is a member of mensa and a rocket scientist in math. Neither have a clue how to write such programs, does that make them thick? On another forum a user was flamed for submitting a piece of work that others deemed to be basic and simple. It turned out this user was an 8 year old. I hope the flamers felt good inside. The user in question could have done what many would do, hide away and give up to avoid being humiliated again. But no she at 8 years old stood up for herself. But sadly others do not. There my ramblings are over, I do not want to incite a flame war, I just wanted to share these thoughts with everyone and to simple remind you all, every man woman and child on this planet are different and if help is asked for they should not be ridiculed no matter how simply the question. nuff said:)

Don't really follow your code C++ too long in the past:( But if I understand you right in VB I would do.... Dim strTableName As String = "AnyOldTable" Dim strSQL As String = "SELECT * FROM" & strTableName & ";"

The unique value is created by the database at the time that the record is written back to it, not before. Two records would not be created with the same value as the database controls this. If you have two users open the same record, then the first makes changes then writes it back when the second attempts to write their changes back the optimistic concurrency which you should have in place will inform the second user that they are unable to save their changes.

Here is a complete...OMG stab in the dark.. Is it something to do with the actual font being used? Try using courier new and see the result.