Mmmel
Last Activity: Dec 4 '12, 11:31 PM
Joined: Feb 13 '10
Location: A very cold place, CANADA!
-
Got it! The syntax took me a minute to figure out, but it's all good. Thank you so much for the suggestions, and so timely too! Much appreciated. : ) -
Shall try right away! Thanks for the direction, and I'll let you know if my head is getting woozy from all the banging! : )Leave a comment:
-
Calculate count of records with a particular property on a form
Hi! I'm sure that this is easy, but I just can't solve it. Could you please help?
Access 2010
I have a form that displays all students in my program and all classes that they take, kind of like this:
STUDENT ID CLASS MARK
All I want to do is create a calculated field that displays the total number of classes that student is taking, like this:
STUDENT ID #Classes... -
Thanks! I will give this a go.
And, I'm not reeeeeeeally interested, so please don't go to the extra trouble. You'd think that it would be easier, eh? :)
Thanks again!Leave a comment:
-
Add button to Ribbon to reload form
Hello! I want to put a button in a custom group on my custom tab of the Ribbon (Access 2010) that will simply reload the original form that loaded when the database opened (what was in Access Options, Current Database, Display Form:). I am doing a lot of development, and everything keys off of this main form. It's making me crazy to have to hunt it out in the Navigation Pane and re-open it over and over.
Thanks for any pointers!... -
Hi again!
My apologies. I actually thought I would catch heck for using code tags on something I didn't think was code (in that I didn't copy it from my code). I didn't want to confuse the issue (further, that is!!). Now I understand that those code tags actually serve an additional purpose - to set apart important text and improve readability. Great!
And, I have solved my problem (well, mostly). Using debug.print...Leave a comment:
-
OK - I know I'm being really annoying, but I'm about to lose my mind.
I think you might have misunderstood my last post - the line I posted (which you put code tags on) is not actually code. I just copied what came up in the immediate window when I ran debug.print. I was hoping that there was something visibly wrong with the SQL string that you could see. It knows the dates, which is good.
I think I have a much bigger...Leave a comment:
-
Hi again! You take good care of me, NeoPa! : )
Nice call on the Option Explicit. Found that right away. I shall use it from now on.
I read about and implemented the code above. Using a debug.print I get:
for my SQL statement. Does that look alright? Still no results (but there are two dates in there).Code:SELECT * FROM [Student_Information] WHERE ([Received_Date] Between #2/26/2012# And #3/19/2012#)
...Leave a comment:
-
SQL statement returns no values (and it should)!
Hello!
After a really looong time, I finally (I think) have my SQL statement working (line 28 below). I'm trying to select all records from a table (Student_Inform ation) where a particular date field (Received_Date) lies within a particular date range (which the user specifies in a form). I would simply use a query and then load the query, but you cannot as the query includes parameters (from the form).
Here's my code:... -
Here's where I read about dbforward: http://msdn.microsoft.com/en-us/libr...ffice.10).aspx I might be misunderstandin g, but they say that dbforward can also be called dbforward snapshot or some such. Since I want to update, this wasn't a good choice for me.
I really, really need to take a course someplace about Access/VBA. Everything I know about it I learned from Google or very nice people like you!
Have a...Leave a comment:
-
Got it!! Turns out that dbforward is incompatible with dynaset. Who knew? It's working now.
It does take time to update the fields - is that normal? Any way to accelerate that?
I even put in an error trap for when the recordset is empty.
Thanks for all of your help!!!!Leave a comment:
-
Thanks...that helps. I will post the error message from that line - perhaps you will know what is wrong then?
You 're the best! Thank you!Leave a comment:
-
Thanks, NeoPa. I have attempted to learn and implement this, but I have a new problem. I get the "Run-time Error 3251 - operation not supported for this type of object" error. I read online that this probably has to do with not using dbOpenDynaset (I use dbOpenSnapshot) . However, if I change it, it gaks on this line:
In summary, I added the following code into that...Code:.Bcc = Left$(strEMail, Len(strEMail) - 1)
Leave a comment:
-
I had a thought...do you think this will work?
I thought I'd create an update query based on the query this code uses. Then I could trigger the update query to run from within the code to update the dates. Will this work?
Now I need to figure out how to do it!! Any tips would be appreciated.
(Oh, and thanks for fixing my code tags, Stewart!!)Leave a comment:
-
Updating field value for all records in query using LOOP
I'm baaaack! I've searched for a while but could find no answers. Could you help me?
I have table that contains, among other things, an email address and a date field for the day that I emailed them.
I have built the following vba code to loop through a query (built off the table, containing the email and date fields mentioned above) to send an email. Works perfectly. What I want to do is set the [First Contact Date] to... -
Create report that looks like an Excel table
Hi again! I want to create a report that uses the following fields from my financial database:
Accountname (name of the account - there are three)
Firstday (Jan 1, Feb 1, etc)
Balance (the balance on each of the firstdays)
and outputs something that looks just like it would in Excel, with the account names on the vertical, the firstdays on the horizontal on the top, and the corresponding balances in the area...Last edited by NeoPa; Jul 23 '11, 12:56 PM. Reason: tried to fix how the output should look, but the spaces are being parsed and it looks terrible! -Mmmel Sorted -NeoPa -
Oh my...feeling like an idiot!!! I knew that too!
Yeah, I think I need another holiday!
Thanks!Leave a comment:
-
Combo box not using default value
Hello!
I have a combo box that contains the Row Source
so that the instructor can select the semester they wish to look up a student's marks for. The Row Source Type is a Value List. As the default value, I have an IIF statement:Code:"Fall";"Winter";"Spring"
...Code:=IIf(Month(Date())>=8 & Month(Date())<=12,"Fall",IIf(Month(Date())>=1 & Mo
-
Great! This was incredibly helpful. Thanks for taking the time to help me out! Got it finished now! : )Leave a comment:
-
How do I import data into an existing table to update the records?
Hi!
I have a table of names and addresses, all keyed off of the student ID number. I want to import email addresses for these records using an Excel spreadsheet that contains only the ID numbers and email addresses. That is, I simply want to add the email addresses to the correct people who are already in my table.
It seems so simple, but how in the heck do I do it? I just can't figure out what to search for to find...
No activity results to display
Leave a comment: