Search results for query: *

I have figured it out.. I used Alias:Val(field_name) in the make table query and this inserted the alias in the new table as a number rather than an autonumber.. go -figure....

I am running a make table query and the primary key of one of the source tables is a number. I want this number in my new table. The make table query creates this field as an Auto number and so fails to add the records to the table. Is there are way to force the make table query to create a...

Thank you..this is exactly what I was looking for.. Worked like a charm

I am converting a list of user entered varchar values that should be numeric. I want to convert the varchar to numeric and I will then insert into a numeric field. Problem occurs if user enters a screwy value like 185 185. The SQL conversion of select statement will error "Msg 8114, Level 16...

If part of the problem is that you cannot install the DVD drivers in device manager and you get a Microsoft error # ?, then google that error message. There is a known bug that is fixed by modifying the registry. The bug is that the DVD is not recognized although everything seems to be working...

I am running a vendor app that uses an Front end hitting an Access.mdb middle to get to the SQL backend. The problem is that when using the front end in certain conitions, the cpu usage will jump to 70-100% and that freezes everthing. After about 3-5 minutes CPU usage goes back down and the...