Search results for query: *

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

On Your recommendation i tried removing one of the subforms and rerunning the form. No dice, still the same error. Good idea though. Dave

Yep, it's in the detail section along with the data. That's what's so puzzling to me.

Have a form with tabs tying several tables together. On the tabs are subforms. i'm having trouble with 2 that are continuous subforms. These subforms list different training data and have a "Delete" button next to each item. The "Delete" buttons work as advertised when designing the form or...

PHV & TheAceMan1 First off, thanks for both responses. i tried them both and can't seem to get Yours to work TheAceMan1; PHV's worked right off the bat. i think i was close, but not within horseshoe range. i'll keep trying Yours TheAceMan1. Moving between Access03 at home and Access07 at work...

i haven't seen this in the forum yet so here goes... i don't like the way Access deletes records on the fly. i'd rather they just be marked and then removed when the user decides they're not useful anymore. Form opens with a table, one field of which is a marker "Deleted." i'd like to code a...