Search results for query: *

HI Remou! I think you're expressing yourself extremely clearly, actually. I'm going to stick with my kludgy workaround for the time being since I'm time-limited on this project but I'll try your suggestion once things free up a bit. thanks again for checking this out! J

Hi Remou, thanks for your suggestion, and sorry for the delayed response. I've been fiddling with the concept for most of the last day or so, unsuccessfully, so I think I'm going to revert back to a bound combobox for the group and struggle with the consequences of that move later on. Super...

Hi Remou, thanks for replying to my post! Unfortunately, here's where the puny brain issue comes into play: I'm stumped by the circularity of using cboGroup to filter cboClient, and then (trying to) use cboClient to fill in cboGroup. It seems like there must be an easier, more logical, more...

Hi listers, Help, please. My brain is a puny thing. I have a "Projects" database that includes these tables and relationships, among others: tblProjects - pkeyProjectID fkeyClientID tblClients - pkeyClientID txtClient fkeyGroupID tblGroup -...

OK! It works--not elegantly, but for now that's just fine. I'll tinker with the details and hopefully it will improve somewhat. Thanks again for the helpful advice-- J

Thanks for the replies! Unfortunately, I'm too much of a newbie to effective use of either one. RoyVidar, after combing through the TT site for more examples of filesystemobject use, I still can't figure out where to put the code. On Enter? Focus???? Even the microsoft filesystemobject...

Hi all, I'm facing meltdown in the face of what is most likely a very simple operation. I set up a command button on my form to call an external application, which outputs a *.csv file. The file consists of a number of rows and columns of test data results. There are 2 things I'd like to do...

Thanks for the help! I'll tinker around with the command and see what I can get to work... J

Sorry for being so vague--I know it's hard to give advice on a concept that's still in development. As I understand it, a user would be able to, say, push a button in Access to fire up a LabView GUI. The user would then use the GUI to perform some sort of test. Theoretically, LabView could...

Hi all, because I've tinkered with Access a bit, I've now been asked to be an advisor on something much more ambitious: an inventory database that will allow the user to call an external application (in this case, LabView) which will perform some test, and return a value. Ideally, this value...

In order to cut down on redundant typing, I've set field values to default to the values in previous records. The problem results from one particular value of the combo box cmbProjectType that is supposed to trigger the visibility of a text box (txtMapCopies). I.e., if cmbProjectType =...

Ok, got it. The answer was in another thread705-64857: "to refer to the Pages property in a macro or Visual Basic, the form or report must include a text box whose ControlSource property is set to an expression that uses Pages." So, I inserted a text box in the footer and set its...

did you ever solve this problem? I'm running into it at the moment, and I'm stumped. thanks, J

I get a messagebox that announces "I am currently on page 2", but (unfortunately) no sign of the other messagebox. In another post (http://www.mvps.org/access/reports/rpt0013.htm) about first/last page numbers, I found what may be a clue: "Until access has finished formatting...

I added a breakpoint in the code. When the report opens the code pops up, and if I place the cursor over the variable me.pages it always reads "Me.pages = 0". Me.Page, on the other, increments nicely as the program steps through to the next page. Aaargh! J

Hi natatbh and Paul, thanks for responding. I want the text to come at the bottom of the page, not after the last record; that's why I'm using the page footer section. My main concern is that "me.pages" is always 0--it doesn't increment, no matter how many pages long the report is...

Hi all, I've put the following code into the page footer section in order to keep the "Submitted By" text on the bottom of the last page only. However, the only value "me.pages" ever has is 0, so it doesn't work. Can anyone point out where this went awry? thanks! J...

Nice! I didn't know about Switch, but it worked perfectly and looks much cleaner. Thanks for the explanation of the fields, as well. One puzzle down, 1,000,000 yet to solve... appreciatively, J

Errr, sorry folks, I solved it, though I didn't entirely answer my own question. If I put the expression directly into the unbound text box, it works beautifully. If I put it in the Detail_Format section of the report, I get errors about the fields not existing. Why, I don't know, so if...

Hi all, I'm trying to generate a report showing projects and clients in a given month. All well and good. The bad is that there are Individual clients, Miscellaneous clients, and regular clients. Individual and Miscellaneous clients have an associated name or organization; regular clients...