Recent content by wreded

Thank You again! Interesting reading. Dave

Thanks! AceMan your code works as i thought mine should have. i am storing the mDate as a string, i've never really understood how MS treats dates. Too much to learn. i'm off on another adventure as a geospatial mapper now, just trying to get the office to run right so the process is easier...

Scenario: Work orders arrive and pertinent data is put into an Excel spreadsheet. Each time a work order is received and receiving individual must create a work order number in the format "YYMMDD-" number of work order for the day (e.g., 01, 02, etc.). The spreadsheet thing drives me crazy...

i haven't posted before, largely because i haven't had a real need for much VBScripting. Now i'm in a quandry and would like some assistance. Windows 7 install has grown to 2 DVDs. DVD 1 contains Win7 + Office 2010, DVD 2 contains drivers for various models of computers. All of this will...

MajP and MazeWorX -- Thanks!! i knew it had to be somewhere. Dave

i know i've seen this someplace but i can't seem to find it now that i need it. How can i create a dynamic combobox composed of the UNIQUE data in a field? For example: Field contains text data in the form of "0015" to "0095". There are 15 records with "0015", 25 records with "0035", and 3...

Nope, still not working. A little questioning on my part turned up the fact that the "RowSource" property is apparently read-only unless one uses a Property Let or Property Get procedure. To be honest with You i've never run across another MSAccess developer or coder outside of boards like...

It is a combo box, i just tend to call anything that takes text input "txt" then whatever. i want it to act like a combo box and take the input i give it; if it doesn't find the input i want to change the data source from "BarCode" to "SerialNumber" and try to find the item again. In short i...

i took it as an example and modified it to my needs. Private Sub txtFindBarCode_AfterUpdate() Dim rs as Object Dim BC_Length as Integer Dim btnResult as Integer Dim mRow as string set Rs = me.Recordset.Clone BC_Length = Len(txtFindBarCode) If Mid(Me.txtFindBarcode...

Ok, makes sense now. When i set the "me.someComboBox.rowsource = mRowSource" i get a compile error, "Method or data member not found."

i have a form with two separate drop down boxes i use to find items in a table. One drop down finds based on an arbitrarily assigned number the other finds by item serial number. i got to thinking that i could use one drop box to search either field, in sequence (i.e.: arbitrary number, then...

The tab container's "on change" event worked like i wanted, and how i thought the individual tab's "on Click" event should work. Thanks boblarson! Dave

i have a form with (currently) 2 tabs on it. What i want to do is when users click on either tab focus is changed from the form within the tab to a control on the main form. So far i've tried: Private Sub pg01_Click() ' Forms!frmPersinfo!txtFindMe.SetFocus ' Me.txtFindMe.SetFocus...

TheAceMan1, how's it goin? The subform has the focus, the delete button is on the subform. It looks kinda like this... MainForm Data Data Subform DataDataData Date Data Button DataDataData Date Data Button DataDataData Date Data Button DataDataData Date...

i didn't build that into the form. Looks like i gotta do it over and pay closer attention while doing so ::-). Thanks, Dave