Recent content by MyOwnBoss

This is a one time fix up. I have compiled Archive Betreive DBs (several) and now need all distinct records to import into another application. As far as any other columns we can rely on to better filter them out is random.

I have about 52k of records with duplicates. It is a list of names with SSN. Where there are two names with the same SSN and name, one my have a middle initial and one without one, or any combination with the Initial. I would prefer the one that does have the Initial, but then also get one...

I mis-read your question. Let me make another example to fill the combos

Sure, Dim strbox1 as String Dim strbox2 as String strbox1 = combobox1.value strbox2= combobox2.value strbox1 & "v-" & strbox2

OK, Lets start at table design. Of course this suggestion is only an option to make your DB easier to use, it is not mandatory. Field Names: 1. NO SPACES. 2 Keep the names short, less than 13 if you can. Even though we have reached the point where we can use long file names and such...

I also use ADP for all my projects and understand what you are looking at. First I do not fill the second combo untill I have made a selection in the first, then I can then open my record set for the second combo based on any key value. Example: ABC Company is selected in Combo Box 1 then...

Is it giving any errors at all? Try going to VB Editir and unter Tool/Options set the debug to stop on all errors. Second, are you sure your form is not running, or is it doing a loop before loading the GUI. Check task manager and see what is loaded. Tells us more about the guts and function...

I had to work on this for awhile but it works and gives me what I want Private EditParentState As Integer Private Sub Form_Open(Cancel As Integer) Call BuildEnrollList 'Determinse that the listview is enabled Call EditParentData(0) Private Sub cmdEdit_Click() Call...

Hi All, I have a form that maintains data in a Parent Header Table while displaying data via a ListView from a Child Detail Table. The listview has various features such as Hover and a double-click event that opens a popup dialog form to edit its data. While editing the parent, I would like to...

Excellent! Thanks so much.

Hi All, I need to determine the strart and end of a given week from the date in a textbox. Example the date is 5/8/2009 then calculate the beginning of the week (vbSunday) +7 to give a result start=5/3/2009 and end=5/9/2009 I am doing this so the user can select any record created during the...

do a search on BLTbit