Search results

  1. B

    Adding Criteria to a Calculated Expression in a query dramatically slows performance

    I have a query that runs normally in a fraction of a second. One of the (many) fields is DaysWaiting: Date()-DateValue(FirstBookedDogs([ID])) Admittedly quite complicated but when run, say returns 10 records in 1/4 of a second. So all the DaysWaiting numbers are show instantly so I assume...
  2. B

    Add index to existing table - is it auto indexed

    Hi, I am adding index's to a few fields in a tables that already exists & has done so for a long time, perhaps 5000 records They are date fields, few questions. 1) Is the existing data automatically indexed once I change the setting in the table, I only say as when I added them & closed the...
  3. B

    VBA to download email from account

    Hi, Expensive option now it seems & quite complex but I have software from https://www.chilkatsoft.com/. There may be others with similar ActiveX. I am an OK programmer, certainly no expert by a long shot, just copy others & examples. I have it pretty much running a full email program, I do...
  4. B

    ONLY 1 of many Win 10 PC crashes on acCmdPaste

    Hi, I think I have found out what is causing the problems Why & why now I am not too sure, perhaps an office update. Thank fully it started error'ing on my main PC giving me much better testing. It is the Office clipboard! I don't use or open, I only ever use Ctrl C & Ctrl P. If I "clear...
  5. B

    HTML (RTF) Keep format but remove headings <html> etc

    Hi, I use html & rtf in forms for emailing via access however I create my own emails and then add them in front of the existing incoming email. Problem is the incoming email often has e.g. <!doctype html> <html xmlns="http://www.w3.org/1999/xhtml" dir="ltr" lang="en-US"> <head> <title>Test bob...
  6. B

    Print pages in reverse order to preview order?

    Hi, Is there an easy ish way to view a report print preview in one order, ie 1 to 10 but when press the print button they come out 10 to 1, basically ready stacked in correct order. I like to view, page view & not report view, 1 to 10etc I also don't want to have toe close & press a different...
  7. B

    ONLY 1 of many Win 10 PC crashes on acCmdPaste

    Hi, thanks again for your replies, Had to give up for a while and just make sure I used the other PC's for this function for a time but want to revisit. The client setting were correct to included whole field, Had not changed from previous install. I know things could change from Win 8.1 to...
  8. B

    ONLY 1 of many Win 10 PC crashes on acCmdPaste

    Hi, Thanks for your replies, It is exactly the same code over 3 other PC's that has worked for years so really can't see it as coding issue. It is actually runtime but I will load a accdb & compile on that PC, just in case the references somehow got upset during the WIn 10 install, weird thou!
  9. B

    ONLY 1 of many Win 10 PC crashes on acCmdPaste

    Hi, I have 3 Windows 10 PC's running the same Access Database Just upgraded the 4th & last PC 8.1 to Windows 10. Upgrade fine, no problems. All other PC's work fine & have done so on the same code for years. This PC whilst old is pretty fast & better that a few laptops on 10. All same latest...
  10. B

    Find Duplicate Query asking for parameters for Form

    SOLVED. Whilst typing got me thinking, I tried changing the recordsource to the Query by VBA & it worked Not sure why applyfilter query does not but not going to waste any more time. thanks anyway, I really should have thought of that early on.
  11. B

    Find Duplicate Query asking for parameters for Form

    Hi, Sorry you are right, I had gone back to this issue without thinking it through but seem to remember there is a standard query format that uses a 2nd copy of the same table to achieve something similar. I am trying to find out why it is asking for parameter or somehow stop it. It does not...
  12. B

    Find Duplicate Query asking for parameters for Form

    Hi Stand alone query is fine but if I try to Apply Filter to a form it asks for parameters. Have query below (prob to complex to see) but is basically a Find Duplicates query, mine finds if overlapping booking dates also. Typical find duplicate query has the same table twice with join. If I...
  13. B

    Any way to create a document to sign & return?

    Many thanks for your reply, I do manage to do what I want similar to Docusign with Adobe DC but as I say not fully automated & quite a lot of manual work, if it were only a few I needed to do a day that would have been fine but doing 20 or so is laborious. How do you use VBA to manipulate PDF...
  14. B

    Any way to create a document to sign & return?

    Hi, I am trying to create a document to email that can be electronically signed (does not have to be legally binding, even just typing their name) and then returned to me. I can do everything but cannot easily get a dynamic form than they can type or even draw a signature & email back. It is...
  15. B

    Is objStream.ReadLine always in correct order?

    Hi, Just wanted to check before I got to lengths programming (as testing is not 100% & annomolies can show up at any time) Is using the FileSystemObject & .Readline 100% sure to read line by line in the order of the file. In my case a .csv TransferText is not guaranteed as far as I can tell...
  16. B

    Min & Max from Recordsetclone? no underlying table or query

    Hi, Perhaps it is not , I am no expert but guessed that once the forms is filtered by the underlying query, the resulting recordsetclone did not need to go through all the data again. e.g. table with 50,000 records The forms underlying query, filters the list down to 20 with the name e.g...
  17. B

    Min & Max from Recordsetclone? no underlying table or query

    Hi, thanks for your reply, not quite sure how this helps, as I say trying to avoid doing it with a query If I went the query root it would be easy to make a ordinary query that results in the Max. I filter this form so not the same as the original query. Also the querying of the form is...
  18. B

    Min & Max from Recordsetclone? no underlying table or query

    Hi, Perhaps a rare (or stupid request) as cannot find anyone else asking. Trying to find a way to get Min & Max values of a field on a continuous form that is not necessarily base on a query. Seemed simple & quickest to me to use recordsetclone somehow but does not seem a way. I have wanted...
  19. B

    Webcontrol on subform prevents textbox typing on main form

    Hi, really confused by this I cannot type anything into a newly created unbound textbox on the main form. I have a main form & a subform. Mainform has a simple table as source. Not tabular, single records. The subform just has a webcontrol to view .pdf. There is no link between them i.e no...
  20. B

    RichText Memo adds a space to beginning of line

    Hi, That is interesting that you do not get a space, <div></div> definitely give me a space (as well as the line) I have latest Office 365, a hundred times check the table source is correct & any controls are Rich Text. I do want a blank line hence by replacement with <br> as if I use...
Back
Top Bottom