Search results for query: *

When I check a checkbox in one table, I would like to have a checkbox in another table automatically checked.  The first table, Docs in Progress, has the optional field Library Number and the checkbox Revision.  The second table, Library Index has the primary key field...

Hi.<br><br>Is there anyway Access97 can count the number of business days?<br><br>Thanks.<br>Davo

Hi,<br>I am trying to send an email with Lotus Notes from my Access 97 app (on NT4). It will not&nbsp;&nbsp;work however. The message is '2046' sendobj isn't available now.<br>1.read only db (not possible)<br>2.type of action applied isn't in the active view.<br>Does Notes need the Mapivim.dll...

I was warned about this. An append query has appended the results 4 times instead of just once in the mde DB. The MDB back is fine.<br><br>????? WHY ?????

How can users download file from my web site using JavaScript.<br><br>I know about fileupload but what is the one for download?<br><br>Do you just do a HREF to the FTP server? If so how will that start the file download process?

Hi I am new to JavaScript (know SQL, VBA well).<br><br>Another office is going to put files on their web page for my office (in another country).<br><br>I would like js to download the files and save them to our Network automatically (activated by the day of the month).<br><br>Is it possible? or...

I am trying to transfer text files into my Access97 DB (on NT 4.0) with VBA. But it does not always work. I mean if it does I have to either do it manually (works always) or step through the macro.<br><br>Would it be due to the netork traffic?<br><br>I start the transfer and then the Task...

I have written a lot of code around a filed name. I realised after some testing that the data needs slight modification before it can be used.<br><br>HOW can I change a field name in VBA?<br><br>I could change the import spec and then rewrite a couple of queried but I would prefer to use VBA to...

Hi,<br><br>I have a form with data I want to display as <br>&quot;Standard&quot;. I know there an SQL keyword &quot;CCur &quot; that displays a field as Currency but ...<br><br>is there an MS Jet SQL keyword for the standard format?<br><br>Cheers.<br>Davo

What is the code for a VBA macro that gets the users name when the Access DB is on Win NT4.0?<br><br>This has been answered before I have lost the thread.<br><br>Sorry.

I would like a macro to use the results from a select query to make a table.<br><br>I have a an IIF(a,1,0) in the select QRY. I want to call the results of this select QRY to make a new table. How can I code this in VB?<br><br>Thanks

Hi,<br><br>I am trying to change a value in a record if one of two conditions holds true. I can use a&nbsp;&nbsp;select query to get this to work yet not an update query.<br><br>Any suggestions? Here is the code that works for the select query.<br><br>SELECT trans.TRANSTYPE...

Hi,<br><br>At the moment I am using an Access Database.&nbsp;&nbsp;&nbsp;I will be changing however to an Oracle db server and would like a good reference manual for coding Oracle. Points I would like to cover.<br>1. Working with a VB6 API.<br>2. Tips with SQL.<br>3. Connecting the DB to the...

Hi,<br><br>I have a table where there are many records for one transaction.If I only want one record of the transaction how can I delete all but one record? I am trying to use an SQL solution like this:<br><br>WHERE (((Transactions.TransID) In (select transid from Transactions as tmp group by...

I can't get this line of code to work. <br><br>table net_download has<br>fields onloan and settleloc<br><br>Table sdave has<br>fields loc<br><br>DoCmd.RunSQL &quot;update net_download set onloan =&nbsp;&nbsp;table![sdave]![loc] WHERE settleloc = tables![sdave]![loc];&quot;<br><br>When I run this...

I am trying to create an update query with SQL inside a VBA module. I don't know how to <br>1. relate fields in two different tables.<br>2. update a field in one of the tables if the relationship above holds.<br><br><br>Could you please send me an example? <br><br>Thanks.<br>dfb