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

    error "Record too large" importing text files

    Importing Text files into Microsoft Access using the included ISAM driver requires that lines not exceed a certain length and that lines are terminated by both Carriage Return and LineFeed characters. I don't remember the maximum line length, possibly 255, or maybe 1024. I have had this...
  2. JerichoJ

    New Record at top of continuous form?

    Unfortunately, there is no easy, built-in way to do this. I too have wanted this feature at various times in the past, but Microsoft Access doesn't natively support it. The new record for Datasheets and Continuous forms will always be located at the bottom. Although I haven't tried this...
  3. JerichoJ

    SendObject using criteria or filter

    The sendobject command doesn't support any criteria or options for the report. What you have to do is write code that opens the report in Preview Mode, using DoCmd.OpenReport and providing the whereclause that you desire. Then, call the DoCmd.SendObject with the objecttype of acSendReport and...
  4. JerichoJ

    Cycling through records not fields using a recordset??

    Ok, The reason that it is only working for the first record is that you have to realize that the "TransferDates" function doesn't know *anything* about the rst you have declared in "MoveDates". Looping through each record of the recordset in "MoveDates" does...
  5. JerichoJ

    Max fields in a query for access97

    Queries and Tables have a maximum of 255 fields, so that isn't your problem. How are you editing this query? Is it a saved query? Are you opening it from the Queries tab of the database window? Or are you clicking on the elipses (...) next to the recordsource property in form design view...
  6. JerichoJ

    Select multiple list box items from the text box entries

    ...Integer Dim lstCount as Integer lstCount = Me.lstItems.ListCount For x = 0 To lstCount - 1 If Me.lstItems.ItemData(x) Like Me.txtSearch & "*" Then Me.lstItems.Selected(x) = True 'Call your code that moves this item 'to the adjacent text box 'Then, since items in...
  7. JerichoJ

    Subrpt forces new pg, main rpt pg doesn't prt new pg

    Vic, Ok, I think I understand your problem and I might be able to help. First of all, are you very good with VBA coding? This report is going to require some serious code to get the results you desire. I will outline my suggested solution and then we can discuss actual code later after you...
  8. JerichoJ

    Getting rid of the default error message.

    How are you executing the append query? From code or from a macro? The best way would be to execute it from code, and use a querydef object. This method doesn't present any error messages to the user unless the query itself has a syntax error. You would do something like this: Dim db as...
  9. JerichoJ

    Select multiple list box items from the text box entries

    ...= False End If Next x 'End of code to clear selected items in list For x = 0 To lstCount - 1 If Me.lstItems.ItemData(x) Like "*" & Me.txtSearch & "*" Then Me.lstItems.Selected(x) = True End If Next x Note that if your list box has multiple columns and you need...
  10. JerichoJ

    Access - Virtual memory loss when trying to print images

    Hello, What version of Access are you using? Also, please describe the layout of images on your report. Are there multiple images being displayed/printed on a single report page? I had some problems with images in Access 97 a couple of years ago. I ended up contacting MS Support with...
  11. JerichoJ

    strange common dialog error

    The filename is returned as a null terminated string that is 256 characters long. In order for you to use it, you need to remove the trailing null characters (appearing as "|") Public Function TrimNulls(strInput as String) as String Dim x As Integer x = InStr(strInput...
  12. JerichoJ

    Selecting the current record for a report

    I am afraid that I don't quite understand your question. "How would you return a value of the current record." Return the value of the current record from what? Your form that launches the report? Or the report itself? If you are talking about the form that launches the report...
  13. JerichoJ

    Selecting the current record for a report

    You are so very close. Basically, you need to add only 1 (one) line of code! You can tell the .sendobject method which report to send in two different ways. The first way is to do like you have done. By explicitly naming the report that you wish to send. The second is to leave the...
  14. JerichoJ

    Need Help desperately...............Code to Format Report Page

    Are you trying to create a comma delimited or fixed width text file? If so, look at the online help for DoCmd.TransferText You can create a query that has the fields and records that you want to export. Then using DoCmd.TransferText you can export that query to a text file. This is the...
  15. JerichoJ

    Command Button to Delete

    Lisa, Please explain what it is you are trying to do with form 2 after it pops up. You previously said: "I need form #2 to open with a new record and the matching field from form #1" The example that I provided opens the popup to a new record and populates a field in that new...
  16. JerichoJ

    i have a subform where the record s

    SubControl is the name of the Sub Form Control on your main form. Replace subControl with whatever you named your subform control.
  17. JerichoJ

    Calling all experts! Is Null problem

    The error message means exactly what it says. A record in a table cannot have Null as the value in the Primary key field for that table. What is happening is that the events occur in a specific sequence that is making your "OnClose" code too late. I am guessing that your user is in...
  18. JerichoJ

    hot keys

    Most windows applications, including Microsoft Access only respond to Alt+ combinations that are on the form that is currently active. So, the method that you are attempting to use would only work if you define Alt+C on all of your forms to do the same thing. This would be a mistake and quite...
  19. JerichoJ

    i have a subform where the record s

    ...= InputBox("Enter Search Criteria") If stResponse = "" Then Goto Proc_Exit Else stFindCriteria = "[AccountTitle] Like '*" stFindCriteria = stFindCriteria & stReponse & "*'" End If Me.subControl.Form.RecordsetClone.FindFirst stFindCriteria If...
  20. JerichoJ

    Unique fields won't notify before form is complete

    Andrea001, Ok, I think this is what you are looking for. For our example, the name of the ID field in the table will be "FieldID" and the name of the text box control on the form that is bound to this field will be txtFieldID. Of course, you will substitute your actual field and...

Part and Inventory Search

Back
Top