Search results

Ok, I'm using the following code (which works fine on unbound pictures in single form view): On Error GoTo err_Form_Current If Not Me!Picture = "" Or Not IsNull(Me!Picture) Then Me!txtPicture.Visible = True Me!txtPicture.Picture = "K:\staff\" & Me!Picture Else...

I have a field which depends on a matrix value from a table, but I'm not quite sure how to populate it. There are two fields that determine what the third value will be. The form where the two fields are can then match their numbers with an alternate table. My question is, when they match to...

I have some trial code that counts down 30 days before the application will no longer function. What I would like to do is put a button that pops up a message box asking for a "registration code". If that code is entered, the code that runs the 30 day countdown is disabled. Any pointers on how...

Is there a trick to this, I'd still like the user to be able to view the various records (navigated by an unbound listbox), but want AllowEdits to be False to prevent data from being changed, thus making it "Read Only". Is the only alternative to manually lock each field? Thanks again!

Would this be the correct method of blanket locking a form based on form security userlevels? I'd like to set all textboxes "Locked = Yes" and comboboxes "Limit to List = Yes". If UserLevel = "viewonly" Then Me.SomeTextBox.Locked = True Me.SomeComboBox.Limit to List = True ElseIf...

Is there a way I can make combo boxes be locked (i.e. not able to type in information). I know this defeats the purpose of the combo box, but the click/pull down menu feature of the combo box is a major tool that people use. The list box is not "functional" enough in that capacity. Any ideas...

Is there a way to resolve the backend path via code instead of the frontend path? I'm trying to put something together to check who's logged into the backend, but cannot resolve the path. When I use Current.db, it always gives me the frontend path. Thanks in advance, Pat

I'm looking to build a button on my app that will allow the user to select the file they wish to import via common file dialog, but that will also re-arrange the data each time into the correct order for the Access Table (from another differently arranged Access Table). What's the best approach...

What's the best way to initiate a macro 15 seconds after a form is loaded, only once instead of the loop from the OnTimer form event. TimerInterval = 15000 DoCmd.RunMacro "MacroName" ? Is there a better way to do this? What's the best way to break the loop out so it only runs once? TIA :) Pat

Just curious what methods you have all employed for distributing a package with networking option. Once the MDE is packaged, is there a way to launch the linked table manager in a way so that it's inclusive to the program feel, i.e. without going to Access main program, within the runtime...

Okay, some of you have read my ongoing issue with Office 2003 Developer. Well, I went ahead and purchased Office XP Developer also, to alleviate those issues. It works like a charm, except the packaging wizard is slightly different than the Office 2003 packaging wizard. Mainly, when the Office...

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...

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?

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...

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...

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...

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...