Hello all... I have a pretty easy one for you all here.
I have an Access 2007/2010 database that I developed. I have also created a "Welcome" page for it.
Here is my issue:
On the "Welcome" page, I inserted a "page" onto the page. On the "child page" I would like to show a listing of all of our vehicles. So I created a query from the Vehicles table and selected only...
dgaletar
Last Activity: Mar 28 '13, 02:03 PM
Joined: Jan 9 '13
Location:
-
Adding a datasheet as a subform/page
-
Right, the paragraph that says"To show the total of all the columns in the row, just add the value field again as a Row Heading"
But the issue is that the columns that display the sizes (12, 14, 18, etc.) are not in the same order. So if I add a "value field" to the query, it won't be adding the right totals. Right? -
Sorry 'bout that! I keep forgetting that I can do that...
...Code:TRANSFORM Count(SERVICE_SPECS.[CUA#]) AS [CountOfCUA#] SELECT SERVICE_SPECS.DS, Count(SERVICE_SPECS.DS) AS [Total Of DS], SERVICE_SPECS.PS, Count(SERVICE_SPECS.PS) AS [Total Of PS], SERVICE_SPECS.Rear, Count(SERVICE_SPECS.Rear) AS [Total Of Rear] FROM SERVICE_SPECS GROUP BY SERVICE_SPECS.DS, SERVICE_SPECS.PS, SERVICE_SPECS.Rear ORDER BY SERVICE_SPECS.DS,
Leave a comment:
-
OK, I (we) did it!!! Using a crosstab query I was able to total the sizes for each field seperatly; “DS”, “PS” & “Rear”. In other words, when I run the crosstab query now I get the following:
(See screenshot 1 [top table] below)
…which is correct as to the test data that I entered into the table.
The only issue that I now have is to be able to add up the sizes...Leave a comment:
-
OK, hang in there! I'm trying to do what zmbd asked. I'll be right back...Leave a comment:
-
Hey Seth, thanks for the info. Unfortunately I am still pretty stuck. I guess that my issue is with the layout of the tables.
The way that I have it set up now is (1) table for the list of wiper sizes (titled "Wiper_Size s"), and three fields added to the "SERVICE_SP EC" table. The three fields are labeled "DS", "PS" & "Rear" respectively.
When I try to create a crosstab...Leave a comment:
-
BTW, I just found this code in another forum. Does anybody think that I am on the right track by trying to use this???Leave a comment:
-
Trouble Counting/Separating Records
I am new to access (I am using Access 2010 version) and I am getting crazy. Consider also that I am a novice with DB in general, so now I am at the point that I am very confused... please help.
I have a database that keeps track of all of our work trucks. So far it has worked perfectly. Now my boss wants us to track how many of each size of windshield wipers we use. Now I know that this doesn't sound difficult, but it has driven me... -
Awesome! Thanks bud!
Somehow that was as easy as 1, 2, 3! Thanks!Leave a comment:
-
Thank you again, Seth, for continuing to help me through this.
I did as you said first, clicked on "Compile" under "Debug" and selected my database but nothing happened.
So I switched line 6 code like suggested and...
IT WORKS!!!
You did it Seth!!! Thank you sooooo much!
I'll have to figure out how to open the corresponding form from here, but THANK YOU!!!Leave a comment:
-
Sorry, I posted that before I saw your post.
1. From the immediate window:
2. I put "Option Explicit" in line 2 of the VBA code and moved "Dim zstrSQL As String" to line 3. I got another compile error: "Invalid inside procedure".Code:resolved string is::: SELECT [CUA#] FROM [VEHICLE_DETAILS] WHERE [Department]=4
3. I have to google "Compile you database" so it...Leave a comment:
-
OK, right now, when I execute the form I get the following Microsoft Visual Basic for Applicati... error box: Compile error; Syntax error. Line 1 (Private Sub Combo14_Click() ) is highlighted in yellow, and line 7 ( zstrSQL = "SELECT [CUA#] " &) is highlighted in blue.Leave a comment:
-
OK, I get it! I'm a BAD BAD man!!! Sorry, but this is all pretty confusing to me. I'm doing the best that I can!
I didn't give you the information that you asked for in post#49 because you also gave me a task to do. I had no idea how to do that so it took me a while to figure it out. When I returned, Seth had posted another response and I went on to that.
I imagine that I won't be in this forum much longer anyway. But until...Leave a comment:
-
Sorry, Seth, post 47.
"The screen shot shows three controls (not including labels): Select a department (which I assume has the name "Department ") [NO. THE NAME FOR THIS COMBO BOX IS Combo14], "Vehicles Number" (not sure the name of the control)[THE NAME FOR THIS COMBO BOX IS Combo26], and a button (based on the caption, I'm going to guess that its name is Command25)[NO. I REALIZED EARLY ON THAT I DID NOT NEED...Leave a comment:
-
Good morning group. Fresh day, fresh eyes!
OK, I fixed the table name issue (sorry again for that), and ran the form. I am still getting the same error as I did in post #57:
Any suggestions?Code:.RowSource = zstrSQL
(here is the full code just to be safe):
...Code:Option Compare Database Private Sub Combo14_Click() Dim zstrSQL As String WithLeave a comment:
-
Guys, I'm really sorry but I have to leave for the day. I will be back at this tomorrow morning at 7:01am EST.
THANK YOU ALL FOR ALL OF THE HELP WITH THIS!!!Leave a comment:
-
and using the second "troubleshootin g" code, I get an error that highlights the following field:
Code:.RowSource = zstrSQL
Leave a comment:
-
Using the cleaned up code, I get an error that highlights the following fields:
Code:.RowSource = "SELECT [CUA#] " & _ "FROM [tblVEHICLE_DETAILS] " & _ "WHERE [Department]=" & Me!DepartmentLeave a comment:
-
...Code:Private Sub Combo14_Click() With Me![CUA#] If IsNull(Me!Department) Then .RowSource = "" Else .RowSource = "SELECT [CUA#] " & _ "FROM [tblVEHICLE_DETAILS] " & _ "WHERE [Department]=" & Me!Department ' DimLeave a comment:
-
I'm sorry guys, but I'm lost. I'm trying different coding there and I still can't figure out what this string should look like.Leave a comment:
No activity results to display
Leave a comment: