Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: davo
  • Order by date
  1. davo

    Check or Clear a Checkbox Automatically

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

    Business Day of the Month

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

    Business Day of the Month

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

    E mail attachments in Access

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

    E mail attachments in Access

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

    Duplicate records problem

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

    Sending a Table with sendobject

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

    .MDE results diff from .MDB

    I was appending the results from a table to the another and it appended the results 4 times.
  9. davo

    .MDE results diff from .MDB

    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 ?????
  10. davo

    MDE compile error in hidden module

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

    Download files from my website.

    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?
  12. davo

    Downloading files with JavaScript

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

    Transfertext - not wroking

    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 &...
  14. davo

    Transfertext - not wroking

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

    Change FieldNames

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

    Change FieldNames

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

    MS Jet SQL format keyword for Standard

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

    MS Jet SQL format keyword for Standard

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

    A Good Oracle reference book

    I have no idea!
  20. davo

    A macro that Calls Results of a select QRY into an update QRY.

    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

Part and Inventory Search

Back
Top