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: madrappin
  • Order by date
  1. madrappin

    CountIf statement trouble

    I think if you use <> instead of = it should work.
  2. madrappin

    CountIf statement trouble

    Ok, thats perfect! What I was doing wrong was, rather than selecting a range like A1:A10, I assumed doing A:A was acceptible and it was giving me an error doing it that way. I guess thats because the two ranges have to be equal sizes? Whatever the reason, you all helped me out a lot. Thanks
  3. madrappin

    CountIf statement trouble

    But that gives me the product of the two different ranges doesn't it? I need it to count a range. My actual spreadsheet is much larger this is just an example. 1 2 1 A B 2 A A 3 C A Something like that, and i want to count the rows where the data in both columns...
  4. madrappin

    CountIf statement trouble

    Hmmm, not quite. Because the two sets of criteria are in different ranges. I want to count the number of rows that have "apples" in one column and "oranges" in a second column. I appreciate your input. Thanks.
  5. madrappin

    CountIf statement trouble

    I am trying to use the countif() function, however I need to specify 2 sets of criteria. Basically, I need to write something like =CountIf(A1:A20,"Apples" and "Oranges") I know what I wrote above wont work the way I have it, but is there anyway I can get the desired affect? Thanks.
  6. madrappin

    Help with Date Fields

    Thanks a lot! You have helped me through pretty much all of my coding problems, and I can't thank you enough for helping out the beginners like myself.
  7. madrappin

    Help with Date Fields

    I am trying to use vb code to specify a filter that a report is opened with. So strfilter is what I use in the docmd.openreport, however I can't figure out how the string is supposed to look. What I have is... strfilter = strfilter & " tblData.[RR DATE] BETWEEN 10/31/'&Me.txtFiscalYear-1&' AND...
  8. madrappin

    Exporting to excel

    I use this code to export a query that the user selects into excel. Private Sub btnSaveTo_Click() Dim FilePath1, FileNamePath1, Dataexport FilePath1 = LaunchCD(Me) strName = lstQuery.Column(0) If FilePath1 = "" Or IsNull(FilePath1) Then Else FileNamePath1 =...
  9. madrappin

    Calculate between certain dates

    Awesome that works great! Thanks
  10. madrappin

    Calculate between certain dates

    Can anyone help me type this up right? The error I keep getting is "Error: Expected End of Statement" with the BETWEEN highlighted. Everything looks right to me, but I'm not very good with VBA. Thanks for any help. DoCmd.OpenReport Me.lstReport, acViewPreview, , tblData.[GC DATE] BETWEEN Now()...
  11. madrappin

    Problems with listbox

    Sorry to post twice in a row, but this whole "thinking things through" thing is not my strong suit... Would it make more sense to not use any lookup fields in the table at all, and just use them in forms when needed? or would that still create the same problems?
  12. madrappin

    Problems with listbox

    Well, I am a little confused because the relationships are all setup, and if I use SQL in a query to see those fields, the lookup still works. However when I use that exact same SQL in the rowsource, it is giving me what the field stored. Is there another way to write the SQL to make the lookup...
  13. madrappin

    Problems with listbox

    I am using code that to fill the rowsource of a listbox, however 2 of the fields that I am using are comboboxes that pull their lists from another table. So when the listbox displays it shows ID value rather than the value selected from the table. How would I set up the listbox to display other...
  14. madrappin

    exporting to excel

    And thanks, yet again for the excellent help. That works perfectly!
  15. madrappin

    exporting to excel

    In the rowsource just use... <code> SELECT [MSysObjects].[Name] FROM MsysObjects WHERE (Left$([Name],1)<>"~") AND ([MSysObjects].[Type])=5 ORDER BY [MSysObjects].[Name]; </code> There is FAQ that explains how to pull any of the objects into a listbox. faq181-690
  16. madrappin

    exporting to excel

    Thanks a lot! That works perfectly. ...Just out of curiousity, I know how to make a multi-select list box of all the queries that I have. Is it possible to replace the part of code with the query name with the value from the list box? I think I know how to make that work if its possible only...
  17. madrappin

    exporting to excel

    Thanks a lot! That actually works perfectly. I dont really even need the report. I just set up a few queries and export those. If you could tell me how to give the user the option of where to save the file that would be great. I would also like to know if its possible to set the font that the...
  18. madrappin

    exporting to excel

    I dont need to export only the one record. I have a form that I use to set which filter I open this report with. Then I need to export the report into excel. I would like to set it up someway that I can export each report that I filter into a separate worksheet, or if I can set it up all in one...
  19. madrappin

    exporting to excel

    Is there any way to export a form into Excel, and automatically format it a certain way? Or export 3 or 4 reports into one excel file as separate worksheets? Thanks for any help.
  20. madrappin

    Auto fill a field based on seperate field

    Thanks! That worked perfectly thanks for your help.

Part and Inventory Search

Back
Top