Search results for query: *

I need to pass the name of a subform or form, (reference different subforms or forms, depending on what procedure I'm running) to a SUB in a module. Can anyone help? [sadeyes] I have tried searching the Access forums and the Faq's with no luck. All of those reference a particular subform, I...

I'm getting an error msg code 13, Type mismatch. In an Access 2000 module, I have the following code: Sub AddItemsToTable(ItemType As String, SelectedItem As Variant, Optional SelectedOptional As Variant) Dim strItemType As String Dim varSelected As Variant Dim varSelectOpt As...

Does anyone know of a Microsoft Access "Software Inventory" database application? I have searched the internet several times and can not find anything such as this. I am using Access 2000 to design a database where I can track all of the software that my organization purchases...

How to I clear form fields (record source is a query), once I have searched for and updated a record. I search from a combo box selection. I edit 3 or 4 fields. Then, I want to clear my screen, (the fields) and search for another record to update. Does anyone know how to clear (blank-out) form...

Can someone tell me how I can programmatically highlight (change the color of) textbox controls when "GotFocus" in the detail section only of my MS Access 2000 data entry forms? Thanks.

I have a table in which I keep all software titles. I frequently search this table and perform some action on the found record. I would like to make searching easier by selecting a record in datasheet view and automatically displaying the same record in single record form view. Does anyone...

How do you write a Select query statement in the Microsoft Access Visual Basic Editor screen using a variable in the where clause? Set dbs = CurrentDb() Set rst = dbs.OpenRecordset("Select * FROM tblProposalProducts " _ & "WHERE lngProposalID = " &amp...