Search results

I think I may have found the solution -- I'm testing it now. http://support.microsoft.com/?id=837150

I am running into this same problem. It appears to only happen on systems with Windows XP Service Pack 2 installed, as older systems seem to run the installer just fine. Help please! Patrick The wording I am getting when I launch the installer is: "Visual Basic 6.0 Setup Toolkit" "The...

Brian, Thanks for the quick response, the code is already set in the OnCurrent event of the form. Should I set it in the OnCurrent event for the unbound object? The problem is, that since the form is in continous view, and shows for example 3 forms one after another with pictures, all the...

Can anyone offer a quick response to tell me if this is possible with unbound picture loading? Or, do I need to incorporate an alternate method? Thanks in advance, Pat

I think it happens, because a table is sorted only once (or when you go in and sort the table again manually). Therefore, if anything pulls it out of whack, it won't resort without manipulation. Basing a form on a query as it's control source is good practice, as it speeds up your application...

Hmm - I think if you take the /500000 out of the format (all that is doing is masking the true autonumber) and then put "500000" into the autonumber data field (in table view) to seed the start point, the autonumber should increase from 500000 on. Hope this helps, Pat

Me.ComboBox.Requery should do the trick. Just post that in the On_Enter or After_Update feature of your first combo box (or all of them). Hope this helps - Pat

Hi - Sounds like you need to make your control source for the form into a query and sort the query Ascending or Descending on whatever field you wish. That should clear things up. That way, everytime the data is pulled, it's sorted.

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

Correct - my question is, how do I make the field run that query for it's data? I can't seem to get a Textfield to run a query, and when I put a query in it's DefaultValue column, I just get a #Name? return because it returns an array (im assuming). Thanks again, Pat

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

Perfect idea! Thank you so much again for the help :)

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!

I'm using the following in my public module: Public Type UserInfo ViewID As Integer AccessID As Integer Active As Boolean Password As String UserID As String SecurityID As String End Type Public User As UserInfo But it behaves very strangely. Sometimes I can pull a...

Mile -- Thanks for the confirmation, is there any easy way to blanket the changes to the form, or will I need to make a conditional switch for each separate object on the page? Thanks again, Pat

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

Thank you very much! Worked like a charm :)

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

Okay, one last thing I want to put out there before I go redo my login with the above mentioned system. I've adapted this from the Whos_On code that's floating around that reads the LDB file. I could launch this from the On_Load() of my intro form to check for users -- since the Whos_On code...