Still talking about comparing two sets of equipment listings from two separate databases. I want to generate a query that will delete the records from one...
Sometimes I get an error message from Access that the output (delete)
query must be an updateable query to run. What I'd do is convert this
to a select query...
I have several ADO questions. I have been working on a project using bound datacontrols to connect to the database (ms Access). Due to the problems caused by...
OK, I've had time to review your idea, and I do think the way I did it
would be more flexible, only because you're not guessing at the number
and types of...
Make sure your including the name of the DataBase as a high level qualifier. Other than that are both DBs on the same server? you could write an interface that...
... Will Access automatically supply the Auto-Number field value if you supply the other values for that record ? Also, I thought that I read, or heard, or was...
Both tables were imported into Access from excel spreadsheets. The primary database is from the current system at work. I do not have any idea of what...
Thanks! Yes the normailization nazis would hate me -- although i suspect the number of actually empty tables would be minimal. since any properties that I...
Does anyone know if there is a way to put a background picture on the whole area of each tab in the SSTab Control and not just the tab part at the top? It...
Hi, I want to connect a MS Access 2000 Database with password set ( Open Exclusive ) with a DSN Connection using ADODC control in VB ( ADO and ODBC ) . Is it...
Can't you ad a picture box or a image box on the area below? ... From: "don clay" <donclay@...> To: <helpwithvb@yahoogroups.com> Sent: Monday, March...
natale
natale@...
Mar 2, 2004 1:31 am
11477
Hi Bruce, So, are you using the Auto-Num Field as a PK ? All The Best, Steve ... From: Neiger, Bruce D [mailto:Bruce.D.Neiger@...] Sent: Monday,...
Good morning all, I have a couple of questions concerning ADO. To begin with I previously received a goodly amount of help from all of you with a project I...
in a record set you can usually use .movenext or .moveprevious to go backward or forward in a ADO cursor. you would want make your connection within a...
natale
natale@...
Mar 2, 2004 4:07 am
11480
I have several ADO questions. I have been working on a project using bound datacontrols to connect to the database (ms Access). Due to the problems caused by...
The first questions concerns the autonumber fields used in the database used to generate the primary keys for the tables. I do not know how to increment the...
The two tables I am working with are bases on excel spreadsheets imported into Access. The two actual databases in in uncompatable formats and I do not have...
Hi, I am new to VB. Can you tell me the steps to create a user defined function in VB. (simple one).. Regards, natale <natale@...> wrote: in a record...
Maybe I did not answer that correctly. Here are the Steps: 1) What do I need to do ? ( add two numbers ) 2) What Kind of Numbers ? ( Long Data Types ) ...
Hi, Iam a new Member of this group. I need help in doing my project in a project where i have to send e-with attachment. Can anybody help me in this subject...
Also, I thought that I read, or heard, or was told,
that using auto-number fields as PKs was not a good idea.
But I could be wrong. You're not wrong. It;s...
PS. I'm not addressing the ADO question because I've been stuck in Access 97 land for the last several years and thus been using DAO. I expect as I try to...
*sighs* Well, I can tell you that it is possible to connect a client
program on a workstation with an access database on a file server (LAN)
supplying the...
Hi Brian, This morning I see both of your e-mails in my Inbox. This e-mail, and the e-mail that you had originally sent to the list. Maybe it was all the...
MessageHello Laurie, I find your reasoning in respect of the uses of Primary keys interesting. I've not seen it defined quite like that before. I've created...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
