Thanks very much. I use vb badly and access badly so between the two, confusion arises for me.
That makes sense what you're saying. I have to go now and will have a go at this tomorrow.
Appreciate your help!
leeg
Last Activity: Nov 2 '07, 10:42 AM
Joined: Dec 12 '06
Location:
-
Thank you.
Sorry for being a bit thick but I have tried your code and get an error
"runtime error '3061' Too few parameters. Expected 1."
When I debug it highlights (line 7.)
Set rs = db.OpenRecordse t("Q_SearchJobR efNo", dbOpenDynaset)
Here's the code I put in and substituted the names as per your message
I have rem'd line 9 as I'm unsure what this...Leave a comment:
-
Need to trap blank new record on form
Hi all,
I am having trouble finding out how to stop a new record showing on my form when there are no records showing in my underlying query
Query criteria is populated from a form text box and then I use a cmd button to open the form.
cmd button on click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "F_SearchJobNoF orm"
DoCmd.OpenForm... -
Thanks very much. I'll have a look at this today!...Leave a comment:
-
Hi,
I have 8 fields in a table and the user needs to search/filter from an unbound form using combo boxes on all the 8 fields (using all 8 comboboxes) or none (giving all records) and also some of the 8 comboboxes, but not all.
Does that make sense?
Cheers, Graeme...Leave a comment:
-
oh my goodness...multiple criteria
Please help.
If I am to do what I think I need to do, i'll be here for years!!!
I have 8 fields which I need to give the user the option to search on all or some or any of the combo boxes. All the combo boxes are pre-populated obviously so data entegrity is not an issue.
I have googled and found that doing it in SQL is probably the best option, but mathematically, 8 x 8 x 8 permutations = 512 entries... -
THanks a lot. I said I was thick...
Do this in a report or query?
If it's in a report, how do I create a filter to filter data for over 8 days only for all staff?
MAny thanks in advance
GraemeLeave a comment:
-
Thanks, but can you elaborate a bit more? I have looked at all those options but count seems to add a 1 to everything?
REgards
GraemeLeave a comment:
-
Totals in a query help please
Help please. Apologies but I am poor in access and programming :o) and am having trouble getting my head around this one!!...again!! !
I need to have a query or report to flag up someone who has been absent for over 8 days + in a 12 month period.
the relationship between tables is staffID. My sub table stores the absent occurences against my main Staff Names table. Obviously staff can have one or more occurences of being... -
Thanks very much everyone.
Mary was right :o)Leave a comment:
-
Form with multiple queries
Hi,
Really appreciate some help with the following: ps I am very poor at VBA!
I have a form and when clicking a cmdbutton want to open the same form but with a different underlying query. I have looked some threads which just said look at Rowsource help which I have and am still none the wiser!
At the moment I have 3 forms with 3 queries and it's cumbersome obviously
In the form properties,... -
Mary, I love you!!!! And thanks to Neopa
I tried every permutation of syntax that I could think of. Greatly appreciate your time and skills. Thankyou.
I wasn't trying to dcount against a form. The table name is actually mainjobform :o) Can you tell I'm not a programmer!!!!
Regards, GraemeLeave a comment:
-
Sorry, here is all my code for this
...Code:Private Sub Form_Load() 'On Load of the switchboard check Jobs table for any incomplete jobs Dim intStore As Integer 'Count of incomplete jobs that are high priority and incomplete intStore = DCount("[Job Reference no]", "mainjobform", "[Priority rating]= 'high'" And "[Date completed] = ''") 'If countLeave a comment:
-
Dcount woes
Afternoon,
new to here and new to programming. Well I'm not, I'm just not good at it!!
I am trying to count the number of records with a priority of "high" that also has a blank completed date. I assume it's possible?
My syntax (that's not working) is -
intStore = DCount("[Job Reference no]", "mainjobfor m", "[Priority rating]= 'high'" And "[Date...
No activity results to display
Leave a comment: