Search results

First was a message box about too many closing parenthesis. Once that was fixed, the result was the same, #NAME?. This would also rule out CazB's suggestion as well. From SS64.com, I know the IFF and IsNull are correct. The ResignationDate is formatted as Short Date (yyyy/mm/dd in Japan) MNM

Greetings again, Well now that the Months in Service coding is working properly (99.999%), I would like to use this calculation a bit further. I've set up another textbox, Current Contract (Textbox name: CCN), with the coding: =Int((MIS/12)+1) This works fine as well. It's using this result...

JHB, That's it! Thanks! MNM

JHB, Thanks for the catch. I'll take a look at it on Monday; it's a 3-day weekend here. I'll keep you posted. MNM

JHB, Thanks for the suggestion. The original report was built with the wizard which set up the SQL coding with the fields from both tables. To follow the route you laid out, I scrapped this and created a Query with all relevant fields from both tables. I pointed to this Query in the Report...

Gretings, My employer is using Windows XP Pro and Office 2003 (a few machines have Office 2010, but not mine). Furthermore, the machines are running the Japanese language OS, which has caused some compatability issues with my English XP/Office 2003 at home. I have a form containing an...

Hello all, The following code does it. I've checked by altering the system time (with one employee who's contract expired on March 17, 2014). Every case so far has displayed correctly. If IsNull([[ResignationDate]) Then MIS = DateDiff("m", [NichiiGakkanStart], Date) + Int(Format(Date...

Please see my reply to pr2-eugin. On the one machine, there are no problems, no compilation errors. BTW: The screen shot is from the home machine. Regards, MNM

Yes ... and NO. The machine used to make the original DB is an XP Pro w/ Office 2003 Pro. This has a twist though, Both the OS & Office are the Japanese language flavor. Everything runs fine on it. There is another machine I've used, another XP Pro w/ Office 2010 w/ English Language Pack...

The code so far: If IsNull([ResignationDate]) Then If Month([NichiiGakkanStart]) = Month(Date) Then If Day([NichiiGakkanStart]) < Day(Date) Then MIS = DateDiff("m", [NichiiGakkanStart], Date) - 1 Else MIS = DateDiff("m", [NichiiGakkanStart], Date) End If Else MIS...

Greetings, I have more problems with this project I'm building. Suddenly one of the forms has decided not to open. The attached JPEG shows the dialogue box that opens. In one copy of the DB, only one form is affected. However, in another copy, all three forms built on the same Dynamic Multi...

Contracts are for one full calendar year, i.e. March 3, 2014 - March 2, 2015 (always starts on a Monday), so just looking at the month can display the wrong amount. The code given does not account for this. The above example would display 11 months if the person did not sign a new contract and...

I did some digging online this morning (Tokyo, Japan time) and ran across a site that helped clarify at least where to put the code, Form, on Current event. I ran some tests, and in the 'Paul' (not beginning of month start) & 'John' results were good. 'Phil' resulted in an Error 94, Invalid use...

Greetings, I am in need of more assistance. My apologies if this is in the wrong place. I have a form, which is bound to a table, with an unbound textbox. I am trying to get the number of months an employee has/had worked. In the table are two dates, Company Start Date, and Resignation Date...

Sorry about that, I was unsure of actual protocol. This is what I ended up doing. Thanks for the help! MNM

Update: This does it. However, I still want to port the record directly to the report. So, why can't the same procedure for the form work for the report?

No they are not, I put those labels in lieu of the actual names, hence the {} surrounding them. As stated, the code works for the forms; I have 3 separate ones, Form+Search+Query, up and running. The third I made yesterday to replace the report, as this seems to be the best solution, and I'll...

When I do this with a form, it works perfectly. "The user" opens the form. The form launches the dynamic search form. When OK is clicked, the selected record is displayed in the first form. When I try this with a report, it does not work as above. The code for the form OK button is...

CanadianAccessUser, Thanks for the tip, it may come in handy later when the DB is up & running. Upon looking at the web page, I fail to see how this can port the selected record to the report which opened the search form. MNM

Greetings, I am new to access and have found some great tip sites online, including this one. However, I cannot find a tip on what I am trying to accomplish at this time. I am unsure as to post this as it pertains to reports, forms and VBA, so if it gets moved I hope I get an email informing me...