Recent content by weilerdo

Hi Everyone, So I can't seem to figure out what or how to do this one. I have a table that has the following fields Asset_ID, purchase_price, date_ purchased, life_cycle, and salvage. What I need to be able to do is somehow track and be able to see the current value of an asset. So for example...

Like in the attachment I created labels for requided credits, subject and orginallly I thought that all of the classes would be the same. IE student 1 and student 2 both would take English 1 and then English 2, etc but now I find that student 2 might take AP English instead of English 2

Hi Everyone, I have 1 last report to finish this database that I have been working on and can't seem to get my head around how to do this. I have a table tbl_transcripts that has 6 fields in it. [student], [subject], [class],[date_comp], [credit] and [comp] and "comp" is a yes/no field. I need...

But once again Paul, you are correct.. I will definitly look at using the Switch function, I dont know that I have ever used it before.

Hey Paul, I am trying to follow the logic but am missing something most likely simple but, Im getting the error that the function contains the wrong number of arguments. Which I would assume has to do with the "N/A"...

Hi Guys, I have an IIF statement in one of my reports. The statement works great has long as there is data in the field [Text48]. If that field is blank then I get the #Error. I have tried several NZ or Is Null statements in it but all I get is that the statement is to complex then. What I need...

Paul, You never cease to amaze me. Thanks again

Thanks Paul, Where would I do the DLookup at. I tried it in the control source and now I am gettinga #Error

I have a form frm_austin_logs that is bound to a table tbl_logs on the form I have 8 fields that are not bound to the table that I want to pull there information from a query. I created the query qry_austin_log_gpa and if I run the query stand alone it works fine. In the form I put the following...

yeah I just downloaded his sample http://www.access-programmers.co.uk/forums/showthread.php?t=205417 and added the string that you helped me with " Public Const pbUserName As String = "phxbombardier@gmail.com" so there must be something more that I cant see.

Thanks Again Paul, I think your right it is not showing up anywhere in any public function, so I tried to ream it out and I am getting the same error on like 5 more things in that module so I think I need to regroup and rethink how to go forward

Thanks for the quick reply Paul, I tryed that and I am still getting a compile error Sub or Function not defined on my form for the: If fn_CheckValidEMail(strCheckValidEMail) = False Then

Hey All, I came across the sample database that Smig made and am having problems getting it to work. Modules are not my strong point for sure. He says You will need to set up some eMail details for this to work (they are all in the mdl_PublicDeclerations) This is were I get lost I can't seem...

yes you both are correct... Unfortunetly that was the only way that we could come up with to make this database work. Bob and if I remember correctly Ken you helped me create the original. Its a Employee Schedule database. I added the CDate() Function and am going to add the DateAdd part to...

Hi All, I have a problem that I can't seem to tget my head around. I have a table with a field called strMoYr with the values like "December 2008" I am running a query that I need a way to only count the last 12 months. Example would be if I run the query in January 2009 I only need it to look...