Search results for query: *

I have an Access report whose source is an SQL server stored procedure. This stored procedure has a parameter to which a value must be assigned. Rather than have the automatic message box appear prompting for this value when the report is run, I would like the report to automatically pick up the...

I have a function which I want to run each time any form is opened. This function checks the id of the user, and dissables any controls on that form not relevant to them. I want the function to run for whichever form is calling it in the load event, but I can't work out how to refer to the...

Thanks Rob, I'm still stuck on taking it one step further and getting the result of that command to show up on a report. Any clues?

None of the previous threads have quite answered this for me. I have created a datareport which has a dataenvironment datasource, and a stored procedure command datamember. The stored procedure requires an input parameter, and this appears on the parameters tab of the command's properties. How...

How do you go to the record in the subform? I understand what you're saying about the combo_box's auto-complete feature, but how do you code the search into that public function? Also, where do I find Microsoft Knowledge Base? Thanks!

I have a database on a SQL server and I am developing an Access 2000 project front end. I need to create a table which the user can then key information to via a bound access subform, bound to this underlying SQL table. My problem is that when I try to do this, the table does not allow rows to...

I have a subform on my form which is there to serve the purpose of a datagrid. It isn't bound to any view/table etc. The subform is simply a row, in the detail section, of unbound text boxes. I just want it there for the user to enter order information in those text boxes, for as many rows as...

If a user enters text into a text box, we check in the 'after update' event that it fits the criteria required. If it doesn't, how do we force the focus back onto the same text box to make them re-enter? At the moment, the focus is moving to the next tab stop, even with a command in the 'after...

Thanks for your help Joe, but I'm still having a few problems. When I open the main form in design view the subform is blank, apart from the name of the stored procedure it will be populated from. The only time I see the columns is when I go into form view. I've adjusted the columns here and...

I have placed a subform on my main form, and its source object is a stored procedure. How do I set the column widths within the subform? I have a feeling I must be missing something very obvious here, but I am new to subforms, so bear with me. Additionally, I want the subform to display only the...

I've implemented the dropdown command into the form load event, and it's working. My next problem is that when I open the form, the left edge of the list box is not in line with the text box portion. Curiously, if I open the form from design view, it is in line. But when I call the form from...

Can I force a combo box to automatically display its list box portion, without the user having to click on the little arrow? The combo box does exactly what I want, as in it searches dynamically down the list and highlights the match as the user types what they want to find, but my spec demands...