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: Zirak
  • Order by date
  1. Zirak

    Pros and Cons of using Dynamic SQL vs Stored procedure

    Hi, I'm designing a new application using a sql server backend. The application will basically integrate data from different departments. I am investing some time to design one main form where users can view data about every thing. Basiclly with a tree view on the left listing all departmetns...
  2. Zirak

    Multiple Databases vs One

    Thank you for your reply. It was very helpfull. Do you know where I can find some resources on this issue? Thanks
  3. Zirak

    Multiple Databases vs One

    Hi, If designing an Enterprise Resoucrce planning application, what is the pros and cons of having multiple databases set up (sql server 2000) that the appliation will use vs having one huge database that integrates all the data. For example having a databases for Accounting, Operations, Human...
  4. Zirak

    enterprise manager equivalent in MSDE

    Hi, I have a SQL Server 2000 (Sp3) on my laptop (personal edition). I also installed an intance of MSDE and upgraded it sp3 on the same machine. How can I connect to the MSDE intance from EM. When I try to add a new SQL Server registration it won;t list my MSDE instance. Thanks
  5. Zirak

    Narrow down a ListView when typing

    Thanks for your reply. I know that the on change event fires when user types and thats what i want. This way as they type they can imedietly see the result list and ofcourse it at least three letters need to be typed.
  6. Zirak

    Narrow down a ListView when typing

    Hi, I have a listView control. I populate the control by looping through a recordset that I retrive from a table. I also have a Search text box that I let the user type what they are looking for and it will narrow down the result as they type. On the "OnChange" property of the text box I build...
  7. Zirak

    instantiate a form object by its name in MS Access

    In order to load the next subform I set the Sourceobject of the subform to the new form. Is there any way to keep them open? The only way that I know is to have all subforms open is to have them all directly on one another and make them visible or invisible. But thats not the right way to do it...
  8. Zirak

    instantiate a form object by its name in MS Access

    Thank you for your reply, I actually did what you mentioned buth the problem is that i will have to cut and paste the code in each subform for every wizard. As you can imagen its going to be difficult to maintain. Rather, I want to have a function that gets the form name and populates the...
  9. Zirak

    instantiate a form object by its name in MS Access

    Hi, I am trying to build a wizard in ms access. The wizard wil have several forms which load as subform one by one in the main parent form. Any way, before moving to the next form I need to pass the variables from the previus form. I am trying to write a resuable module so that I can apply to...
  10. Zirak

    NEED HELP:dynamically passing variablesto subforms

    Thanks for your reply! Its giving me a typemistmatch error. When I put the mouse over the code, its getting the correct string as the form name but apprently the "CurrentProject.AllForms(FormName)" code can't set F as a Form. The only way I can set it is to use the actual form name like...
  11. Zirak

    NEED HELP:dynamically passing variablesto subforms

    Thanks, the collection object was what I was loooking for! I have another question though: How can I dynamiclly set the a Form variable to a form in the form collection by passing the form name. I tried the below but it didn't work: Public Function UpdateProductCollection(FormName As String)...
  12. Zirak

    NEED HELP:dynamically passing variablesto subforms

    Thanks for your reply. How can I keep the subform open? I have a main form and there is a subform field on the form and based on the process I set the "SourceObject" property of the subform. Is there a way that I can keep the previus form open? I used to use frames with embedded VB and load...
  13. Zirak

    NEED HELP:dynamically passing variablesto subforms

    Hi, I am trying to build a wizard structure that I'll be able to reuse. I have the main form and a subform. At each step, the user enters information on the subform and hits a "Next" button, the data is validated and based on the data another subform will be presented. My problem is that I need...
  14. Zirak

    Working with Frames in Access

    Hi, I have developed some applications using embedded VB. In eVB we have frames that we can show on the forms and order them at runtime throuh zOrder property. Can we do somthing like that in MS Access?
  15. Zirak

    Seeting the row source value of a list box to parameter SP

    Hi, I'm trying to set the row source of a list box to a parameterized SP through code. If I set the ro source to a SP and the parameter is the same as one of the fields in the form its OK. But if I set the row source to somthing like Me.ResList.RowSource="dbo.SP_getResult @prm='" & intID & "'"...
  16. Zirak

    Executing command causes Access adp to lock!

    Thanks. i solved the problem
  17. Zirak

    Build a Wizard with Access Form

    Thanks for your reply. I wanted to open several forms but in a wizard like format (like the switchboard). My problem is that I previusly had a form without the required validation. Now I want to out the validation in, but since the fields on the form are referenced by other modules I don't want...
  18. Zirak

    Build a Wizard with Access Form

    Hi, I need to build a wizard like interface in Access. I have a form which enables users to insert new records, but I need to step users through the process and validate the info they are typing in. I order to do so I want to load several screens, that after each step is validated I send them to...
  19. Zirak

    Executing command causes Access adp to lock!

    Hi, I have a VB code that executes a parametrized stored procedure. The SP has one input and several output parameters. The SP works fine in SQL (Query Analyzer), but when I run it through code, MS Access hangs. The funny thing is that the same module worked for a while, but suddenly it started...
  20. Zirak

    Table Naming Standard

    Thanks

Part and Inventory Search

Back
Top