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

...the user chooses the Group, the cboClient box shows only those clients that belong to that particular Group. That part works wonderfully. What *doesn't* work is that since cboGroup is unbound, no group is displayed when I go back through the data I've entered previously. That makes sense...

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

...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 with those results: 1...

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

...to perform some sort of test. Theoretically, LabView could return the test result in any number of different formats--we had discussed having it be a *.csv file of n rows x m columns of values. The user would then close the GUI, and the *.csv file would be automatically imported into Access...

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