Recent content by pat_nospam

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