Search results

In the attached database, you can open either the Employee or Course List forms and they both open in the Split View--normal form on top, and datasheet below. I created another form (Training Rip) and copied the command buttons to open the other forms, but when the Training form opens, it opens...

I tried that out too, but had the same results. However, there is good news. I was able to overcome all the #Errors! :D I used a combo of the public function and IIf statements in the query. Here's how it turned out: Public Function fnGetDateStatus(Freq_CrsList As Integer...

Sorry, SOS. Your help on the date formatting was very helpful, but the Len function didn't work either. I'm still getting the same errors.

Some progress. I was able to get the date criteria to work with the following: 'If training due date is equal to current month, then "AWACT" If (Year(TngDue) = Year(Date)) And (Month(TngDue) = Month(Date)) Then fnGetDateStatus = "AWACT" Exit Function 'If training due date is due by...

I was thinking there might be a problem w/'dates' vs 'strings'. However, I think there might be another problem, because I should at least get a response for this portion: If IsNull(DateCompleted_Tng) = True Then fnGetDateStatus = "UNQUAL" Exit Function But even that doesn't show up...

OK...Here's what I have for the VBA: Public Function fnGetDateStatus(Freq_CrsList As Integer, DateCompleted_Tng As Variant, TngDue As Date) As String 'If no date in field, then training not accomplish--"UNQUAL" If IsNull(DateCompleted_Tng) = True Then fnGetDateStatus = "UNQUAL" Exit...

I don't think I did. I'll double check tomorrow. (The file is on my computer at work.) Also, I could probably give y'all some more information. The field "DateCompleted_Tng" is from a query. The table the query comes from has a field called "Status_Tng". I figure I can either use the...

OK. I'm getting an error. I've only used a module in a query once...and I can't seem to find an old copy of the db to use as reference. I've started the code in the module as below: Public Function TngStatusFx(mdlStatus_Tng As Date) As String If IsNull(DateCompleted_Tng) = True Then...

I'm working on a training database. It lists people and course codes, and everything's worked out except for the last--and most important--part. I'm in the middle of designing the main query ("qry_TrainingMain"--pretty original, huh?) and it includes a lot of nested IIf statements. I...

Hello All, I've been away from Access for quite a while, and unfortanely my brain is not wanting to work in Access-mode. What I need the db to do is track all the course codes on each person. As training currently stands, not all the course codes are listed on each person. For example, one...

Any luck on this yet? Not from my end....

I've been playing around w/ the Projects Template from Access (2007). One thing I'd like it to do is assign a Task through Outlook based on the info already loaded in the db. The template almost does this in a round-about way. If you open the project form, then the task form, and then...

Just a quick update. I haven't received any errors since my last post. Everything's working fine. Thanks for the help!

I'm working on another db, and ideally I would like to graph the info. The problem I run into, and I think this example may have the same problem, is that I need to graph to run on a variable amount of data. For instance, in the example the graph data is set to 12 rows. If there are less...

As a general rule, I use many baby-steps to get to a desired result. Unfortunately, this often makes things over complicated. So, if y'all don't mind, take a look at my example and see if there's a simpler way of getting the end product. With that being said... This db is used to track...

Wow! OK. First things first...the code listed at A2KCallbackBrowse had a couple of small issues when I tried to run it. I created a module and pasted the code in. I then created the form w/ the two buttons and two text fields, and changed the defualt "C:\" folder to a new location. The only...

I'm using a browsing function to allow the user to select where previously selected files will be moved to. There are many examples/means to open a dialog box to select files, but I've only been able to find one that selects the folder location. Ghudson's example works great, but I can't seem...

Thanks, Brian! That works great! For some reason, the first couple of times I ran the query I received a 'Data mismatch' error and all fields were #Name? ...But then it quit doing that, and it all works fine now. Very confusing.:confused:

WHOO!!! I figured it out! I knew there was a way to use the function that resulted in the rank and surname to further divide down to just the surname, but I couldn't get it. After much playing, I was able to "adjust" the code as follows: Public Function ExtractSurname(AnyName As String) As...

I originally posted from home, and didn't have a copy of the db. The original post has a couple of mistakes in it. Here's the workflow as it stands now: - Export on-line reports as XML (up to approx. 20 reports) -- Open, save, and rename as *.xls files: Format "Name dd Mmm yy.xls" - Use...