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

    Close Report from Report_Detail

    you're the man, thanks for the help.
  2. jimb0ne

    Close Report from Report_Detail

    I have a report in which I populate many fields from the Detail_Format section of the report using code. The report is based on a parameter query which allows the user to enter a specific sample number when the report is opened. If there is no associated sample for the number which the user...
  3. jimb0ne

    Wilcard parameter in query

    thanks, but this does not seem to work. I can't seem to get a wildcard value to work at all, I suppose I will just have to change the SQL string for the query to check for numbers > 0 and then change it back at the end to check for a specific parameter. I'm quite surprised you can't just enter...
  4. jimb0ne

    Wilcard parameter in query

    Hi again folks, Having trouble with a query I'm trying to open. I have 2 parameters in my query, date and treatment number. The problem is that i'm trying to say "any treatment number with a specific date" from code and cannot figure it out. I don't want to mess with my SQL string, what I'm...
  5. jimb0ne

    Problem with date SQL

    hi guys, yeah I have tried just the date, but I had a problem on the original computer with the short type (mm/dd/yyyy) creating a problem, and it worked when I changed the type to vblongdate, on this other computer though the shortdate type works, and longdate doesn't work. It must have...
  6. jimb0ne

    Problem with date SQL

    Hi folks, I have a problem with a date lookup in an SQL statement. Basically I have a date field in a query, I'm using the findfirst method recordset.findfirst "Date = #" & formatdatetime(datestring, vblongdate) & "#" this worked fine on one computer, upon moving my database to another...
  7. jimb0ne

    Find recent date

    thanks guys, I think I've figured out what I'm gonna do, its not the smoothest way to go about things, but it seems to work. thanks again for the suggestions.
  8. jimb0ne

    Find recent date

    I have a database containing testing information. My problem is that for each test there is an associated date and subtests within that test. A specific subtest may not have been done for a test, if this is the case I want to be able to find the date for the last test like it that was done...
  9. jimb0ne

    Draw Lines on Report

    thanks aceman, the problem isn't with creating lines, its with their relation to the report. So for example, if I had a control on my report, say a textbox, that appeared on the 3rd page of my report, the top property would have a value of something like 20000(I have my scale mode set to...
  10. jimb0ne

    Draw Lines on Report

    Hi, I'm having a problem drawing some lines on my report. I'm trying to draw a graph from code(I know, I know) but at any rate, the problem is that the graph is on the 3rd page of my report. My report has all the controls in the detail section, and I'm trying to plot points according where I...
  11. jimb0ne

    Fairly Simple

    heh, no, I couldn't remember what to use, and I'm running access in spanish so I'm totally lost when it comes to the documentation. Thanks again for the help, exactly what I need.
  12. jimb0ne

    Fairly Simple

    I have a problem in which from a main form, I got to subforms to enter information. The problem is the subforms tables are linked via relationships to the table from the main form, when I am entering a new record, the mainform information has not yet saved to the table when I try to enter data...
  13. jimb0ne

    Count of fields

    hopefully a simple question... I have 2 tables, one table is my main table, which stores doctor consultations, one field in said table is the name of the doctor who gave the consultation. In my second table I have a list of the doctors names, and the type of doctor which they are, eg...
  14. jimb0ne

    Filter a Listbox

    You are the man. I knew it was somethign easy, I was about to go ahead and try to do everything in code. Im also workign in spanish access so the help is pretty useless (my spanish isn´t quite good enough to make sense of it). thanks a million guy. jimb0ne
  15. jimb0ne

    Filter a Listbox

    This is pretty newbie, but its been awhile since I've been at access. Basically I have 2 different tables, one called Programs and one called subprograms. My program table contains the TITLES of programs, eg, health, land development, etc. as well as a unique number identifying each program...
  16. jimb0ne

    easy SQL question

    thanks dood, that was it.
  17. jimb0ne

    easy SQL question

    I'm sql dumb, I'm trying to open a report based on a query which is based on a couple of tables. the wherecondition I'm trying to pass with the openreport method is the following: Unit = "Audiology" OR ExtraUnit1 = "Audiology" OR ExtraUnit2 = "Audiology"; I keep getting a syntax error when I...
  18. jimb0ne

    Print Report from Form button

    this article has all the info you'll want, thread702-672044 and this one is a little less in depth thread702-675417
  19. jimb0ne

    Print Report from Form button

    if you want to print a single record, wizzweb, you could just use the docmd.openreport, but set the wherecondition parameter to a value that is unique for the record you want to print, that way only that record would appear in the report. drewson and wizzweb, There is a post in this forum...
  20. jimb0ne

    How do I get a number under a condtion?

    yeah its ok, the only way you can start to learn. so basically you could have 3 unbound textboxes on your form. 2 of them would be Y and D, and the 3rd, the result textbox would be X. Name theses textboxes TXTY, TXTX and TXTD. Place a command button on your form, right click the command...

Part and Inventory Search

Back
Top