Search results for query: *

(laughing) I don't know where you came up with that nugget of information but thank you so much. I've been looking thru online help, our Access Bible and O'Reilly books and never found it. Thanks again!!!! George

Good Morning Everyone - I have a text box which holds a production lot number which just the date and a 3 digit box # in the format "040206-001". It has a format of "@@@@@@-@&&" so it will insert the "-" if just the 9 digits are entered. After the user saves off the first entry I want to...

Just wanted to say thanks to everyone who took time to respond. At least I have somewhat more of a prespective from the database community - an area that I'm new too. Thanks again to everyone. George

Hi Jeff, Mostly small to medium applications (if that adequately quantifies anything). Like I stated, we're a small company so we're doing HR apps for around 50 people, some small database apps for our customers doing product tracking which generate some Excel reports and some inventory...

Just looking for opinions... I'm with a small company and have programmed in languages from Assembler to C++. We have an existing application in Access and for the last year I have been asked to develop certain projects using Access. The bottom line is for both myself and our office manager...

Thanks Geoff, The product links are to sales histories and the customer doesn't want to archive them just yet... (laughing) couldn't get off the hook that easily!!! Have a good weekend. George

Since I haven't had any comments I'm assuming it's not possible to specify attributes for individual items in a combo box list. Guess the next logical step is to just make a 2 column combo box and specify the product status in the second column unless someone has a better suggestion.

Hi Everybody, I have a combo box with a list of products. Some of the products have gone obsolete and I have been asked to change the combo box list to somehow signify these products thru a background color change or a strikethru font. My question: is it possible to have different attributes...

I'm trying to enter a date thru an input box with error checking. The code is included at the end. If the date is wrong I want to re-display the input box. My problem is that the input box is re-displayed on the first error but if I re-enter a bad value again (ex. 13/41/04) I get the ugly...

First, thanks for taking the time to help me out. The Sheets("sheetname").combobox code works. But the thing I still don't understand is what's the difference between Sheets("Summary").combobox.ListRows = x and Set MenuBook = Workbooks.Application.ActiveWorkbook Set SummarySheet =...

I'm trying to modify a worksheet combobox within a Workbook Open event module but can't seem to reference it. My code uses SummarySheet.cboProductList to define it but this generates a "Object variable or With block variable not set" error. It seems like it should be simple enough. Any...