Search results

  1. S

    Pass-Through Query works in SQL Server, won't work in Access? Lost

    Hi everyone, My company has decided to stick with MS Access as the Front-End UI for our basic needs with the backend being held on a local SQL Server. I am in the process of writing pass-through queries that I will then build forms and reports from within the UI and am having some trouble...
  2. S

    Query That Uses Different Columns Based Upon User Input

    Hi all, I have a database table in which I'm trying to pull sales data and generate sales reports from. The problem I face is that the sales data is recorded into a table with this structure: Year | Customer | Sales_Month_1 | Sales_Month_2 | Sales_Month_3 Rather than having a single field...
  3. S

    Navigation Form - Using My DB's Forms under it's SubForm Control

    Hi all, Been actively trying and searching for a solution, however to no avail in the past couple of days. So here I am. I am attempting to create a Navigation Form to allow another computer in my network to be able to utilize necessary forms within a database (through RunTime). I was hoping...
  4. S

    Help with Populating Fields in a Tabbed Subform

    Hey everyone, I have a Form that keeps records of each Machine my company has. It contains a Tab Control with 5 tabs (pages), each containing one subform in them. In one of these pages, I have a Preventive Maintenance subform that contains records with information. One of the fields (Repairs)...
Back
Top Bottom