toolbox with a
(on a side note, not part of the story i think a english teacher would have a heart attack after seeing this, this is one huge run on scentence ^_^)
after the append, it'll report x many records werent added because of indexing errors or something like that... IF the tables have unique ID's and it's set as a key field. This is asuming one person has the same ID in both tables too.
Ill see what i can do, it's all controlled by novel currently, so i may be out of luck.
I would use SQL server, but i have no server, currently hosting on my office machine.
*sigh* if only i could get IIS to run in my user ^_^
If you mean your looking for an API then you can either
1) Search google for the official API
2) Use VBA's built in Object Browser
3) Read tutorials and learn it that way.
Well, im using A2K, and i had no trouble: check out what i got:
(i resized all the blank cols to width 0 so it would all fit (sorta))
I just followed the questions it asked me.
Im not quite sure what you mean, and ive never heard of CDO but to the best of my knowledge:
ADO stands for Active Data Objects
DAO stands for Data Access Object(s) (cannot remember if the s is on there)
ADO actually is used for just about anything.. things like ActiveX and COM should be part...
Say you have a combo box called:
cmbMyCombo
and you want "MyItem1" to change the value of the text box txtMyText to 2.7 then you BUILD an EVENT on the "After Update" event as such:
If cmbMyCombo.Value = "MyItem1" Then
txtMyText = 2.7
End If
Im sure you can figure out the rest from there.
Here's the background:
I've got a question, ive developed a split database here for a virtual tour project. It allows the vets here at the plant to sit down and enter in information on all the equipment in the plant (aka. populate my database).
To facilitate a multiple computer environment...
Over the last nine years that ive worked with windows i've noticed it has a tendency on occasion to lock files. What i mean is, even though you've re-booted/closed everything and so on, some files cannot be deleted because windows thinks they are in use. I've noticed A similar phenominon (sp?)...