Search results

I'd like to be able to throttle the max number of connections down to a certain number, but then package the database with the packaging wizard in Office XP Developer so that number can't be changed (i.e. if the max connection level is 3, only 3 people at a time can logon). Thanks in advance...

For example, this is a screenshot of the boxes after checking one of them, half are grey, half are white.

When I start a new record, most of my forms that have checkboxes will suddenly turn white, waiting for a "check". But I do have one misbehaving form that 75% of the boxes will turn white/empty, while 25% remain sort of grayed out.. Any ideas?

Just a quick supplemental link for those who will walk this path behind us. http://office.microsoft.com/assistance/preview.aspx?AssetID=HA011225981033&CTT=98 This details the Access 2003 security warnings and the "reason" behind their implementation and my frustration (From Microsoft's site).

Well, I just ordered a copy of Office XP Developer, to avoid this whole situation with 2003's encryption issues. My only hope is that this thread will help someone else make an educated decision on this software so more money isn't wasted with Microsoft's various "enhancements" Thanks for all...

Yeah :) But since this will be distributed all over the place, and not just to a local group of users, I don't think it's very practical to include instructions of how to sign us as a "trusted source" :) I just can't believe M$ would do this.. I already paid $800 for the developer edition of...

Well, I'm not going to go the registry route - so I'm back to square 1, with the $400/year certificate. I saw something funny on slashdot.org this morning, that there had been so many complaints about this very issue that in Office 2005 the security will be totally internal by self...

Hmmm, the registry key solution may do the trick, but I need to know how to set this key by the "Additional Registry Key" feature in the Access 2003 Developer Package Wizard for the runtime solution. The problem is, that the runtime version deployed on peoples machines doesn't give them an...

Wow - nevermind. Just found the long and short of the Office 2003 Digital certificate run around. Looks like I'll have to shell out $400 to Verisign for the Digital Certificate to "sign" my work. http://office.microsoft.com/assistance/preview.aspx?AssetID=HP010397921033&CTT=98...

So I've been packaging my product, but have noticed with 2003 it has security in place that puts up all kinds of warnings that are quite annoying when the program is started. It talks about the unsafe expressions that all programs could have and asks to confirm this. It's not my application...

When my subform opens, it's matched to an ID field so that the information maps relationally. However, when the subform opens, it opens to the first data set (ordered by the query). Is there a setting I'm missing to have the subform find the data via the query and match on the ID (populating...

doh! :o Thanks :D

How can I control my tab order predictably? When I push tab on my form it will go to various boxes without any cohesive order. Can I set a tab order? Thanks in advance :)

Dim strPath As String Dim intCounter As Integer Set db = CurrentDb strPath = db.Name db.Close Set db = Nothing For intCounter = Len(strPath) To 1 Step -1 If Mid$(strPath, intCounter, 1) = "\" Then Exit For End If Next...

Worked like a charm, thanks for the assist!

Hi, I'd like to be able to refresh a form after someone clicks on a checkbox in an option group to change some data. Essentially, I have a picture that correlates to the checkboxes. The picture updates fine, but currently they wont see "live" updates, only after they navigate away and back do...

I've attached a picture that I want to accomplish. It's in excel, and I'd like to create an access form so we have a database backend. I have the calendar access program built, but need some input on how to make a grid work with color coding. Any resources or keywords I should search on? Thanks...

How can I use an option group (I did this initially), and allow the user to select multiple checkboxes. I need to be able to have more than one court selected at a time. As always, you guys rock!

Okay - I know there must be a programatic way to do this without the lengthy checks. Here is the code I am working with in order to show a picture. Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open If IsNull(Me!Court1) Or Me!Court1 = "" Or IsNull(Me!Court2) Or...

Pat - Just curious what these naming conventions are that will restore linked tables if they are moved? I'd like to employ this method before I deploy the database. TIA Pat