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...
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 :)
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....
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.