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: *

  • Users: kpereira
  • Order by date
  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...
  16. kpereira

    Page breaks on change in a field value

    Do as Paul says. Let us say that you want the report to break on department. Create a department grouping and use both header and footer. Click on the footer and in the properties click on the format tab. In the force new page property select, &quot;After Section&quot;. This will force...
  17. kpereira

    Help to stop error msg's when running action querys

    If you are using code to run the query you can use: docmd.setwarnings (True) This will turn off Access warnings while the query runs if it is placed before the query is run. K. Pereira
  18. kpereira

    Adding up a range of time values - Im in a mess

    Try dSum DSum(expr, domain[, criteria]) expr -- An expression that identifies the numeric field whose values you want to total. It can be a string expression identifying a field in a table or query, or it can be an expression that performs a calculation on data in that field. In expr, you...
  19. kpereira

    Refreshing Form Data Based on View

    Thanks so much.&nbsp;&nbsp;This forum is fantastic.&nbsp;&nbsp;Help is nearly immediate!<br><br>Karen
  20. kpereira

    Refreshing Form Data Based on View

    Hi Everyone:<br><br>I hope someone can help.&nbsp;&nbsp;I have built a form based on a view which combines a few tables and a query.&nbsp;&nbsp;Maybe I'm thinking too much like Access.&nbsp;&nbsp;&nbsp;I have a query which determines the &quot;Last&quot; year (i.e. 99-00) in a...

Part and Inventory Search

Back
Top