Search results

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

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

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

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

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