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 derfloh 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: *

  • Users: sonso
  • Order by date
  1. sonso

    setgenfilter with a boolean/logical value

    I found the solution. Sort of a gotcha: In Form2 (non-working) I had set the form filter to True (Yes), so that the form opened (without code) to filter to Yes. Once I removed that the form worked fine. So there is a wierd interaction between the compiled form filter and the switchIndex()...
  2. sonso

    setgenfilter with a boolean/logical value

    No values are being assigned. The field already has the values (showing "Yes" or "No" in the format of the logical field). As an interesting side-note, I could not interactively create the index (Logical,String,String) and had to use a script to CreateIndex from an array...
  3. sonso

    setgenfilter with a boolean/logical value

    Here is the code on the Pushbutton. The field object is called "Current". var ui uiObject endVar ui.attach(Current) if ui.switchIndex("CurrentStudent") then else errorShow() endIf The error occurs directly on the switchIndex command.
  4. sonso

    setgenfilter with a boolean/logical value

    I am having the same problem, but with a twist. I have two copies of the same form, with some minor changes in code on some objects. There is a pushbutton to ui.switchIndex() which is the same on both. On Form1 the code works like a charm and the subsequent ui.setGenFilter(dyn) works. But on...
  5. sonso

    DataTableView

    Cool idea! I already had a tabbed form, so this was easy to do (how dumb am I that it wasn't obvious!). The added benefit here is that you still have excellent code control over other actions on the tableframe. Thanks.
  6. sonso

    DataTableView

    I have received a request to enable tableview from a form, but I would like to allow only viewing and a return to the formview. I have told the user to use interactive filtering, but they insist on being able to view similar to an Access table. Is there a way to keep Pdox from spawning a new...
  7. sonso

    Problem with a Changeto query

    There could be a difference in the field type (e.g. Number vs. Short or Long Integer). We can't see your query, so save the query and post the resulting text file (Query.qbe) so that it can be better analyzed.
  8. sonso

    General Info on Paradox

    Access does some things well, but is quite inscrutable, and you have to write much longer code than in Paradox. Paradox makes a very robust front-end, and has the added ability to work with both SQL tables and local (PC type)tables. I would also say that once you try to move to the "next...
  9. sonso

    Form Filter

    How can you set the filter for when the form opens? In Paradox OPAL there is a method open(), but I can't find this in Access (97). Also, if you place fields individually in the detail record, it doesn't appear that there are any update type methods available (I get only mouse related events)...
  10. sonso

    How to get Network User Name?

    Actually, CurrentUser returns Admin, which I believe is the Access default login. The network user name is returned by the Environ("UserName") code. Now, how do I put this at the record level (as opposed to the field level) when I've placed a bunch of fields on a data entry field? I...
  11. sonso

    Data Entry Form

    Why not create a query that inserts the month for each copier in the master table? Thus you have a child table with Copier# + MonthEnd as the primary key.
  12. sonso

    How to get Network User Name?

    Is there a built-in function that returns the network log-in name? I am using Access 97 and want to put the username in the table whenever a record is changed.
  13. sonso

    How to Reference Subform

    I think you have to do something like: [Employees Subform]![StatusID].filter
  14. sonso

    Subform links (maximum of 3 fields?)

    I am using Access97, and it is limiting me to 3 links. I think I may need to upgrade the product.
  15. sonso

    Dropdown list of valid entries

    Is there a way to get a drop-down list of the valid entries for a field? I'd like the drop-down arrow to appear when the user lands on the field, and then the user can select the value...or start typing and get an autofill of the nearest value in the valid list.
  16. sonso

    Subform links (maximum of 3 fields?)

    Is there any way to get Access to accept more than three fields as the link to a subform (1-M relationship)?
  17. sonso

    Display read-only data from related table?

    ...Is there a way to display the related 1->1 data on the form? Also, is there a way to get the combo box list to open up (sync) to the actual related name? My list opens to the *first* last name that matches the last name that is displayed, rather than the one that matches the ID that was...
  18. sonso

    Append query doesn't work

    I was able to successfully run the query on two similar "import" tables. I removed the primary key from my main table (General_Ledger) but still got the same error message referencing Key Violations. Since there is no longer a primary key, I am now assuming that there is some sort of...
  19. sonso

    Append query doesn't work

    I'll check on the relationship thing. I wonder if it's similar to the error messages you get with Paradox and the BDE. In Pdox, if there's a field validation error when appending, the BDE reports it as Key Violation.
  20. sonso

    Append query doesn't work

    I used the query builder in Access and got: INSERT INTO General_Ledger ( ID, Row, DOCUMENT, [RULE CODE], ITEM, [DOC SEQ], [SEQ NUM], SERIAL, [DOC REFERENCE], [TRANS DATE], BANK, [POST PRD], SUBMISSION, REV, [NUMBER], SEQ, ACTION, [CMT TYPE], [BUDG OVRD], CHART, ACCI, FUND, ORGN, ACCT, PROG...

Part and Inventory Search

Back
Top