Search results for query: *

you're the man, thanks for the help.

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

...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 a * value for a parameter in a query and have it return wildcard results....

...what I'm doing right now is the following: set qd = db.querydefs("queryname") qd.parameters("[date]") = date qd.parameters("[treatmentnum]") = "*" set rs = qd.openrecordset the problem is the * doesn't produce wildcard results, I need to figure out how i can enter a wildcard character for...

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

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

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.

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

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

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

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.

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

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

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

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

thanks dood, that was it.

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

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

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

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