Search results

Although I didn't receive any replies about this, I figured I would follow up in case someone is interested in this topic. I have been working hard on creating an installer to deploy the database that automatically uninstalls the previous version (so that there is only one instance of it in the...

I did not realize that you only have runtime available to you. I agree with Dave that you can't do this only in Runtime. Maybe it is possible but ultimately if you are making any changes at all to the front end you need the full version of access.

You edit the settings in the full version and then make the runtime version by changing the file extension

I was having this problem with the security warning appearing when the application was launched in Runtime on some user machines (but not all). The program was being run in a trusted location. I solved it by enabling all macros in the trust center macro settings dialog box (see attached...

Hello, I have created a split Access 2007 database that is currently used by a few people in a mid-size company who are running it in Runtime. Because small changes are always being made to the front end, I have found it is necessary to post new releases fairly frequently. Several of my users...

Having said all this, I would enjoy teaching people who are committed to learning. Judging by my boss's sudden silence, my guess is that she already knows she is not committed enough. Chances are that she will either try to find someone who would be a better fit or outsource the project to...

Good morning. I just wanted to follow up on this and thank you all for your insight. It really helped me put this in perspective and sort out ideas. With your help, I realized that my boss was actually raising two separate issues last Friday, one legitimate, one less so. The legitimate one...

Ha ha, I know. I already told her I would start training her next week. If she manages to get any real involvement with the development she is going to make this a nightmare because she obsesses over nonsense and doesn't see the forest through the trees. Luckily, I am fairly certain she will...

The video in the external link is pretty interesting: https://www.youtube.com/watch?v=Q52kFL8zVoM I like my boss as a person but she is totally the type to obsess over the color of the bike shed...;) IMO, the bottom line is that they should fork over the money to hire someone with real skills...

Ha ha, no, I was not familiar with that but of course it makes sense. I think my original post is perhaps a little misleading: I don't have a problem with somebody else being hired to help with development or even training someone with aptitude. The issue is that I don't think she is the...

I already know this--she knows nothing and her technical skills are minimal. She can't even map a network drive

I never work on it live. Good idea about the separate directory for her though. She will want access to the live backend otherwise she won't be able to get the data she needs at a moments notice. That will probably be an issue. Keep in mind she is not technically competent in any way at all...

Not really taking it personally just not sure how to do it in practice. Just give her a copy of the front end, hide the tables, and tell her to go to town?

Thank you. Project documentation is a great idea. There is someone here who is enthusiastic to learn (but not in our department). I made that suggestion and she did not seem open to it.

Several years ago, I started creating a database at work with no previous experience. As time went by, my skill level has increased dramatically and it has taken years of experience and hard work to get where I am now. In this time, I learned everything I could about table structure, data...

Another tweak to the code in case someone else ever has reason to use it... It is a good idea to declare the VarCtlSubform variable and you will have to if Option Explicit is on. I will update post # 7 accordingly :)

Hi, The main form is not set to data entry. The properties of the main form are: data entry = no allow edits = yes allow additions = yes When the user clicks a button to add a new record it opens data entry only. The main point is to be able to add data for an existing project.

Obviously, to allow edits you have to do the same for that property so sbf.Form.AllowEdits = True

Well, it took some figuring out but I *think* I found a solution. I added code to specifically set the subform property to allow additions. Here is the final code with the red being the changes: Dim pgn As Access.Page Dim VarCtlSubform As Variant Dim strSubForm As String Dim sbf As...

Hello again, Access backend :/ Yes, there are lots of combo boxes...moving the record sources for the combo boxes to a local table sounds like a lot of effort but perhaps worth considering if I cannot find another way. It is actually a data entry form but perhaps I can load just a single...