Search results

Just for the sake of others, I never did solve this, and I confirm this is simply an access bug. If you write any perfectly working dlookup then use browseto command, you will get a rte. Either can work separately without issue, but not together.

If your using an unbound form, you dont have to worry about multi user access issues. I take it this is for data entry? For example, when the user clicks your save/add button, then you will need to vba a new record and all data will be stored on the table at that instant. I used to have a...

Well, this bug is back again. Same thing happening, even though I havent touched the code from last time. Im beginning to think my version of Access is punishing me

Hi guys, Arnelgp, I changed all the dlookups to the format you suggested, and that has fixed it! thanks again.

Arnelgp, There are no errors when I do it my end, even with explicit. There is definitely something that is causing the browseTo to misbehave though, as if I comment that section out, the browseto works fine.

Thanks Arnelgp, I will try that and see if it helps. I have further isolated the issue. The code below always triggers the issue of breaking the browseto command. If Me.Check461 <> -1 Then 'want the email sent, box not ticked 'check if email is setup. If IsNull(DLookup("[EmailAddress]"...

Hi Arnelgp, no, im not using set in that manner, here is the preceding code Dim dbVideoCollection As Object Dim rstVideos As Object Dim fldEnumerator As Object Dim fldColumns As Object Set dbVideoCollection = CurrentDb Set rstVideos =...

There appears to be a weird issue with the browseto command. If I use it in isolation, it works as expected. If the same browseto comes after any vba that includes the use of "set", then it gives a runtime error 6054. my browseto code is as below: DoCmd.BrowseTo ObjectType:=acBrowseToForm, _...

You cant open any records unless you connect to a database, the error prompts in my first post happen when attempted to connect and refresh the dsnless connections. So doing anything with any records is not going to help, as the problem happens before that. So its a real catch 22.

I hear you Isaac. The issue was I was unable to find a way to ping a sql server which is completely locked down, eg all ports except the sql ports are closed, and I cant find a way to "ping" the sql port from ms access. The system I have developed doesnt connection on load, but when it does...

Hi Isaac, Its not what I need. I need a way to either check the backend is reachable before attempting to connect to it, or suppress/catch the connection error. My googling has concluded the error prompts are not hide-able, and within access I cant check the server status unless I connect to...

Thanks, Thats a different angle, I already have a vb.net updater, I could just add your ping check to that, and use it as a launcher instead of having a shortcut to the front end. It would then act as an updater, server status and launcher. Its a shame so much effort is needed just make...

My code works fine, so I can connect to my sql server and access the tables stored there. My issue is this, if for whatever reason (no internet or firewall issue etc), the front end cant connect to the backend, then you get a horrible timeout message, and then next screen is even worse. It...

It will work fine. I use Azure/Sql BE, sometimes odd things need to be changed, like if you have more than one "sort" then it can throw a RTE. Luckily though going to sql/azure is largely a smooth process with plenty of improvements in terms of speed/security/stability.

yes, I have been playing with it for hours. His method now also rte. I believe something in access or vba changed over the years that means the code is no longer correct. Dim v As Variant Dim b() As Byte Set v = Me.InkPicture6 b = Nz(Me.Signature.Value, "") ' b =...

Hi Db guy, Hope your well. The issue is that your displaying the ink picture in an image control. This I can do. But I want to display the picture in an inkpicture control, and then I can draw ontop of the picture. This is the problem. I cant see to find a inkpicture.backgroundpicture type of...

Does anyone know how to load a background picture, and then have the ability to "draw" on it? Im thinking of using the inkpicture control, I can set it up to catch the drawing, but I cant seem to load a background image , any ideas? thanks in advance

Yes, I just wanted to save signatures. Which I think I have a good implementation now thanks to this thread. The method of "retrieving" in DBGuy's example is outputting the file and then loading that image the control. The issue I have with DBguys method, is potentially losing control of the...

Hi Dbguy, The left hand side "display signature using an image file" the signature box is blank. On the right it works, the one using an attachment field. Also, im not actually able to sign anything.... Edit : I can, it seems to work, just needed to make sure it was in a trusted folder , my...

Hi Colin, Thanks again for this. However, I did find an annoying and weird bug. On the signature capture, to retrieve, it works on the first click, but then throws a RTE error on subsquent attempts to retrieve : you entered an expression that has an invalid reference to the property |. I have...