Recent content by JCShort

Solution: I created a work-around that, while not ideal from a normalization standpoint, works. I added an event and a field on my parent form to trigger and store the DateBucket() function/output. My subform now simply compares the stored data instead of using a function.

Thanks vbaInet. The module is listed in "Functions1" which doesn't clash with anything. It actually works perfectly for all other forms (roughly 50). I think this is coming back to haunt me: http://www.access-programmers.co.uk/forums/showthread.php?t=174274 After I split my DB, I found...

Unbelievable. I built a test DB to post. Copy/Pasted all of the code & named all of the fields the same. The test DB works perfectly!...... I knew something was up when I pasted the code & all of the ".parent." became ".Parent.".... I'll try to figure out what the problem is in my...

Still nothing. The unbound test cell on the parent form returns the correct output, but the subform test cell still says "#Name?"

Uh oh... I always name my form fields after the bound control. I'm getting a sinking feeling that you're about to tell me I'm doing a DB faux pas!

Thanks SOS. Didn't work. :( The DDDate & CancDate are fields on the parent form which are linked to a different table than the subform and respective inputs.

Thanks for the suggestion, smithwick. I'm still having the same issue though. I've used the public function on every form that I've created over the past 1.5 years without an issue. We don't follow calendar months where I work, so I had to improvise for reporting purposes. As part of my...

I have a public function that converts off-calendar month dates to a single specified date: The DDDate is input into the Parent form. However when user inputs the various records into the Child form, I need to compare two dates to determine the propper date for the record (DDDate vs. CancDate...

How about: Forms!SALIDAS!SALIDASpickingsubform.Form.SalidaNum .Value = Null What's the debug error?

My DB is split into a back-end & front-end. I convert the fe.mdb into an MDE file that is distributed to the users' desktops. The users don't ever work directly in the fe.mdb. I've recently encountered a strange problem in the fe.mdb when I try to make updates. I get an error stating...

Instead of clicking on the path to link the backend tables in the wizard, I recommend typing in the UNC path name (\\servername\folder\db_be.mdb). Drive letters can change unexpectedly & will cause you real headaches. I also make an MDE file out of the frontend and distribute that to the...

Thanks for the correction, SOS. I had all sorts of issues adding dates when I was trying to simply add a number. Obviously doing something wrong. I deal w/ weekdays all the time anyway, so a straight add days doesn't work for my application. Good to know before giving others advice though. :)

The table is where your data is ultimately stored, but your form is where the data is manipulated. When you say add 4 days, do you need to add weekdays only? i.e. Today is Wednesday so +4 = Monday, not Saturday. 'date + number' is a great excel formula, but it doesn't work in access. You...

Thanks, Paul! Worked like a charm. I'm curious to see what it does with a REALLY long string. I didn't have time to simulate a large client in the testing, so they got what they got. :D

I'm using the standard Microsoft "SendMessage" function to open Outlook, pre-fill 'To:', 'Cc:', Subject, & Body fields, along with attachment of a report. It works wonderfully well! Except, I've just been asked from up on high to adjust the subject content. I have: ' Set the...