Search results

Hi Everyone, Just to close the loop. I had tested it by renaming the file extension from .accdb to .accdr and opening on my dev machine. It did work in runtime mode fine on mine. I ended up paying the developer a bit extra and he made me a .msi that I simply ran to install and...

Thanks Gentlemen. Not sure what the problem was. I realized this morning after some coffee that the field I added was in a table that wasn't even part of this query. Honestly, I'm wondering if this was a silent bug, that hadn't shown itself yet in the 2 months I've had this code running...

Had a nice working database. Changed some code, and added one field to a table in the back end. Refreshed the table links. Now when my code tries to edit a recordset based on a query I have not touched, which was always updateable, it shouts the following error: Cannot update Database or...

I just commissioned the developer to build out a .msi, that will hopefully handle all the registration on our test machine, then our server to get it right.

Hi DBguy, Yes, the code is working fine on my dev machine (A2013), but when I run it on my test machine (A2013 runtime), it gives me the "ActiveX component cannot create object" error.

Ok, here is my calling code. This is working on my dev machine. Dim gc As GoogleCal Dim EventId As String Set gc = New GoogleCal MsgBox gc.GetInfo Set gc = Nothing Do you see anything that would prevent this from working in a runtime environment?

Hmm.. Can anyone confirm if you can reference a .net dll or .tlb from an application that is run in the runtime environment? I'm using Access 2013 to develop, and 2013 runtime. My error has changed to the following: ActiveX component not able to create object.

Arnelgp, I'm looking into that avenue now. Thanks. I've also pushed it back on the dev to supply me with deployment instructions. It's frustrating I got it to work on my machine, but not on others. I've read mixed feedback from a google search. Some say it's possible to reference a .tlb...

Hello, Having trouble in Access 2013, deploying an application that references a .tlb file. I've successfully registered the .dll file on the deployment computer, and made sure it was the same file path as my dev computer. Both the .dll and the .tlb are there. This was necessary to access...

I don't have an account on Utteraccess.com. I'll create one, but not sure it will let me download anything without a few posts under my belt there.

Did you guys get this code to work?

One last bump.... Looking into this again. I did find this other thread, but it appeared to die, and not have a good end result. https://www.utteraccess.com/forum/index.php?showtopic=2041518&st=40

Hmm...The code I have was to send an email automatically. I'd like to have it open for the user to edit before sending. The real trick is I don't use Outlook, but rather EMClient. It must be possible because docmd.sendobject will prepopulate the message and prepare it to be edited on my...

Thanks arnelgp, I forgot about that. Another trick you helped me remember is if you just change the file extension from .accdb to .accdr it will also simulate the runtime. Using this trick did confirm, it no longer has the functionality of 'outputTo', which is being used in Email object...

It's actually the emaildatabaseobject macro I'm using. Is that one available? I can write it in VBA, it just seemed easier for this one to do it in a macro....guess not.

Hello, Made a quick app this morning which uses a macro to email a report. Runs fine on my computer (Win10/access 2013). When I deploy to Station A or B (Win7/Access 2013 runtime) it gives me the following error. The command or action 'OutputTo' isn't available now -You may be in a...

Thanks guys, that was it.

I have a report that is based on a query. query shows all records for the field first name. I used the wizard to create the report, and not it is not showing the field value for every record. It appears to only show a value for the record if the value isn't the same as the previous record...

Woah! Thanks Minty, I had no idea. I'll have to get my hands on that.

"Professional" Developers always seem to throw dirt on VBA and say it's not going to be around, etc. After learning what its capable of, I simply don't see the need to move elsewhere. It's too easy to accomplish most things in MS Access. There are great add in tools help the VBE become a...