NeoPa
Ok so I think I get what to do up to 2.a (Debug \ Compile Project). It just looks like it shows me where the "error" is in my codes. I am lost, however I do get the copy/ past in B 2 and I think I get the part about Code Tag I will try to do what I can Next time, but knowing me I will prob mess it up.
SusanK4305
Last Activity: Sep 7 '12, 12:56 PM
Joined: Sep 9 '10
Location:
-
zmbd,
I know he is trying to help. I just don't understand. I will try to look at it again tonight and hope it clicks in my head.
Ariful Alam's DB will work for now. I am still looking at NeoPa's tutorial... trying to understand and see how mine works in it.
Pease note: I didn't plan on searching for John 3 time. :) I will keep looking at NeoPa's tutorial. The cascading comboboxes sound familiar.Thank...Leave a comment:
-
ariful alam,
I didn't see the attach Database before, sorry. I took a look at it and just repeated what i read in the db. It works for now, Thank you. :)Leave a comment:
-
NeoPa,
I don't mean to be disrespectful, but if I understood what all those instuctions ment I prob. would have a better idea on a simple search. I would be happy to format my question any way you (the site) would like, but I am not that advanced.Leave a comment:
-
ariful alam ,
The prob with this is that there is nothing telling the openform cmd where to get the criteria’s.Leave a comment:
-
Create a search window
Ok I Idk why i cna't do this any more (seeing as I did it back in 2010, oh well.
Purpose: To create a form [Search]that contain 3 unbound text fields (Filter1, Filter2, and Filter3). When one clicks the search aka (cmdFilter) the subform [Search Results] is filtered based on the 3 text fields.
What I need help on: I need a VB code the will make the filter go from one Filter to the other then show results in the sub form.
... -
Thanks for ya'lls help. I have fig. it out. It was one of those things that you just want to kick your self for not seeing it.
This is what I did.
I used the wizard to create 2 sub reports "Report Position" and "Report Program Element" in side an unbound Report "Report1".
In the wizard I ues the matching query for the sub reports. (i.e. "qurPositio n" was uesed for "Report...Leave a comment:
-
Report Count IIF Help
I have a Count IIF statement that needs to be fixed.
This is in an unbound txt field in Report1.
Report1's Record source is qurReport1 (combined by 2 tbls...tblPosit ion Data and tblAction Log).
Field of the query are...
tblPosition Information_ID: ID (Auto #)
Position (dropdown from tblPosition Choices)
Program Element (dropdown from tblProgram Element Choices)
Reinvestigation (yes/no... -
I have changed it up a bit I cleared it all and started from scratch. This is what I have now.
Table A (tblAction Type) is just a normal data table
Table B (tblReason) is just a normal data table
Table C (tblAction vs Reason)has ID (auto),Action type (dropdown), and Reason (dropdown)
C is the query (Qur A)
SQL is as follows:
SELECT [tblAction vs Reason].ID, [tblAction Type vs Reason].[Action...Leave a comment:
-
I get that part but here is were mine and this one diff.
My Reasons is a list all its own (I think this is called a string) as well as the Actions. The reason for this is so I can use the same reason for diff Actions ...like below
Qur 1
ID...Action.... ..Reason
1....Pending... .. Bad Credit
2....Pending... ..Waiting Paperwork
3....Denied.... ..Bad Credit
4....Approved.. ...N/A
5....Pending... .Other...Leave a comment:
-
Thank you bothLeave a comment:
-
Both McCarty and NeoPA work the same the only diff. is
WHERE ([Action Type] <> 'Complete') and how it shows.Leave a comment:
-
I just want a command button to open a folder on the SDrive the path is as follows.
"S:\Security\Op erations Support\Intake DB"Leave a comment:
-
ok I found where it goes.
...Code:SELECT "Total", Count([Action Date]) AS [CountOfAction Date] FROM [Action Log] GROUP BY [Action Type] UNION SELECT [Action Type], IIf([Action Type]="Delayed",Count([Action Date])-DCount("[Action Date]","Action Log","[Action Type]='Complete'"),Count([Action Date])[B])[/B] AS [CountOfAction Date] FROM [Action Log] GROUP BY [ActionLeave a comment:
-
it is also missing a " ) " some where here
and my self not great at reading this kind of stuff.... not sure where, but I will try some places I think it goes and let you...Code:IIf([Action Type]="Delayed",Count([Action Date])-DCount("[Action Date]","Action Log","[Action Type]='Complete'"),Count([Action Date]) AS [CountOfAction Date] FROM [Action Log] GROUP BY [Action Type];Last edited by Frinavale; Oct 7 '10, 05:39 PM. Reason: Please post code in [code] ... [/code] tags. Added code tagsLeave a comment:
-
Yes I tried that and all I got were numbers. Maybe I should just redo it from scratch. I must have messed w/ it to the point that I have no clue what I did. :)Leave a comment:
-
oops! yes a folderLeave a comment:
-
So I am guessing that no one knows how to make a Cascading Lists useing a QueryLeave a comment:
-
I am sorry I guess that could have been read as disrespectful I didn't mean to be. Some times I run around like a chicken w/ it's head cut off I end w quick replies.Leave a comment:
-
??? why would I open a file as an exe doc?
ummm ok I am opening a File that has documents in it. I don't want to Open any 1 document just to take them to the file.Leave a comment:
No activity results to display
Leave a comment: