Summary: I am building a database in Access 2007. 2 of my forms are "Salesman" and "Client". 1 salesman has many clients but 1 client can only have one sale...
Summary: "A problem occurred while microsoft access was communicating with the OLE server or activex control." Access returns this error on startup and repeat...
Summary: I am updating two fields in a sql server DB from a VB6 application. field2 updates fine but field1 is not updating at all. I tried the query in anal...
Summary: Hi, in my Microsoft Access database, I have two tables 'Companies' and Employees' with One2Many ralationship. Each company has link to many employee r...
Summary: I am trying to update a field in a sql server table. There are times when I may get multiple records returned in which case they will all need to be ...
Summary: Hi all, I am using a sql compact database to update my records. I know the syntax to update one row and colums but is there a way/syntax to use the up...
Summary: Are you talking about a web application? If so, you'll have to do your updating in the session close (if you're using ASP or JSP), which will happen a...
Summary: Just wondering. How long should it take for an SQL server, 2g ram, 2.2Ghz intel xeon, to update 1.2 Million records? (eg update `customers` set `site`...
Summary: The information in a record will be updated if it's changed. As for the additional field on the form, add another field to your table and add that fie...
Summary: I'm using MS Access trying to create an update query that shifts the data down by 1 row. Example: field1 data 1 data. 2 data(3) UPDATE DataTable SET...
Summary: I am creating a form to track information for numerous construction jobs. The form has about 20 fields. One of the fields I have created is a "Last ...
Summary: Hello, here is my short script in sql server 2000: [b]Create Table #tmp(ID int,y_val char(30),...) Insert Into #tmp exec stored_procedure[/b] now my #...
Summary: You may try doing a system restore via Start>All Programs>Accessories>System Tools>System Restore. Jump back to a date prior to the issue and see if t...
Summary: Hey Everyone, I'm currently trying to setup an online store, my wholesaler provides all their product info via .CSV file. The file from my wholsaler ...
Summary: First I would say this is something you should not do. What you have is a one to many relationship. One address with many contacts. If you have 2 t...
Summary: Hello, I'm wondering if we can do math fraction operations and also store in columns, by keeping it always in fractions format (dividend/divisor) incl...
Summary: Hello, I am Software Development Intern at a small company. We run Microsoft SQL Server 2000 on Win2k. One of our database tables was recently destroy...
Summary: i am a non-professional user of MS Access for the last 8 years and through playing, eperimenting and searching i can say that have become pretty good ...
Summary: I have a rating script that works great. What I am tring to do, is each time a user votes, I will add some voting expierence to there account. This co...
Summary: yeah jennifer, i'm very sure of what i'm saying. for instance when i browse to this folder via windows explorer i see additional files added there - i...
Summary: Scenario: Two different location connect by a dedicated VPN line with 512K bit bandwidth. Both site running a MS SQL server on a SBS server. Both site...
Summary: I have created a small access database with a form interface and would like to be able to update totals on a daily basis with as little effort as poss...
Summary: Hi, I am currently working with a third party vendor. I want to build a databse which can be updated by the vendor at his premises. Can I see the form...
Summary: By doing that, 1. create a lookup table with 2 columuns new and old 2. load the spreadsheet into the lookup table by using SQLloader 3. write PL/SQL ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
