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

    HELP WITH QUERY - MONTHLY PAYMENT COUPONS

    Are you asking how to specify a date range as the criteria in a query? The syntax is: Between #10/1/05# and #12/15/05#
  2. JoyInOK

    Runtime error 5852 during Access-Word mail merge

    I think this results from a new security setting in Word 2003, which prompts the user for verification when opening a datasource. The default value is no (No, don't attach the datasource), and when using automation, you are not given the opportunity to respond "yes". This security feature is...
  3. JoyInOK

    Mailmerge Problem

    I think this results from a new security setting in Word 2003, which prompts the user for verification when opening a datasource. The default value is no (No, don't attach the datasource), and when using automation, you are not given the opportunity to respond "yes". This security feature is...
  4. JoyInOK

    Some Controls Disappear When Background Colour Is Changed

    Have you tried selecting a control and using Format/Bring to Front (or Send to Back)?
  5. JoyInOK

    Set Find/Replace Dialog Defaults With Code

    Bad news, KZPools. After much gnashing of teeth, I held a training for my users explaining that if they don't get the results they want, they should try again after unchecking the box. This works when it is obvious that the results are wrong (When they KNOW we have more that one Smith in the...
  6. JoyInOK

    attach a word doc to an email

    This is basic code to send an email with VBA, and it includes an option to create the email with an attachment. You will first need to set a reference to the version of Outlook you are using. Sub SendMessage(Recipname As String, SubjectText As String, BodyText As String, Optional...
  7. JoyInOK

    SQL Update

    You have an extra space in front of the class name, so your criteria is [TBL-1].[Attribute-Name] = ' Class1' instead of [TBL-1].[Attribute-Name] = 'Class1'
  8. JoyInOK

    Version Questions...unable to change!

    You can have two versions of Access on your system. Here's an FAQ on the issue: FAQ181-496
  9. JoyInOK

    Access 2002 Email Form Record

    I have a tickler system set up in my database. When a user opens the database, the following code is executed in the designated start-up form. This routine sends an email to the person (from himself/herself) referencing the particular claim (record). The code uses the following fields which are...
  10. JoyInOK

    Query (SQL) with VBA

    Quehay's right, it was difficult to follow the wording of your question, but I think I get the jist of it. The SQL you provided is the recordsource of your subform, Y. The query pulls data from the combo boxes and refreshes as the selection in the combobox changes. You want to dynamically set...
  11. JoyInOK

    Problems with Word directory merge

    Have you checked to see if there is a "skip record if" code in the beginning of the merge template? You can look at the hidden codes with Alt+F9. You might also check that there are no filtering options turned on by going back through the wizard and make sure to "select all&quot...
  12. JoyInOK

    IIF Function

    You can in the On_Format Event of the report. Select Case txtStatus Case 2, 5, 6 NameOfLabel.Caption = "A" Case 1,3,4, 7 NameOfLable.Caption = "B"
  13. JoyInOK

    Round function produces wrong answers in Access

    Thanks DonQuichote, that's just what I was looking for. Watch out for those windmills.
  14. JoyInOK

    Saving an E-mail's text in an Access record, or vice versa.

    You can set the reference from the code window. Click Tools/References. Scroll down to Microsoft Outlook and click the box next to it. click OK to set the reference. If you replace the objMail.Send with objMail.Display the user will have to manually send the message, which I kinda like...
  15. JoyInOK

    Fill color for a command button

    There's no option for a back color on a command button, for some reason. The workaround I use is to make a label the exact size and shape of the command button (you'll also want to make the special effect Raised, to make it look like a button), then copy and paste the code from the click event...
  16. JoyInOK

    Print Preview vs. Print

    FYI, it is not considered good practice to repost the same questions three times unless you've not gotten a response after several days. If you are calling the opening of the preview version from a command button on a form, you could use this: Private Sub Command0_Click() DoCmd.OpenReport...
  17. JoyInOK

    Set Find/Replace Dialog Defaults With Code

    For some reason, the default value of "Search Fields as Formatted" in the Find and Replace dialog box in Access XP is Checked. Users must remember to uncheck it each time in order to get correct search results. In prior versions, defaults for this dialog box were set in...
  18. JoyInOK

    Delete confirmation box

    This one works in the form's Ondelete event, but is Access not prompting you to confirm deletes anyway? Private Sub Form_Delete(Cancel As Integer) Dim intResponse As Integer intResponse = MsgBox("Are you sure you want to Delete?", vbOKCancel, "Confirm Delete") If...
  19. JoyInOK

    Filter Problem

    Did you use the .requery action to update the data in the two subforms?
  20. JoyInOK

    How to make a report stay in the same position!!

    Whoops! In looking at some code I've used, I think this is how you refer to a control's properties on format: Dim ctlControl As Control For Each ctlControl In Controls If ctlControl.Tag = "BarCode" Then ctlControl.Top = 0.2 End If Next ctlControl

Part and Inventory Search

Back
Top