Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Kumba1

    Access 2003 w/ SQL Express 2005

    Fixed one problem, and found another. Went through tables and added 0 as the default value for all bit fields. That fixed the problem of not being to update a table through a query/form. What I then found out is that I cant have two tables in a single query and be able to update them. Here's...
  2. Kumba1

    Access 2003 w/ SQL Express 2005

    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...
  3. Kumba1

    Connection String to put in to connect to SQL Server

    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...
  4. Kumba1

    Barcode with filler digits?

    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 :)
  5. Kumba1

    Barcode with filler digits?

    My Parts Room Inventory has barcodes on the label that correspond to the text-based part number (I.E. Part # 123abc-e)... This creates an extremely long barcode when you get into 12-15 digit numbers... so the idea I have is to use the Primary Key for that part number record to generate the...
  6. Kumba1

    Running a Delete Parameter Query from VBA

    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...
  7. Kumba1

    My trial balance is off, and I cant find the discrepency

    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...
  8. Kumba1

    Running a Delete Parameter Query from VBA

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

    Running a Delete Parameter Query from VBA

    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...
  10. Kumba1

    Delete Query in ADP Not Deleting through Code...

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

    Delete Query in ADP Not Deleting through Code...

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

    Delete Query in ADP Not Deleting through Code...

    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...
  13. Kumba1

    Adding a <New> line to a list box?

    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 #?
  14. Kumba1

    See if a user is a member of a group?

    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....
  15. Kumba1

    Can I add Notes to Procedures in SQL?

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

    Can I add Notes to Procedures in SQL?

    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...
  17. Kumba1

    Modifying an Update Query from JetSQL to ADP???

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

    Modifying an Update Query from JetSQL to ADP???

    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?
  19. Kumba1

    Modifying an Update Query from JetSQL to ADP???

    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...
  20. Kumba1

    Modifying an Update Query from JetSQL to ADP???

    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...

Part and Inventory Search

Back
Top