Search results for query: *

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

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

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

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

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

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

I have a data entry form... in it I have a hidden field called "Computer" that is supposed to be the computer the data was entered from... I have a function called "MachineName" that returns the name of the computer... how do I get it, so that when someone enters new information, the field...

I'm custom-writing a Accounting/Manufacturing/Shipping software suite for the company I work for, and i'm aware other large software firms like Macola that do this... In your opinions, would an ADP on top of SQL be able to keep up with something of this scope? It'll be used by about...

I exported a table from MS Access as an Excel file, imported it as a temp-table into SQL2000, however, when I run the query to append the data to the proper fields in the Final Table, it only does the first 10,000-records... I know I hafta be missing something here, any ideas? The 10-K records...

I have a query that shows items from one table, and related them to an Order # from another field... the problem is this... In the Item database, I use a field called "Status" which contains a numerical value... it's a key... so something that has a key of 1 for instance, is considered to be a...

I have a query that shows items from one table, and related them to an Order # from another field... the problem is this... In the Item database, I use a field called "Status" which contains a numerical value... it's a key... so something that has a key of 1 for instance, is considered to be a...

I have a report that I use to tell me locations of items... It relates the sales table to items I have in production... when I run the following SQL, I get a &quot;No Current Record&quot; error... if I disable the grouping, I get the correct output, but without a history table returning the last...

I have a Master Inventory report, sub-divided into 9 different departments, with itemized inventory... some departments currently have nothing in their inventory... in the footer of the subform itself, I created a text-box named &quot;ExtSum&quot; and I was able to use this statement to show 0...

I have a Drop-Down Combo Box that lists components on an Assembly for my Production Parts Guy, I want to be able to have the very first line on the drop-down box say something like <New> or <None>, but I cant figure out how to add that in the Query... If anyone can help, i'd appreciate it...

I have subforms that I use to list various components needed for an assembly in production. What i'd like to do is put line numbers on each line, so that way you can tell someone to look at line 7 on assembly ABC123... However, I cant figure out how to make it display line numbers, I tried using...

I am doing an order-entry system for my boat shop... All my orders are a 5-digit number (like 12345)... all my warranty's are pre-fixed with a WC... is there a way I can auto-generate the next available Warranty Number? IE, If the last Warranty Number is WC10234, the next available number would...