Recent content by DrPat

OK. I got it sussed. in the on open event of my main form, I requeried all the subforms. Data-wise it was unnecessary, but it fixed this little bit of stupidity. Thanks burrina. I'm going to put your suggestions in my back pocket for future use (these little tidbits always prove useful at...

Good day all, I have a continuous subform on my main form where one text box is a hyperlink that opens a form. All is well, except.... When the mouse hovers over the text box of the top record, the cursor does not change to the hyperlink pointed finger thing (it’s I-beam), even though the...

Hi Exaccess, This can be a very useful tool as a public function. I'm at work and don't have time to fiddle with this, but it seems you need to: 1. Find the number of characters after the decimal in your string 2. Coerce the string with CDbl() while setting the format to match the number of...

Thanks JHB, That was a consideration that I was saving if all else failed. Thanks for providing the sql. I was dreading the prospect of burying hours into this issue over the weekend. Now I can log in some beach time. Have a great weekend. /Pat

I have a pivot chart based on a crosstab query. I would like the items on the category axis (x-axis) to appear left to right in the order that they appear in the query results. Some specifics: Tables: tblFreq FreqID (PK, Number, Range 1-7) Frequency (text) tblResp RespID (PK,Number, Range...

My DB tracks sponsors for a non-profit. On my edit sponsor form, I had a subform to enter payments. It worked well (with much help from the experts here). The master and child fields linked well and all the necessary data appended to a new record in the payments table. Now to make it more...

My DB tracks sponsors for a non-profit organization. Demographics, sponsorship levels, tickets to events, payments, members who recruited sponsors, etc. I have a form EditSponsors which opens from a query that draws from 3 tables SponsorshipDemographics (PK SponsorID), SponsorshipLevels (PK...

:D You know what? I could've (should've) figured that out for myself....But it would've taken 3 weeks. Thanks TONS!

Thanks so much CJ. Now if I may impose on your expertise, can you explain (or provide a link that explains) how to create and then run a query in VBA? My code experience is minimal. Thanks again.

OK. Chalk this up to "I wish I knew then....." My original DB tracked customer orders and, being a fresh Access newbie then (as opposed to a seasoned newbie, now), I put in 20 order fields on each customer's record (10 for date, 10 for item#), hoping one day I'd sell 10 orders to the same guy...

I did not explain my dilemma clearly in my last post, so I’ll try again. My DB tracks sponsors for a non-profit organization. Demographics, donations, member who sold sponsorships, tickets to events, etc. I have a form that draws data from multiple tables, plus allows for new data...

You are absolutely right. Thanks. I need to empty the date range table as the macro begins.

Thanks Paul. I went ahead with your thinking and as a test, I deleted every record except one (one that I knew should be selected) and guess what? she gets selected twice. Any other ideas?

Can anyone explain to me why this query pulls every record twice and what I can do to fix it? I did it in design mode because I'm an amateur, but here is the SQL. SELECT [Patient Data Table].[First Name], [Patient Data Table].[Last Name], [Patient Data Table].[C MRI Facility], [Patient...

Thanks Paul. I'm an amateur and typical don't use VBA unless I'm copying code that I know I won't have to edit later (as in the code that locks the scroll mouse in earlier versions of access). I can't find anything in design mode that does the same trick. The form is a month/year picker and...