Search results

  1. N

    Upsize from Access to SQL Server

    Hello! We are in need of upsizing our Access database (built on 2010 but I'm still on 2007) to SQL Server (I believe we have 2008 but it could be 2012). I'm told it's relatively easy but I am fairly new to Access and I know practically nothing about SQL. I've been reading about it on...
  2. N

    CountIf alternative for form

    Greetings! I have a form where I'm trying to display the count of records. Originally, the Control Source for the field that displays the count had the simple =Count([fieldName]) code but apparently it is counting fields containing an empty string. This field may have either a null value or...
  3. N

    Filter using wildcard

    Hello! I am relatively new to vba but I am working on a database built by my predecessor and I need help with a form filter. This form currently has a filter with the code: Forms![frmMenu]!sbfSubForm.Form.Filter = "endDate Is Null" I want to add another filter that looks at a serial number...
  4. N

    MS Access - trouble passing variable to function for use in query

    Okay, so I'm using a form to launch a query and I need this query to set the criteria based on what is being viewed in the form. I've researched and found that in order to use a variable in a query, you have to pass it to a function. Here's my code for the form that sets the variable: Private...
Back
Top Bottom