Search results

Thanks David, That sounds like an innovative solution - and here I was thinking I'd have to code everything. Nice. I'll give it a shot and report back. JO

Hi All, So here's the scoop. I have an Access crosstab query that I have exported to an Excel Spreadsheet. I have the spreadsheet formatted using conditional formatting and I'd rather not have to reset it every morning. It's a single spreadsheet (the columns/rows will not deviate greatly day...

AhA! Got it - I was making my Transform statement waaayyy too complicated. So I changed it to this and everything works. (KISS: Keep It Simple, Stupid) Max([LnNum]) & " " & Sum([OrdQ]) :)

Hi Guus, I wish that these text fields would accept tables, it would make the examples a lot easier. My starting recordset looks like this: Part Qty Line Date 1A.... 1... 42....5/20 1A.... 1... 43... 5/20 1A.... 1... 44... 5/21 1A.... 1... 45... 5/22 1A.... 1... 46... 5/23 1A.... 1...

Hello, I have a puzzle that I can't quite figure out. Components: 1. Qty - In Parentheses () 2. LnNum - separated by Commas 3. Item - Unique Item with many line (order) numbers and different quantities. I have a unique Item that splits into Multiple records based on my order qty (in...

Haha! Alright - I see what happened, I dropped a letter from the name of my own table. The correction has been made and the SQL works like a charm. Thank you very much Bob, this is awesome!

Thanks Bob, Headway has been made. However, using IIf([TypeDay]<>"HOL",[CalDate],DMax("[CalDate]","Tbl_CalDay","TypeDay <> 'HOL' AND CalDate < #" & [CalDate] & "#")) Gets the message "#Error" on the Holiday, instead of the last valid MDay that I need. I reversed it a bit and got it to...

Hello, I'm wrestling with finding a way to install a Value to a field when certain crieteria are met. For instance, in working with scheduling on a manufacturing day calendar, I would like to to take a schedule that falls on a holiday and replace the holiday date with the previous viable...

Thanks all, I took that advice and it seems like it's doing the trick! JO

Hi All, I'm on tabbed form [FORM1] and I'm looking to requery (refresh) the recordsource on Tab A, subform A, based on activity (e.g. checking a checkbox) in Tab B, Subform B. Does anyone know how to use VBA to force a refresh on a subform's recordsource without that subform being currently...

Hello there Mr B., Haha! yes - we can share coding tips. I'm finally getting up to speed on this stuff and it's quite interesting. Best! JO

Hi, My name is John and I'm not new to access but I am new to this forum. I work in aerospace in the united states and develop applications and systems prototypes for Supply Chain. I've found Access to be a great tool and want to learn more about how to develop more compact and powerful...