Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. LisaWay

    Access 2010 Runtime / Windows Small Business Server

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

    Access 2010 Runtime / Windows Small Business Server

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

    Access 2007 - no horizontal scroll bar on unbound list box

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

    Print a form

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

    Problem with subform requery

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

    Problem with subform requery

    ...change "Expr1" to "CustomerID"). (3) In your code, change: Forms!AddressMgr!AddressSubform.Form.RecordSource = "SELECT DISTINCTROW Customer.* FROM Customer WHERE " & MyCriteria & " ORDER BY Customer.Name1;" To: Forms!AddressMgr!AddressSubform.Form.RecordSource = "SELECT DISTINCTROW...
  7. LisaWay

    images in a form...

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

    Problem with subform requery

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

    images in a form...

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

    Access 2007: Showing a personalized toolbar

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

    Auto-Generate File Name with Field Content...

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

    Auto-Generate File Name with Field Content...

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

    Auto-Generate File Name with Field Content...

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

    Access 2007: Showing a personalized toolbar

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

    Mouse-over event

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

    Recordset clone not working in Access XP

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

    images in a form...

    ...As Single) MsgBox X & " " & Y ' Display x and y coordinates DoCmd.CancelEvent ' Prevent user from editing the image If X < 1 * 1440 Then If Y < 1.5 * 1440 Then ' Upper left processing ... Else ' Lower left processing ... End...
  18. LisaWay

    images in a form...

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

    Recordset clone not working in Access XP

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

    Query Form in Tab Control

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

Part and Inventory Search

Back
Top