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

  • Users: nexus
  • Order by date
  1. nexus

    VBScript .vs. JavaScript

    Rose:<br><br>Personally, I think your best bet would be to write a server side script that returns a static recordset.&nbsp;&nbsp;it's harder to work with (checking all changes/additions/deletions when the user submits changes) but it solves the compatibility issue.<br><br>p.s. I've only done...
  2. nexus

    Need a method to pass a collection between two functions or subs

    I'm trying to create a collection in one sub, and pass the results into another sub.&nbsp;&nbsp;Is this possible?&nbsp;&nbsp;TIA.
  3. nexus

    Installation Problems

    apologies, I should have been more specific.&nbsp;&nbsp;The problem in particular is with an application we are developing, and the program works fine when the user manually creates the shortcut, but we don't want to have to document this &quot;workaround&quot;.&nbsp;&nbsp;We would like to know...
  4. nexus

    Office97 ODE Application fails in Win2000

    An application created with the Office97 ODE (an Access application) doesn't install properly in Windows 2000.&nbsp;&nbsp;The installation runs fine in both Win95 and Win98, but when you install on a Win2000 machine, the install can't create the application shortcut.&nbsp;&nbsp;Anyone know what...
  5. nexus

    Want to program more in C

    Hey folks.&nbsp;&nbsp;I'm a student who has taken a few C programming courses, and would like to program more in C.&nbsp;&nbsp;My problem has always been thinking of something to program.&nbsp;&nbsp;I would like to slowly work my way up in difficulty, but I have no idea what kinds of projects...
    • nexus
    • Thread
    • Replies: 3
    • Forum: C
  6. nexus

    Installation Problems

    Running an installation program that refuses to create a shortcut for the application.&nbsp;&nbsp;Possibly something changed with the ODE tools, anyone have any ideas?&nbsp;&nbsp;TIA.
  7. nexus

    master/subform code - cross referencing fields

    need some help with a master/subform issue.<br> <br> I need to generate an SQL query to populate a combo box in the subform based on a field on the master form. I'm not sure if I should be doing this in an event, or a function. My other problem is limiting the number of records possible based...
  8. nexus

    locking all fields on a form based on a field

    I was wondering if there was some easy way to lock all fields on a form based on the value of one field. Thanks!
  9. nexus

    Need to check Naming Conventions (string manipulation)

    don't ask me why we need to check naming conventions. anyhow, seems they don't care about runtime, so I'll just write crude but functional code! I'll be working for Microsoft in no time... hehehe. Thanks for your help!
  10. nexus

    Need to check Naming Conventions (string manipulation)

    Hi! I need to make a function to check that users are following a specific naming convention. I'm thinking about making an array with all the acceptable characters, or an array with all the unacceptable characters. However, each time I need to check a string, I'll have to compare every...
  11. nexus

    Which book is the best for Access/VB?

    I too have been searching for a good book to learn Access programming. However, I have found that many books that talk about &quot;learning&quot; Access simply refer to using the database, not programming VBA. I can't say I've seen any of the books you've listed, so I can't advise you there...
  12. nexus

    Standards

    Coding standards are tough to put in stone. Everyone has their own stye. Here at my job, they don't have anything on paper, just general rules of thumb. For example, the general format of a function, subroutine, or event handler is usually:<br> <br> Private Function Foo(blah)<br> On Error...
  13. nexus

    Field can't be modified after initial insert

    I got it! used the GotFocus Event of the field and said if the value isn't null, lock it, else unlock it. THANKS GUYS!
  14. nexus

    Field can't be modified after initial insert

    Thanks for the help. If I try locking it in code, it locks ALL the fields on the form, and I can't enter new records. I'm pretty sure the subform idea would work, but I won't be able to implement it until I get some sort of approval.<br> <br> I like the locking idea, but is there any way to...
  15. nexus

    Field can't be modified after initial insert

    I'm not sure if there's some function in VBA that let's you specifically prevent updates on certain fields, or if I have to put some code behind the field. Once the user inserts a value in the field, he shouldn't be able to change that value. However, deleting and re-entering the record is...
  16. nexus

    Requerying a Subform

    Thanks, the forms are linked. I wasn't sure if it automatically requeried...
  17. nexus

    Requerying a Subform

    I need to be able to requery a subform when the master form changes from record to record. Do I just put a <br> Forms![subform].requery in the BeforeUpdate or AfterUpdate event of the Master form? TIA...
  18. nexus

    Slow Response to New and Delete operations

    We're running through an Access front end against a large Oracle database. Lately, there's been a slowdown in the Access application when we create new records or delete old records. However, if we run the operations (create or delete) directly through the Oracle database, it takes much less...
  19. nexus

    Function placed in Incorrect Event causes Access to lockup

    I believe I've incorrectly placed a function in the wrong event. The database starts up with a startup screen on a timer, but I may have left the OnTimer event blank, so now Access locks up. Is there any way I can modify the code behind a form without opening the database? TIA...
  20. nexus

    Beginner's introduction to Oracle 8 book?

    Reasonably familiar with RDBMS and SQL. Thanks for the help!

Part and Inventory Search

Back
Top