Search results

  1. W

    Filtering data from another table

    Hello all. I'm trying to filter data between two tables. I've created a table that has a date field that is used as a reference, so I don't have to put the same date in everyone's record in my second table. My sexond table has personnel data. I'm trying to create a query that will filter out the...
  2. W

    Solved Disable 'Enter' key for Login form

    Ok, greetings all and thank you for reading. I have a login form and it's working as intended, mostly. The issue I have is that when someone attempts to login and instead of using the 'Login' button which houses all the code they naturally hit 'Enter'. This however does not login as their...
  3. W

    Solved Login Form

    So, I've been putzing around with this code for a few days now for a login form. Everything seems to be working correctly except I cant get passed the strSQL. It pops up a "Run-time error '3061': Too few parameters. Expected 2." I'm using a thread from the following link...
  4. W

    DateDIFF with IsNull

    I have an expression that is currently working in the format of x year(s), x month(s), x day(s), but if the result does not have a value in in each category I want it NOT to display that group. Such as if the return is 5 months and 16 days, I want it not to display the years segment. Below is...
  5. W

    Exporting Query with linked subdata in same format

    Hello all, I'm pretty new to forums so please bare with me. I have a database that collects vasts amounts of data and then I have Queries that allow me to view selected items and so forth. I have a Query built that pulls data and then I have a subdata link that shows orders against the main...
Top Bottom