Search results

I beleive the issue is with the key field. Say one of the two columns is a key column and the other is not. When you create a combo box that displays both columns only the key column is stored in the table. Even if you create a combo box that displays only the non-key column, the key column...

Try something like this: If Me.AvgTT > 85 Then Me.AvgTTlbl.Caption = "Exceeded" Else Me.AvgTTlbl.Caption = "Partially Exceeded" EndIf Or test the value of AvgTT with this: Dim AvgTTTest1, AvgTTTest2 AvgTTTest1 = Me.AvgTT AvgTTTest2 = 1 If AvgTTTest1 > AvgTTTest2 Then MsgBox "1 >...

Those characters look like binary data stored in say an *.mdw (as passwords, SSIDs, etc.) What type of file are you connecting to again? If it's not ACC you might try linking to all of the tables and sorting it out from there.

Re-run the workgroup administrator and re-join the "System.mdw" default workgroup. This file should be somewhere like your 'Application Data\Microsoft\Access' folder. You should open your database using a workgroup via a custom shortcut.

Yes...the tables should have one or more fields that are common; then you create the link(s) between the form(s) using these field(s) and only related records are displayed.

Great example in this post: http://www.access-programmers.co.uk/forums/showthread.php?t=130570&highlight=run+excel+macro

In your form using the AfterUpdate event of the control containing the drop-down list use something like this: If Me.MyDropDown = "My Text" Then Me.ThisControl1.Visible = False Me.ThisControl2.Enabled = False ElseIf Me.MyDropDown = "Some Other Text" Then Me.AnotherControl1.Visible =...

I agree with georgedwilkinson -- one has to look "big-picture" when designing datasets. You would need to cosider needs for future expansion without too many large design changes (i.e. addition of another level of subcategory). His method would seem best. Personally, I would go the...

I was asked if it were possible to log into a workgroup secured db without having to enter the username and password and came up with the attached "accessory" db instead of distributing shortcuts with their username and passwords included in the shortcut as others could view the properties of...

Perhaps the OnEnter event of the appropriate subform control can update that for you? You could use something like: [Forms]![frmMyMainForm].[MyYesNo]=True as the underlying code for this event which should check the box for you when the subform is entered (gets focus; but not to be confused...

First remove the old field from the report as it's still attempting to display the old field type then re-add the field to your report and it should display the check box control.

The AutoExec macro runs code in a module that opens the form.

Yes there is a reason for the timer. There are a couple of forms that open on db startup and one of them I need to run some actions and then close iteself after completion but not until a few seconds after the db runs some startup procedures. If I used the OnLoad event it would run the actions...

So should I still set the timer back to zero or just let the form close and not worry about it? The Me.Form.TimerInterval works fine but I do see now that the extra word may simply be a waste of time. Not sure how it effects the execution.

I'm using the timer because it's the whole purpose of this form. On open the interval is set to 5000ms (5 seconds or so). I suppose theres no need to set back to zero since the form is going to close anyway but is the key thing here the addition of "DoEvents"? I've never used it before. I'll...

I'm sure to get some flak about this, but I have a question concerning timing (or code processing). Say there's a form with an "OnTimer" event running the following code: Private Sub Form_Timer() Me.Form.TimerInterval = 0 Call GetPrevAccessOptions Call SetAccessOptions Call YetAnotherFunction...

Great! It's a bit slower, but it works. Thanks.

I can see an "On Mouse Wheel" event, but not sure how to use it or detect which direction the mouse wheel is going to direct record navigation to the previous or next record depending on the current position. I can work out the position thing but just need to find out how to detect wheel...

missinglinq, I've found that 2007 won't let you scroll in Single-form view but it will in Continuous-form view. I like to be able to scroll in Single-form view so how do I allow it? I've searched this forum and everyone seems to want to disable it but I need it can can't find anything in help...

Ok. Since "upgrading" to Office 2007 and hence Access 2007, my continuous forms still scroll with the mouse wheel but my single forms do not. It this disabled in ACC 2007 permanently or can I re-enable it somehow? I don't have any code preventing use of the scroll button on the mouse and it...