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

    Using a form to open a report to a specified record

    I've used the following on a click event, this should help, it only pick up one student and select that student's report only. Private Sub cmdWarning_Click() On Error GoTo Err_cmdWarning_Click Dim stDocName As String DoCmd.OpenReport "rptWarning", acPreview, , "[STDNO]=" & [STDNO]...
  2. Shirley

    Problem deleting a record (URGENT)

    I really have no ideal, but look at the spaces, maybe they have something to do with it. Here is the code from one of my Delete Button, maybe it will give you an ideal of where to start. DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, ...
  3. Shirley

    Access Switchboard

    Did you check the Switchboard Manager, to see what is happening with the first button? If so what is it set on?
  4. Shirley

    Access question

    You would have to create a new query of the table and insert a new field. For Example: Total: [1stField]*[2ndField]
  5. Shirley

    Count number of subgroups in a group

    Your have to make sure the textbox is near the txtGroupPOHeader or right under the field.
  6. Shirley

    IIF question

    Trim deletes any space in front of and behind the field. There is RTrim which will delete the space in the back of the field, and LTrim for the front of the field.
  7. Shirley

    Transfer Text Macro in Access

    I don't understand, when you run a marcos that has a procedure that export the data as text, then the text used as the datasource for a mail merge document you come get an error?
  8. Shirley

    IIF question

    =IIf([Family Name]<>"",(UCase([Family Name])),(UCase([Title)] & “ “ & UCase([Last Name]))) Try this Simple one first and then add the Trims and UCase = IIf([FamilyName]="", [FamilyName], ([Title]&" " &[LastName]))
  9. Shirley

    printing a form with variable # of lines

    What is the length of the form?
  10. Shirley

    IIF question

    =IIf(Trim([Xmas])="xmas" And Trim([Family Name])<>"",UCase([Family Name]),UCase([Title)] & “ “ & UCase([Last Name])) Try this and see if this works.
  11. Shirley

    printing a form with variable # of lines

    Create a report that can be used and use the primary key as the condition for the print button, for example: DoCmd.OpenReport "rptWarning", acPreview, , "[STDNO]=" & [STDNO] This is to preview a report that I created, but I only select the student that have the same StudentID, which is my...
  12. Shirley

    Count number of subgroups in a group

    Make sure that the supplier header have a footer section. On the footer section set up a text box that will = Count(supplier header) and name the text box txtsupplierheader , you can set the visibility as no. On the main head group footer you can setup a text box that =txtsupplierheader. Try...
  13. Shirley

    use sendobject to email a report in excel

    If you name the excel sreadsheet the same name every time, you can go into the excel spreadsheet and set the page setup. Go to the sheet tab and check the gridline and Save. Then everytime the speadsheet is open the gridline will print out. I hope this will help.
  14. Shirley

    Exporting

    On a button click event try this code: Private Sub cmdEvents_Click() Dim stDocName As String stDocName = "Nature Events" DoCmd.SendObject acReport, stDocName End Sub It will send as an attachment to an email.
  15. Shirley

    Bitmap displays on report on screen, but prints a black square

    Add it as an image and paste the bitmap and see if that will work when printing.
  16. Shirley

    Bitmap displays on report on screen, but prints a black square

    Did you put it as Image, Unbound Object Frame, or Bound Object Frame?
  17. Shirley

    send object with data

    It will be easier to email a report as an attachmet then to send the form. If each record as a primary key(ID) you can set it up where you will attach only the report pertaining to the form. Creating a Report 1) Click on Reports/New/Report Wizard 2) select the query you are using for the from...
  18. Shirley

    send object with data

    Did you create a report of the form?
  19. Shirley

    Writing User Name to table

    create a variable and put and put ComboBox.value into that variable and append to the table.
  20. Shirley

    Building and event in a text box

    Create a subform that is linked to the person account number on the master from then display the sum on the subform. Make sure the subfrom is in single form layout.

Part and Inventory Search

Back
Top