Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BSSME
  • Content: Threads
  • Order by date
  1. BSSME

    Setting Variable via Query

    Hi All, I want to set a public (global) variable via a query in VBA for Access. I have an idea like this: Dim SomeNum as Integer SomeNum = "Select sometable.field from sometable where sometable.field=Form!frmform!field I think I'm close, but something is missing or I may be way off. Any...
  2. BSSME

    Crystal Reports 11 - Make Date Range Optional

    I'm working with Crystal Reports 11 and I needed to add a couple parameters to a report. However, these parameters need to be optional. As it stands two date parameters I added are currently required as the prompt dialog will not run the report without the dates being filled in. How do I go...
  3. BSSME

    Listbox Selection Not Letting Me Select Other Controls

    I have the following code on my form to assist with autofilling other controls on my form. This works great, however, once the county field value has changed I cannot move to other fields on my form. *******Begin Code******* Private Sub County_AfterUpdate() If IsNull(Me.County) = True...
  4. BSSME

    Filling fields on form based on value of ComboBox

    I’m trying to get certain fields within my form to populate from a table based on another control’s value. For example, when a user selects a county from a drop-down the fields for district number and job type should automatically fill with information that pertains to that county on the form...
  5. BSSME

    Stored Procedure Column Error - No Column Specified

    I was recently "elected" to add a field to a stored procedure but when I have everything in place I get the following: "Error 8155: No column was specified for column 14 of 'a'." I have colored the changes I made. Any ideas on what I am doing wrong or missing? Thanks! ***Begin Code***...

Part and Inventory Search

Back
Top