Search results

I didn't know there was a maximum

just curious...why when you put in the date function do the parameters disappear? Is it because the function takes no parameters? Or does it take parameters? It doesn't seem that it would. Thanks

ooops

try this Private Sub cmdCopy_Click() Dim answer As String On Error GoTo Err_printreport1_Click answer = MsgBox("Do you really want to print the report?", vbYesNo, "Confirm Print") If answer = vbYes Then Dim stDocName As String stDocName = "Courses & Students Report"...

OK. I understand what you are saying but I still dont know how I would use the index' to lookup the customer name in another table. This is a step I have avoided in the past because I did not understand it. If anyone would be so kind as to show me how this is done. The database is here...

Hey I hit 500 posts!

check this out http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=6967&highlight=suppress+error

well, here is my one of my newest ventures. Please feel free to check it out and critisize away. Or email me your comments/suggestion/hate mail to mmajewski@alliancebankna.com Thanks

how do you set a foreign key? Or I should say how would I relate those tables to use them in a lookup for them? Thanks

cool. Thanks for the suggestions guys. They make sense.

Awesome! Thanks!

Why wont this display mySum as currency? Private Sub Command16_Click() Dim mycount As Variant Dim strSQL As String Dim mySum As Currency 'checks to see if the start date comes after the end date for error checking purposes If StartDate > EndDate Then 'error that start comes after end date...

Hey! Sounds good. Thanks I will try it next time.

I have a db that has a list of customer names for check processing. I have the customer name in a sererate lookup table for the main form. On the main form however I have the customer name (which is looked up fro the customer name table) and a customer # (which is not inthe customer name...

use VBA instead :D

Thanks guys works great:D

I have a form that inputs check information. I have a textbox on the bottom of the form that calculates the sum of the checks entered. That works fine. But what I want to do is only calculate for todays date. Is there a way to do this by changing the control source? Or do I have to use a...

IM using access 97

there was nothing there but the REM statement, or is this how you do it?

I want to be able to comment out some code for testing purposes. Like in C++ you can use /* */ ...I think that is it. In VB is the only way to do each line?