Search results for query: *

...out is that I cant have two tables in a single query and be able to update them. Here's the test query that i'm running: SELECT [Report History 2].*, LCM.* FROM LCM INNER JOIN [Report History 2] ON LCM.[FILE #] = [Report History 2].[FILE #]; This is an inherited mess and i'm trying to avoid...

I have a database i'm trying to link against an SQL Express 2005 backend via ODBC. The tables show up fine, I can access/edit/write/update all the tables fine. The problem i'm having is when I run a query or bound form I cant make any changes. No new form button, no ability to edit. I cant help...

I've set-up a System DSN, and am able to connect to my SQL Server at the office from the internet on port 2433. How do I put sql.mydomain.com:2433 into ADP so that it'll connect across the internet to my SQL Server? Thanks...

Never mind... I answered my own question 5-minutes after I posted that... solution ended up being =Trim("*" & Format$([key], "00000") & "*") Works like a Charm :)

...just 1... makes all the barcodes the same relative length... anyone know how I can do this? Keep in mind I have to take the Actual number and add a * at the start and end, so if I have 00001, I have to make the barcode format it as *00001*, otherwise it wont scan correctly... Thanks in advance :)

Does anyone have any other approaches to accomplish what i'm trying to do? Maybe there's a better/simpler way that i'm just not seeing. Thanks...

My trial balance is off, and I cant locate any error's on either side of it. I think it's a problem with the data files themselves... any idea what integrity checks I should run to correct this? Data Verifacation does nothing...

The machine name is passing correctly out of the function, but the query is still not executing properly...

I have a delete query that is called by a VBA ADODB code passing a single parameter to the query for filtering... when I try to run the query through code, I get no errors, but the query does not execute right, however, when I double-click the query, and type in the parameter info, the query...

Anyone else have any ideas why this code isn't working?

Same end result, it does not delete the appropriate records...

I have a delete query that is called by a VBA ADODB code passing a single parameter to the query for filtering... when I try to run the query through code, I get no errors, but the query does not execute right, however, when I double-click the query, and type in the parameter info, the query...

I have a list box that populates serial numbers for motors listed in a table... how do I add a value to the listbox called <New> which I can parse out in code to prompt the user to enter a new serial #?

I want to set-up groups for my Database, and let certain login's be members of certain groups based upon what I want to allow them to do... My problem is this... How do I check to see if the login is a member of a certain group on SQL? I'm using SQL Login, not NT Domain Auth BTW as well. Thanks....

Kewl :) Now I can let SQL remember what the query does for me... LOL

Is it possible to add notes to the Queries in SQL, similar to how in VB you can pre-fix notes with a ' and they will be ignored by the parser... I'm trying to write down what each query does in my database so I dont hafta rely on a text-file on my desktop to remind me (incase I loose my...

Worked like a charm... thanks for the patience :)

I have two tables, one tables contains updated values, that I want to set in another table... so say the field tbltemp.Vendor is a field that i've updated my value in, I want to set the value of tblItemParts.Vendor equal to tblTemp.Vendor... see what I mean?

basically it's part of a variable called "strsql" which would be the final version of the SQL String (after all the concantate (sp) and such)... all i'm trying to do is set the fields from the static table = the fields from a temp table...

I have the following update query that is from my JetSQL Access DB, and i'm trying to port it over to ADP, and cant get it to run... any ideas? or am I just blatantly missing something? UPDATE tblTemp INNER JOIN tblBuildParts ON tblTemp.ForeignKey = tblBuildParts.Key SET...