Search results

I've spent hours on this , and it's close but no cigar. I downloaded a database called wiarotate.accdb I thought it was from here, but it's in German, and there's no information about the source. I've included it here for interest. It uses the WIA library. The utility reads the exif data from...

Regarding this "New" Outlook. Is "New" Outlook available now as an O365 option? If so, do we need to advise clients not to install this option, as it will prevent Access or Excel being able to automate emails? Would we know an O365 update is going to install "New" Outlook? Is it reversible?

I thought I was going off topic with @isladogs thread about the Access conference, so I have added a new one. What I was trying to do was using an Access rich text textbox to become the HTML body of an email. So a function that produces plaintext from a formatted text box, doesn't really...

I am trying to send emails in VBA by using a gmail account, rather than my default account. I am using code to loop round my email accounts, but it doesn't display any of the 3 gmail accounts I have added to my outlook account. It finds 5 POP accounts and an M/S Exchange Account, but it...

I have an excel file with addresses including new lines that are respected in the original excel file. If I import the file to a new table in Access (I am using A2003), the address stores this, with chr(13) chr(10) as line feeds. 2 Banana Road Village Leicester Leicestershire LE4 1BA but it...

I want to be able to enter a string in a form, and have to used as a criteria in a query to include multiple options. So, if have a query that checks for some matching records, I want to be able to use either in or like to make it easy for the user to vary the query at run time. I can do a...

I converted a complex mdb to an accdb and it produced these references. As a result, all references to DAO objects started to fail, so I presume this order of references uses ADO before DAO. I have changed all the declarations from say dim db as database to dim db as DAO.database, and it now...

I just wondered whether anyone builds in error-handling for catastrophic errors such as a Network Service being interrupted, showing as an unusual negative error number. Would that have to added as a form error in every form? The only comparable error I can imagine with a normally working...

I am really stuck on this I have an order form with a subform showing the order lines. I added conditional formatting today to change the presentation of an unbound empty text box, to provide a highlighted backcolor in some cases. Because I want to control the activity of a delete function, I...

I just added an option to a database to load images from a folder and display them. It just displays the images - no zoom etc, or other manipulation, but one issue is that the orientation of the photo as stored in the image folder is not respected. I imagine it's displaying the way the photo was...

I am stuck on this point. Supposedly a GETPDF retrieves a PDF. What it actually retrieves is a string, and I am struggling to find the right way to process the string to then be able to save it as a viewable PDF. I tried changing it to an array of bytes, and tried to encode/decode/whatever to...

It's getting better all the while. The tug of war episode was terrific (episode 5?), and then came the marvellous marbles episode. (episode 6?)

I was just listening to a discussion on Radio 5 about dyslexia being unrecognized in schools. Is dyslexia real? I can't imagine anyone posting on AWF being dyslexic, any more than I can imagine us having trouble with arithmetic.

In the light of a thread that was started to ask about learning resources, I thought it would be useful if there was a single thread to identify useful new features in Access since A97 or maybe A2003. ie since mdb's became accdb's I was happy with A97, but moved to A2003 when A97 just became...

I am sure this has been covered before - anyway, a client 's database prepares invoices by printing the invoice detail on a subreport, linked by invoice number. Now, they want the lines on the subreport to be in date order, but try as I might, I can't get the subreport to sort in date order...

On a few occasions, I have seen tables where the primary key, and indeed other indexes had disappeared, leading to at best performance issues, and at worst table updates failing. There's no data loss as far as I can see. I am not sure if this might be caused by bugs such as the recent 3340...

I have had a couple of references to "locked records" preventing some DBS functions working correctly in a normal database. Simlar messages, but not idenitcal. Assuming all users have database options set to "No locks", are there any circumstances in which Access might still come across a...

I am trying to find a way to read access options settings. For instance, I want to make sure that access is set to "shared access", and "No record locks", and maybe some other things. I have been able to find the "record locking" by a bit of trial and error, but I can't find everything. Is...

The only thing I use sendkeys for is to send an {esc} key. (undo) I just tried it, and it failed "permisison denied - error 70" What should I do to undo an invalid entry in a control, in the control before update event. It's a legal entry but correctly rejected. This form happend to be...

Having spend a while on this, I can create and send an smtp message, and add atttachments. A2016 For some reason I am unable to declare set MyMessage as cdo.message I tried to add cdosys.dll, but it won't add it. However, I can late bind an object with set mymessage =...