Search results for query: *

Thank you for response. I read the two articles, but unfortunately I wasn't able to see how they would help answer my question. Maybe I'm missing something. Regards, Lisa

Is Access 2010 Runtime compatible with Windows Small Business Server 2003 Service Pack 2? One of my clients has a computer with "Microsoft Windows Server 2003 for Small Business Server Service Pack 2" installed. My application uses Access 2010 Runtime. According to Microsoft's download page...

I've played with this a bit, and it looks like the horizontal scroll bar on a list box is inactivated when you anchor to stretch across, and the vertical scroll bar is inactivated when you anchor to stretch down. It doesn't look like there's anything you can do about it. Regards, Lisa

If you want to print only the current record, you could do this: Private Sub PrintForm_Click() Dim myID As Long myID = [ID] ' Unique identifier for a record ' Activate filter on the current record. Me.Filter = "([Table1].[ID]=" & myID & ")" Me.FilterOn = True...

Sorry, I was confused by what you said in your 15 Dec 08 12:56 post: But now you say that: I guess you must mean that the main form is unbound, your combo box has the record source you quoted, and you copy the information from the record selected in the combo box into unbound text boxes on...

I was able to make this work by doing the following: (1) Change the main form's RecordSource to: SELECT DISTINCTROW qCustomerName.CustomerID, qCustomerName.Name1, qCustomerName.City, qCustomerName.State FROM qCustomerName ORDER BY qCustomerName.Name1; (2) Change the names of the text boxes...

Example: If you had an image of a head that was 3" wide, then the left eye could be from x=.75" to x=1.25" and the right eye could be from x=1.75 to x=2.25". If the user clicked at x=.75 or .8 or .81 or .87 or .83 or 1.1 or 1.13 or any other value up to 1.25, you would have to process the left...

I created a test form that works similarly to your form in Access 2007, and it worked correctly. The subform showed the correct information after setting its RecordSource; the calls to SetFocus and Requery are not necessary but did not cause the code to fail. I'm not sure what's causing your...

Please forgive me if I don't understand your question, but it doesn't make sense to me that you would want to look for x "in" a certain list of values. Your x- and y-values will be in ranges of values. Regards, Lisa

My mistake. I was talking about an accdb, not an mdb. Here's a link that explains how custom toolbars and menu bars that you created in earlier versions of Access behave when you open those older databases in Microsoft Office Access 2007. This topic also explains how to turn off the Ribbon so...

Here's the date-related part of the query [3b_WAGE Payroll Summary 207642]: PARAMETERS [Start Date] DateTime, [End Date] DateTime; SELECT InputTable.ID, InputTable.MyDate, [Start Date] AS [Start Date], [End Date] AS [End Date] INTO TempTable FROM InputTable WHERE (((InputTable.MyDate)>=[Start...

Have you already created the query? Does it ask for the dates? Does it create a table with the dates in one or more fields? If so, what is the name of the table, and what are the names(s) of the date field(s)? Regards, Lisa

You have described what you're trying to do, but I cannot tell what you're having trouble with. Please ask a specific question. Regards, Lisa

In Access 2007, your custom toolbars and menubars are available on the ribbon's "Add-Ins" tab. To hide all ribbon tabs other than "Home" and "Add-Ins" in Access 2007, click the "Office" button, then "Access Options", then "Current Database". Under "Ribbon and Toolbar Options", remove the check...

You could attach code to the control's On Mouse Move event to open the second form, but then the focus would then shift to the new form instead of staying on the original control, making it difficult to know when it was time to close the second form. If you open the second form as a dialog box...

To check your references, open the Visual Basic Editor in Access on one of the computers that is having problems. Click on "Tools", and then on "References...". The active references will be listed at the top of the list with a check mark next to them. If any references are broken or missing...

The x and y coordinates returned by the MouseDown routine are measured in twips. A twip is a unit of screen measurement equal to 1/20 point. A twip is a screen-independent unit used to ensure that placement and proportion of screen elements in your screen application are the same on all display...

The unbound object frame's MouseDown routine returns the button that was pressed to trigger the event, the state of the SHIFT, CTRL, and ALT keys, and the x and y coordinates for the current location of the mouse pointer, in twips. Private Sub MyOLEUnbound_MouseDown(Button As Integer, Shift As...

Have you checked the computers that are having problems to make sure that you don't have broken or missing references? Also, could this be a DAO / ADO problem? Regards, Lisa

TheAceMan1, I think you have an extra "form" in your expression. Please try: [Forms]![Member_Form]![Request_Form]![txtAuthID] Regards, Lisa