Search results

Okay, I am doing the count with a DCount however I have run into the problem of it counting extra days? Me.A.Value = DCount("[ticket]", "tbl_ticket", "[entrydate] Between #1/1/2013# AND #1/31/2013#") I should have 26 records show up, but for some reason this code is pulling the first...

OKay, driving myself a bit nuts with this. I am trying to get a total count of rows from a query on my tickets, Each ticket has a date and an ID number SELECT tbl_ticket.ticket, tbl_ticket.entrydate, Count(tbl_ticket.[entrydate]) AS [Row Count] FROM tbl_ticket GROUP BY tbl_ticket.ticket...

I am trying to set up a form that gives me the following style of output for my ticket system and I can't seem to figure out what I am doing wrong. 0-30 31- 60 61- 90 etc Ticket Catagory 1 Ticket Catagory 2 Ticket Catagory 3 Ticket Catagory 4 I...

I found it, I was trying to edit the subform in the main form. The navagation button option isn't avalible in the subform

Yes, the navigation buttons at the bottom of the form.

Okay, I have tried hiding the subform's footer but it still shows up. I am trying to hide the bottom part in access 2010 where it has the search bar and record count. How can I hide this?

Thats what I was missing, the .column(1) Thanks, I am really new to all this VBA coding

Mr. Dudden I tried that method and it still trying to append 0 records. Is there something I am missing? Do I need to declare assigned as a string for SQL to see it as such?

Okay I am having issues with my query for my database Private Sub Combo2_AfterUpdate() DoCmd.RunSQL "INSERT INTO tmp_ticket (ticket) SELECT ticket FROM [tbl_ticket] WHERE assigned LIKE ""Me.Combo2""" End Sub It sort of works, it trys to append 0 rows! What I am trying to do is get...

I just don't understand what I am doing wrong. I have a test table set up with 3 columns An ID colum with Auto number, a column for the Description and one for the SQL I set up a form with the field set to Text for the SQL command and put SELECT * FROM Customers in that field, but when I...

[Solved] Storing SQL Queries to a table I can't seem to find it and this has to be the last bit of stuff I need to get my Database up and running for my boss using an EXE front end. What I am trying to do is something similar to what I did for my reports I have a table with the following...