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 Chriss Miller 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. Joallyn

    Unbound combobox doesn't display data

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

    Unbound combobox doesn't display data

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

    Unbound combobox doesn't display data

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

    Unbound combobox doesn't display data

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

    Import csv file into one record

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

    Import csv file into one record

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

    Import csv file into one record

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

    Call external application from within Access

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

    Call external application from within Access

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

    Call external application from within 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...
  11. Joallyn

    Default value winds up as Null

    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 =...
  12. Joallyn

    total number of pages problem

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

    Me.pages on report gives 0

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

    total number of pages problem

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

    total number of pages problem

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

    total number of pages problem

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

    total number of pages problem

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

    Reference field names in expression

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

    Reference field names in expression

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

    Reference field names in expression

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

Part and Inventory Search

Back
Top