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 strongm 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: *

  1. Mandyxoxo

    Information input on form to be shown on report

    I have a dialog form that pops up to retrieve dates for a report. The form works and then takes the dates and generates the query based off of those dates just fine. However, the query only outputs a single Total and therefore the dates are in a subquery. I want the report to say on it which...
  2. Mandyxoxo

    CommandButton to Populate Month in textbox

    It is all fixed. Thank you for your help!
  3. Mandyxoxo

    Information Input on Form to be Shown on Report

    I have a dialog form that pops up to retrieve dates for a report. The form works and then takes the dates and generates the query based off of those dates just fine. However, the query only outputs a single Total and therefore the dates are in a subquery. I want the report to say on it which...
  4. Mandyxoxo

    Possibility to print all VBA code?

    You should just be able to do...file...print...and then click the check box that says Current Project. It will then print all of your modules, forms..etc.
  5. Mandyxoxo

    How to implement where clause in subquery

    I did that and it gives the error Invalid bracketing of name and then includes the entire subquery in the error message....
  6. Mandyxoxo

    How to implement where clause in subquery

    I did what you posted. It gives me an error saying: Syntax error (missing operator) in query expression EntryData_2008_02_to_04.EntryDate BETWEEN Forms!Date Prompt for Total Granted Access!Text0 And Forms!Date Prompt for Total Granted Access!Text2 Any ideas why?
  7. Mandyxoxo

    How to implement where clause in subquery

    I built a query to take totalcount of distinct cardnumbers of individuals accessing a datacenter. The code looks like so: SELECT Count(EntryData_2008_02_to_04.CardNumber) AS TotalCount FROM [Select DISTINCT EntryData_2008_02_to_04.CardNumber, EntryData_2008_02_to_04.EntryDate FROM...
  8. Mandyxoxo

    CommandButton to Populate Month in textbox

    I have created two different forms and neither work. What reference should I specifically try adding? That is probably it...
  9. Mandyxoxo

    CommandButton to Populate Month in textbox

    The information in the text boxes are taken and are run through a query that generates the report with the dates specified. However, the text boxes themselves are unbound. In the textboxes, the commandbutton can be used to populate the text box or the user can input their own dates. The...
  10. Mandyxoxo

    CommandButton to Populate Month in textbox

    I am trying to build a form for the user to pick date constraints. The form has two text boxes, one called txtStartDate1 and txtEndDate1. Below the two text boxes there are four command buttons. The first command button is labeled today and if pressed populates today's date in the text boxes...
  11. Mandyxoxo

    CommandButton to populate current month in textbox

    I am trying to build a form for the user to pick date constraints. The form has two text boxes, one called txtStartDate1 and txtEndDate1. Below the two text boxes there are four command buttons. The first command button is labeled today and if pressed populates today's date in the text boxes...

Part and Inventory Search

Back
Top