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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by kpereira

  1. kpereira

    ID number field for max date of customer

    Bear with me on this. I am having a brain freeze and can't move forward with this one. I have a table something like this: IDField SaleDate CustomerID 1 1/1/08 552 2 4/3/07 552 3 12/1/07 552 4 4/3/08 444 5 6/3/07...
  2. kpereira

    Mail Label - how to select label to start

    I have a suggestion. If you create a parameter to have the user enter the label number, go to the section expert for the detals and click on the formula for "Next Page after" and add something like this Remainder (RecordNumber,cdbl({?001_ROT_LabelNum})) <> 0 As long as you don't use multiple...
  3. kpereira

    Insert statement with Case Function

    Thank you both! You were both correct. After working on this project for so long I was getting tunnel vision. You were both VERY helpful! Regards, Karen
  4. kpereira

    Insert statement with Case Function

    I have tried several times in several ways to use an Insert Into Statement which includes a CASE WHEN in a select statement to insert into the table. I have gotten errors that there weren't the same number of fields in the select as the insert. I tried altering it and can't seem to get it...
  5. kpereira

    Problems opening second recordset with SQL

    Bob: If you are using that exact code you should look at the second "Set" statement. It should read: Set rst1 = db.OpenRecordset(strSQL)
  6. kpereira

    Importing from several worksheets in excel

    PHV YOU ARE FANTASTIC!!! Thanks a bunch!!!! Karen L. Pereira "Great spirits often meet violent opposition with mediocre minds" - Albert Einstein
  7. kpereira

    Importing from several worksheets in excel

    Thanks anyway guys, but the active spreadsheet is always the same. The code won't change the active sheet to the next one. I must have some problem with the install or some reference. I appreciate your help...this is a great forum!! Karen L. Pereira "Great spirits often meet violent...
  8. kpereira

    Importing from several worksheets in excel

    HELP!!!! My frustration level is rising. I have tried to import all of the worksheets into a table in Access, but for some reason when I change active sheets, it doesn't change...I have traced the value of the active sheet ,but it isn't changing. I have tied iterating through all...
  9. kpereira

    Sequencing Numbers

    Thanks a bunch! [medal] Great logic! This is a fantastic forum! Karen "Great spirits often meet violent opposition with mediocre minds" - Albert Einstein
  10. kpereira

    Sequencing Numbers

    Hello: I loved the following article, but I need to do something different and I'm new to SQL programming. http://tek-tips.com/viewthread.cfm?SQID=859372&SPID=183&newpid=183&page=1 I am trying to take the items in the temp table and instead of sequencing them consecutively I would like to...
  11. kpereira

    My Tabs vanish from the top of my tab control

    You might want to check to see if your form needs to be resized. If a form is sized too small for the entire tab control it will cut off parts of it...this often means the tabs disappearing. K. Pereira [ponytails2]
  12. kpereira

    Fill Listbox with the Captions and names of all Reports

    Can anyone give me some idea of how to fill a list box with the captions and names of all reports. I want to use this listbox as a selection of reports for printing. Any help would be appreciated!!!! Karen
  13. kpereira

    In Subform set focus to the new record

    I would simply setfocus on the field in that record you wish to be in. For example, DoCmd.GoToRecord , , acNewRec Me.EmployerName.SetFocus This brings the focus in the new record to the EmployerName field. I hope that helps. Karen
  14. kpereira

    Enumerating and renaming files

    Can anyone tell me how to enumerate through all of the files in a directory and rename them. For example I have a directory with files such as 1.bmp, 10.bmp, 200.bmp. I want to rename the file respectively, DMS1.bmp, DMS10.bmp, DMS200.bmp. I haven't worked much with file objects. Any help...
  15. kpereira

    Listbox question

    Hello Everyone! I was hoping that someone might have the answer to a question. I have a search form with a listbox, a text field, a combo box and a button. Usage: 1. Select a value in the combo box, e.g. First Name, Last Name, ID. 2. Next, there is a text box to enter the search...
See more

Part and Inventory Search

Back
Top