Search results

  1. B

    Capture "Your network access was interrupted" so can close/exit more controlled

    Hi, I have a BE on a wired LAN. Very rare for interruption but power outage or just resetting a Switch/AP without remembering to close all FE (I have 4) give me the above error. I usually have to click 5 or 6 or more close or X on the window before access closes. It can of course happen from...
  2. B

    Can you have an array as multiple criteria. e.g. HAVING (TableX.Email=""" & EmailSearch & """);" EmailSearch has more than 1 value

    Hi, Hope title is not too confusing. EmailPasteTable is a list of emails I have been sent. I call this function from a form & elsewhere LatestEmailUse("JoeBloggs@hotmail.com") It shows that lastest time e.g. joebloggs@hotmail.com emailed. also how many times but not so important. I would...
  3. B

    Apostrophe ’ instead of ' in RFT, solution that took me ages to work out. rare problem but bugged me!

    I could not find this anywhere so perhaps a very rare situation & not one to cause issues but just in case someone has a similar problem. Tried many times over many months & just gave up. May be obvious to some/most but thought mention here. Trying to remove or correct apostrophes ' in RTF...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. B

    Bound field should be 25.7 but is 25.7000007629395

    Hi, Office 365 I suspect a bug or corruption but compacted & repaired, re imported form etc so wonder if something else Me!PairDiscount is fixed 0.00 field on Main form Me.Prices.Form!Pairing2Disc is fixed 0.00 field on subform both bound to different tables. they are defined as double in...
  15. B

    RichText Memo adds a space to beginning of line

    Hi, Office 365. Always had this issue but ignored but would like to find out why RTF Memo field If I type as below with just enter, no press of space or arrow 1 2 3 4 5 However, once record is updated by simply clicking on record selector, Moving to top and cursor down there is always a...
  16. B

    Anyway to access Back End on Windows 10 Password protected folder

    Windows 10 1803 Hi, I mostly want my PC password protected but would like a networked front end to link to just one folder/file without password. Everything I try either has full password requirements or not at all, even the public folder seems to work under the same all or nothing which...
  17. B

    TransferText - delay/check to ensure fully imported

    Hi, I have a 6 iCal files as a TEXT files with simply 1 field in each (see bottom) I import using transfer text as below. 6 different text files appended to one table, hence the looping On exactly the SAME text files, sometimes it works fine but mostly a few missed lines. Each Text file is...
  18. B

    Embed or Show Google Calendar Events

    Office 365 Hi, I would really like to be able to view google calendar events on a form, probably a schedule list of a few dates. Tried webbrowser control but lost of script errors but not persisted as not sure this would be quite right for me anyway. What does look ideal is embedded code...
  19. B

    Open Form with stLinkCriteria = "(Format([TimeGone],'dd/mm/yy')=" & Me!DateX

    Open Form with stLinkCriteria = "(Format([TimeGone],'dd/mm/yy')=" & Me!DateX Is there a way to open a form and manipulate the Table side date Basically I have a form & source table has the full date & time field Invoices TimeGone = DateX 26-07-2018 13:01:47 Invoices1 DateX = 26-07-2018 I was...
  20. B

    How to get JPG to fill image control (too small now)

    Hi, I have an Image control that gets it image from a simple text link (no html links) e.g. C:\images\picture1.jpg It loads & shows it OK but it is too small in the frame. perhaps 1/3 size. I have tried Zoom & stretch etc properties. Clip show the image to be huge, not sure why as it is a...
Top Bottom