Search results for query: *

Zameer, Thank you for your posts. I have implemented the forms as you suggested, and they work well. Having fifteen queries and subforms is, I think, better than having VBA code to do all these. Thanks again. toryee

Thanks Zameer. Give me a day or two to work on this, and I'll get back to you. toryee

Zameer, Thanks very much for your input. I think after creating the fifteen queries, I still need to use a separate subform for each query. Am I correct? toryee

How should I redesign everything such that what I want can be achieved? Can VBA be an alternative? By using VBA so every field is linked dynamically? toryee

Not to worry about tabs. I made them hidden initially and make them visible depending on the 'number of children' text box on the main form. I have fifteen tabs, assuming a family has no more than fifteen children. I know it's bad design, but it works mechanically. For each child record, there...

I have a form, it has tabs and each tab has a subform. These subforms are of the same kind. The main form data and the subform data have a one-to-many relationship. Instead of using the default Access record selection in the subform, I need to make each record appear in a subform of a tab. For...

Good idea. Thank you Ken. toryee

I have a form and there is a command button and a tab control on this form. The form initially opens in normal view. When user clicks the button, the form changes itself to design view, by using docmd.openform. In the design view, a page is (supposed to be) added to the tab control. Problem...

Thanks very much for your help Geoff. I'll go with a custom menu for now. Tory

> And you are happy to use VBA ?? What does this mean? I just think one menu combobox looks better and more user friendly than making multiple cell selections. I probably will using the latter given your suggestion. thanks. Tory

I don't really know; whichever works. I don't know enough to know the right terminology. I have found this thread thread68-578865, which is exactly my question, but the answer to it, the dependent list, is not what I'm looking for. I want everything in one dropdown list, as per the first post...

I guess everything was in my head. I worked on putting the combobox on the sheet, and realized I don't know how to attach the combobox to a cell of the spreadsheet. I tried setting up the Data, Validation for cell A1 and have the following code in a procedure: cbo = "Apple, Pear, Orange" With...

Is there a way to create a drop down menu in a combobox in Excel? I don't want the dependent list in Data Validation, I want everything in one combobox. For example, if the user clicks on the combox, Level 1 choices: Vegetable Fruit Then if Vegetable is selected, Level 2 choice for...

Hi, I suppose you mean making a call to SQL Server from a VBA application. Performance gains would mostly depend on the number of records you need to manipulate in your query. The larger the dataset, the more beneficial it is to execute the query in SQL server. I have a 1.6GHz machine and...

Thank you guys for your inputs. I did search on 'intersect target' and have found some helpful posts. Anyhow, I got it working using Worksheet_Change with EnableEvent property. Regards, Toryee

Hi, I'm using Excel VBA and I need to check the value of a cell after the user updates it. This check needs to be performed for all cells in a column. I think I probably need to use an event handler, but don’t quite understand how they work. What's the concept and syntax for event handler...

I have trouble understanding the following two fields in an Access query and the differnces between them. Any explanation is appreciated. 1) emp: sum(IIf([employee].[age] = "45", [employee].[salary], 0)) this is a column with 'Expression' under 'Total' 2) Expr1...

Thank you for the help VBSlammer. The code works well with my program. tory

Hi, I'm trying to import Excel worksheets into Access using VBA, and the destination Access table is a linked table to SQL Server. Some cells in Excel have division by zero error, as #DIV/0!. When such field is encountered, import process gives me the error '3349, numeric field overflow'...

Hi, I’d like to debug a stored procedure that is on the sql server but is executed from Access. The stored procedure also uses the parameters passed in from Access. How do I step it at run time? What’s the best way to do so? Thanks.