Search results for query: *

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

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

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

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

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.

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

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

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

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

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

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

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

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

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?

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 & "'"...

Thanks. i solved the problem

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

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

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

Thanks