Search results

  1. V

    Indentify a page index (tab)

    Tried that I tried just using: =[forms]![frmContacts].[ID] but the same record shows for all the other id's instead of their record. thx
  2. V

    Indentify a page index (tab)

    Hello: I have a form that has tabs on it. I have a list box on one of the tabs linked to a query, trying to show only those records that go with the person's name on the header of the form. Example in query: =[forms]![frmContacts]![Page]![4].[id] -- [id] is the person number. This is were...
  3. V

    If statements always showing true instead of value

    Thank you "shades" Thanks for all your help. Iwill look into seperating all the formulas and data. THat makes great sense. The sheet I'm working on as I stated has 1286 rows down and the lookup sheet when complete will have close to 300 columns of data to lookup. Quite a task. The help...
  4. V

    If statements always showing true instead of value

    Thanks for idea and all your help I will have to rework allot in my spreadsheet to make room for all the formulas, (there’s about 1000, rows down to look up) but you given me a great start. I think breaking them down might be the best way, because it will let me expand my number of columns I...
  5. V

    If statements always showing true instead of value

    Thank you Thank you, It seems to work great. Last request (well maybe). I tried putting an additonal if statement if front with ISNA to make a zero appear instead of #N/A or #value, if no value was found. Well no luck solving that problem, so I need your help again. I learned alot just...
  6. V

    If statements always showing true instead of value

    vlookup in h2 Look at the formula in H2 sheet prod. It has vlookup to find the data in eqy01. Based on looking up $C4&$H$3 on sheet prod. If iI cannot find it in $C$4:$D$41 then look in $F$4:$G$41 if not there then $I$4:$J$39, and so forth. H2 Formula...
  7. V

    If statements always showing true instead of value

    Value I need the number to show up in H2 from column EQY01 (400) or the column EQY02 (200) and so forth in sheet shipschd. thank you
  8. V

    If statements always showing true instead of value

    Column H2 informtion I need a value in H2 based on a vlookup for columns C (value being look up) and D (value needed) from sheet shipschd, if not found there needs to look at columns F and G and use the G column value, and so forth. Thank you
  9. V

    If statements always showing true instead of value

    I been trying to nest if statments and vlookups to find values from various coulums with no luck. See attached spreadsheet. See sheet Prod cell H2 to give you an idea. The data is on the shipschd sheet, which is downloaded from an As400 system. Any idea's or help! Thanks dmh
  10. V

    Combining Queries Problem

    Thats what I did! Made a query out of the AEUnionMaint, added goups and sums, it worked great. I cannot thank you enough. I'm going to use that query in a report. Like the buttom idea for the report or maybe a datasheet form. Thanks again for all you help. I hope I will be able to help...
  11. V

    Combining Queries Problem

    Wow! Thanks Thank you so much. I looked at the all the queries and learn a few simple ideas I can put to use in other places. I have one last question. The equipment numbers appear through out the list, but I need to group them along with the sum of minutes. I took the AEUnionMaint and...
  12. V

    Combining Queries Problem

    Thank you again ajetrumpet This is what I've started, but I get errors trying to group and sum. Not sure how to write this line of code. SELECT tblShiftLogEntries.Maint1Mach, tblShiftLogEntries.Maint1Min, tblShiftLogEntries.WorkCenterID FROM [qrymaint1] UNION ALL SELECT...
  13. V

    Combining Queries Problem

    Thank you ajetrumpet I understand grouping. Each query group seperately, but I'm not sure about union queries. Any help would be appreciated.
  14. V

    Combining Queries Problem

    Combining Queries The goal was to track equipment downtime, by each piece of equipment, but the WC might have multiple downtimes on multiples equipment each day. So you end up with equipment numbers in different parts of the table.(mach # 1234) I’ve been trying to figure out how to combine...
  15. V

    Problem with Flash in an Access form

    Oops Forgot to attach file. Should be named Animation2k.zip
  16. V

    Problem with Flash in an Access form

    Flash program This is a program I downloaded awhile ago to make banners and such. Might be helpful. Not sure where I aquired it.
  17. V

    Rnd generates same number after closing and reopening the database.

    Thanks The autonumber is not feasible, because the invoice is tied into a Julian date code. I've tried rnd(timer()) and it seems to have solve the problem. I only generated one duplicate invoice number (first entry) after closing and reopening the database. Not the continuous duplicates I was...
  18. V

    Rnd generates same number after closing and reopening the database.

    Randomize (957426813) Me.txtInvoice = CDate2Julian(Date) & MyYear & (Int((14035 + 1) * Rnd + 3)) Me.txtInvoice = Me.txtInvoice + Me.cboAcctNo + 3 These lines of code are in my program to generate a random invoice number after a data is enter in another combo box. It does okay at generating a...
  19. V

    Report Header

    Thank You Already played with visble on and off. The code does it in design mode. I was just hoping I didn't have to do it that way. The report is quite large. Lots of pages, takes a little while to process, becuase each group of data has it own closing page with report header and footer...
  20. V

    Report Header

    Is there a way to make the Report Header and Report Footer print out as the last page. I would like to put grand totals on this page without any addtional information. thx
Back
Top Bottom