Inserting new record problem
Fri, 28 Nov 2008 07:37:33 -0800
Hello
I've three tables: Document, Contact and DocumentContact.
On the first one rest document info like subject, date, and so on.
On the second there are several info related to Contact (name, address, etc)
The third one is a relation table that has two columns: DocumentId and
ContactId.
So i can associat ...
|
Import csv file to Access 2003 table
Fri, 28 Nov 2008 06:59:01 -0800
I am trying to import a 2-column csv (server_data.csv) file into an Access
table.
The CSV holds a server name and it's IP address
e.g.
server001,10.136.193.226
server002,10.136.193.227
I am using the following code:
DoCmd.TransferText acImportDelim, , "RDP_ILO", "C:\server_data.csv", False
Curre ...
|
Scanning for new tables in a Back End (BE) database
Fri, 28 Nov 2008 06:55:01 -0800
Hi all,
Hope you had a nice Thanks Giving. I want to ask is there any way to scan a
back end database for any new tables added? Currently we have a Access 2003
back end sitting on a server. The Front End (FE) is distributed to various
users.
Sometimes, a user through the FE could add a new table to t ...
|
Error calling a function in SQL Server
Fri, 28 Nov 2008 05:20:27 -0800
Hi there,
Iâ??m doing a form using two ComboBoxes the second depends on the first. The
first let me select a worker, once I select the worker then the second is
filled with some data that I get from a stored procedure. Everything is
working very well but now I need to convert the stored procedure to a
fun ...
|
Happy Thanksgiving Everyone
Thu, 27 Nov 2008 16:01:10 -0500
I know many of you are not from the United States, and therefore do not
celebrate Thanksgiving as we do. But I'm sure you all have something to be
thankful for.
I know one of my many blessings is the assistance that the MVPs and the
other experienced Access users provide on this and many other forums. Tha ...
|
New record in bound form
Thu, 27 Nov 2008 10:58:03 -0800
Hello
i have a main form say Customers, and a subform in it say Address.
Every customer can have several addresses.
How can I navigate sub form Address to a new record?
using DoCmd.GoToRecord , , acNewRec in subform code seems to go to a new
record in main form, not address form.
Is this possible?
In my ...
|
adding pages in Tab Control causes crash
Thu, 27 Nov 2008 07:50:12 -0800
Access 2003,
Pages or tabs are added to an existing Tab Control on an existing using VBA.
The initial tab control contains a variable number of pages or tabs. Each
page has a single subform control. The number of added pages is based on a
variable length list. The form containing the tab control is opened i ...
|
|
|
record locking
Thu, 27 Nov 2008 07:06:02 -0800
I looked at the responces to record locking, but all I need to do is check to
see if a record as been locked by another user. Thier must be away to check
to see if the current record is locked, then I can handle it. I will be
running the database with runtime access 2007. At the present time if I open
a reco ...
|
Creating new records in primary and foreign tables
Thu, 27 Nov 2008 01:42:13 -0800
Hi all
I have some code which creates records in a table based on user data input
on a form in unbound text boxes. I now need to amend the routine to create
foreign records in a different table at the same time. The ItineraryID is an
autonumber, this is the link between the two tables - how would I be able ...
|
Validate Data and Display MsgBox
Thu, 27 Nov 2008 09:19:11 GMT
Need help to figure out how I can get this to work. I know it's probably
very simple and I've come close several times but it's just not good enough.
I have 2 Tables. One is Members and the other is Enrollments. Both have the
common field of MemberID. I have a form based off the Enrollments table and
need ...
|
