Search results

Hi Kirk, In the Startup menu under Tools, there should be an "Allow Default Menus" option - if you uncheck that I believe it should disable the 'right click' menus (once you restart your app) ... I'd have to hunt around for the code equivalent, but it's sure to be lurking around somewhere in...

No probs - always happy to hear when things get sorted :) FYI, the Requery on your form's entire recordset is basically like reshuffling a deck of cards. Unless you have indexes on your table, or are using a query to order the records for the form's Recordsource, then it probably will navigate...

No worries - I was debating whether to suggest a more specific code in the form's AfterUpdate: Me!myJobValueTextBox.Requery (use actual name of your text box) Thinking it wouldn't have an effect, but actually it should probably work now that I think about it. This will hopefully save you...

Absolutely - In your form's AfterUpdate event in the code module put: Me.Requery I think that should do it ;)

Excellent! Glad you got things working and all the best with your project :) Cheers, John

Well, you have me stumped now :D That should've at least returned you a total for July. To tailor it to your requirements, change it to: =DSum("JobValue","2009","Month([JobDate]) = " & Month([JobDate])) (This is assuming your form is bound to the table [2009] as the RecordSource. You may...

Ok, I'm a bit confused. You state above that you want current month, but you also say that the month total should be associated to the month for the current record. So then what if you're on a current record for a month different from current month? Anyway, as you can see, I'm winging it...

my bad - try: =DSum("[JobValue]","[2009]","Month([JobDate]) = " & Month(Date()))

Both of you have just about got it. I think this should be what you need: =DSum("[Value $]","[2009]","Month([myDate]) = Month(Date())") vidus - notice I changed the name of your field from "Date" to an arbitrary name of "myDate". "Date" is a reserved word in Access so you shouldn't be using...

Hi mudstone, Something I overlooked in your original post but which your most recent response calls to attention: One of the basic principles of database design is to 'never' store calculated values in your tables. If some series of fields is being used to generate a "composite" value (i.e...

You're on the right track - use square brackets to enclose your table name: [Mediation Micro Tracking March 2009] Any time a space is included in the name of an object in Access, it's treated as a delimiter unless it's encased within special characters (i.e., [], "", etc.) Cheers, John

ok - I just tried it with some test data and it seems to work fine here, so maybe there's an issue with the criteria you've input. I don't want to hold you up from Sunday obligations so don't mind me. Just trying to get us across the goal line - no rush on my side either :) Good to hear that...

oooh - this is a tougher nut to crack than I thought. Give me a minute to test out on my side (time to fire up the Access app remotely) I should have it for you in a bit... In the meantime, try taking out the criteria again and see if the output in the calculated field is left justified or...

OK - I think I might know what's happening. Is the criteria under your "c_DOB" column or the calculated field column? I suspect it's under the "c_DOB" column, in which case, you'll need to move it under the calculated field column in query design. Remember, the calculated field is supposed to...

Hi Guinifi, But I thought your intention was to return the names of folks with birthdays coming up within the next 10 days? What happens when you leave out the criteria entirely? Do you get records displayed and do the values look right in the calculated field? We're probably missing...

Hi Guinifi, No worries about being a pain - working out the glitches is what this forum is for! Hmmm, that's strange. You did right by subbing your actual "c_DOB" field in for "Birthday" (another oversight on my part). May I ask what data type your "c_DOB" field is - is it Text or Date? If...

Hi Gary, What I listed was the entire query. Go to SQL View and simply paste everything in there. HTH, John

Hello and Welcome, In a query: SELECT FacilitatorAssigned, Count([FacilitatorAssigned]) AS CaseCount FROM myTable GROUP BY FacilitatorAssigned; But if you wish to retain the details of each record, you can build the grouping and counts into the Report itself using the grouping levels and an...

I still don't know what you mean by "YES/NO DUPLICATE" - presumably you're referring to a lookup table? It sounds like you're attempting to synchronize a remote database to your local database. Are you able to link the tables from your database to the remote database? If not, then you're...

Hi Guinifi, My bad - and my apologies! (Lack of testing it for real was bound to bite me :D) Try putting a closing parentheses at the very end - Also, I neglected to mention that you'll probably need to take the implicit carriage returns out (it should all be on one line when you input it in...