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!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by EmployedAgain

  1. EmployedAgain

    Dynamic Form in a runtime version of Access??

    I haven't developed using HTAs. I started reading that and it looks like a possible solution, thanks. I'm thinking its going to be a major rewrite no matter what I do it in. TIA B
  2. EmployedAgain

    Dynamic Form in a runtime version of Access??

    I am assuming the answer is no from what I have read (ie no new objects). I have a complicated database I created for a client who now wants it distributed to people that may not have Access installed. Theres a form that deals with testing and the test is created on the fly as each one is...
  3. EmployedAgain

    Dynamic Form wont build after replication is set up

    Ah I hadnt thought of that! I dont generally use either of those features but that should work, Thanks! I'll give it a shot. TIA B
  4. EmployedAgain

    Dynamic Form wont build after replication is set up

    I have a database that builds a dynamic form through code every time it is needed. It worked great until replication was set up (using the built in replication wizard). Now it errors out when creating the dynamic form and setting the .hasmodule property. I assume it doesnt allow new forms in a...
  5. EmployedAgain

    Dynamic form creating form2 by default, how to reset or capture

    Thats it! I have removed all references to form1 and its working great, thanks much!!!! TIA B
  6. EmployedAgain

    Dynamic form creating form2 by default, how to reset or capture

    I was able to rename a form to form1 and proceeded to delete it and that didnt reset the autonumbering of the forms, just proved to me there wasnt a hidden form somewhere. I gave up and dumped all the objects and code into a new empty DB and that solved that issue. I swore there was a way to do...
  7. EmployedAgain

    Dynamic form creating form2 by default, how to reset or capture

    I have a dynamic form that was working very well until it crashed yesterday when I was changing the code and now instead of the default of form1 being created it comes up with form2 and of course the code breaks. I've looked everywhere for answers but havent had any luck. My 2 questions are...
  8. EmployedAgain

    Amount of time to setup Replication in Access 2003 ?

    I'm doing a quote for a client for an Access 2003 DB. I have never used the replication piece before and I am trying to get a good estimate for how much time it will take to set up. The database has about 30 tables, many of which wont change if that matters. They are going to be taking laptops...
  9. EmployedAgain

    Access Table Analyzer error could not update, item locked

    Has anyone tried to use the Table Analyzer to dedupe and normalize data? I have an Access 2003 database that a department created and used for a while with one table, of course. Its almost 40,000 records and extremely inconsistent. Now they want it deduped and split out into 3 tables. The...
  10. EmployedAgain

    Continuous form subform wont update w/out main form refresh

    I've been fighting with this form so long and thats all it was! Thank you! It seems to be working now. I did a recalc of the totals subform on the afterupdate event of a few of the option groups and so far so good. Some of the option groups are also continuous forms so its running on each answer...
  11. EmployedAgain

    Continuous form subform wont update w/out main form refresh

    I am working on a medical research DB with many Q and A surveys. One of them is large so I am using a tab control with subforms to hold each section of questions (questions pulled from a question table and score saved into an answer table). The last tab is the totals (answer scores). The totals...

Part and Inventory Search

Back
Top