I am using an image to call an asp file with the "<a href" function. The file that is called does not read the text fields from the form at all. If I use a standard button object and vbscript (see below) it works.
<form name="frmLogin" method="post" action="submit">
<script language="vbscript">...
I have sOrderDate, sPromiseDate and sShipDate variables.
An order is placed on Thursday, and we promise to ship the product within two to three days from order, unless the promise date falls on Saturday or Sunday, then ship the following Monday.
sPromiseDate = DateAdd("d",3,sOrderDate)
If...
I need a little help with DateDiff. I am trying to find the next business day for shipping an order. The Order is placed on a Thursday and takes two days to pack before it can ship, but cannot go out on a Saturday or Sunday.
That's what I have done. I built two tables, one for common table names (with a binary for whether or not it is importable) and the other is a linked table for fields (with a compare binary for checking field values) and a transport field (for whether or not the data is to be transferred). All...
These two dbs are local to my computer and are nearly identical, which is where the problem arises. Out of nearly 1 million records, there may be 50,000 that contain variances. We are dealing with animal breeders, one trying to merge data from another to form a central DB as a repository. It's...
The DBs can't be linked. The code does the association and replication. The DBs are different versions of the same things. Cheap client won't upgrade. It will cost him more to have me do it this way...but oh well.
Why can't you set some Module variables lime m_sBudgetID, m_sStaffID, m_sFundNumber and m_dBalance for those values as you go along and use them in your queries?
Place in Modules.bas
Dim m_sBudgetID AS String
Dim m_sStaffID As String
Dim m_sFundNumber As String
Dim m_dBalance as Double
Hope...
Thanks ACEMAN...however I still have to retrieve linked records from associated tables by the old ID and then insert those into the target DB with the new corresponding ID. There is no shortcut...it is still code intensive. Thanks anyway.
Thanks Jerry. I am trying to import data from a similiar database and just append the records that I don't already have. The problem is the freinds database refers to records using the same autonumber index field, but the data could be totally different. The database was designed by my friend...
I need to import data from another MSAccess DB using VBA and ADO. The trouble I am having is keeping the autonumber ID field from erroring when trying to bring the same thing from the external db. Any ideas? Thanks
Try using the cols=X in the table statement:
<table cols=2>
Of course use the other parameters in your posting.
You have also named to objects with the name "sundry". All you need to do is refer to the radio object at it already has the record ID.
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.