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...

Yes. I know but this shows me the business day and not the number of business days that have passed during the month. <br><br>I should have said how many weekdays in the month! Sorry.<br><br>So you would calc the the number of weeks that have passed in the month.(ie from the total in the year...

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

DougP<br><br>Thanks. <br>Its works (ie calls the functions inside the shell.dll) my only problem now is that I have no Microsoft email software (lotus Notes v4.6 on NT4 with Access97). <br><br>lotus Notes v4.6 is MAPI compatiable.<br><br>My problem now is an error mesage <br>(title)Problem with...

DougP<br><br>Thanks for this!<br>I can't find any info on the ShellExecute command. I can't get this to work as it is asking me to define the &quot;SW_SHOWNORMAL&quot;<br><br>Can you please explain the difference between shell and shellexecute?<br><br>Also what does SW_SHOWNORMAL and how can I...

I believe you may have duplicated entires in the related fields of either the [instrument index] or [ * pressure gauge] tables. When you try and relate two tables where one has say two records in the related field. Access doesn't know which duplicated record to relate the look up record with. So...

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 appending the results from a table to the another and it appended the results 4 times.

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 ?????

Doug<br><br>My .MDE file produced a different result from my backup database!!!!<br>Someone warned that this may happen. I append the same record 4 times instead of just once.<br><br>WHY? <br>I now have a huge problem and lots of apologies to make.<br>Thanks

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...

On Error GoTo Import_Holdings_Err<br>TokyoHoldings = InputBox(&quot;Holdings Filename&quot;, , &quot;Holdings file name don't inlc .csv&quot;)<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>DoCmd.TransferText 0, &quot;GSMAC&quot;, &quot;oldTokyomGSMAC&quot;, FileLocs &...

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...

DougP, Its ok thanks. There are asset identifiers that use combos of numbers and letters. If the asset id has all numbers then the zeros infront of it drop off. But this is only when one file is used in excel (as Excel thinks its a number). The other file is sourced elsewhere and so the asst id...

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...

Thanks thats a good idea. &lt;why didn't I think of that?&gt;

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

I have no idea!

Sorry: I should be useing the CreateQueryDef( ) Instead of the Openrecordset() I forgot the diff b/w an action and non action QQRY Thanks a lot for your help! Davo