Recent content by Joallyn

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