Search results for query: *

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

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

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

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.

Hi, I have created a table in MS Access. Mass manipulation such as deleting the records is very slow in Access so I’d like to have a table in sql server that links to this table. The Import/Export Wizard in sql server is not what I wanted because it copies the table from Access but not link to...

Hi, I have a stored procedure in Microsoft sql server, and it is called from Microsoft Access VBA code. Is there a way to step through the stored procedure and check of the result returned by the each sql statement? I have Microsoft SQL Server Enterprise Manager 8.0 and SQL Query Analyzer 8.0...