Search results

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...

John, You can use Bob Larson's FE auto update utility found here: http://www.access-programmers.co.uk/...d.php?t=111132 Admittedly, I haven't added it yet. I simply e-mail the .mde version of the frontend app to the remote worker. Recently, all of the changes have been made to improve her FE...

Yahtzee! My remote employee said it's definitely better. I guess this is another method to reduce the response time from backend tables to a frontend app!

My DB has grown to be fairly large (23 forms/subforms & 55 tables). The majority of the tables contain lists that I use to populate comboboxes. I recently discovered and dove into the world of split databases. The split is great (backend saved on server, frontend .mde saved on local...

Bob, You are a scholar and a gentleman & my very own personal savior for the day!!! I've been trying to calculate weekday differences using different methods for almost an entire workday at this point. I love this site and appreciate the expertise that all of you demonstrate and share. I'm...

Wow! I'm a complete tool. A simple Microsoft Office Help search would have clearly explained this. Sorry for wasting your time. I asked a peer if Msgbox had additional functionality & he said "No", so I ran with it. Lesson learned. Thanks for helping!! Not to mention, I like building my...