Recent content by kyuball

You're a genius vbaInet!! Worked like a charm without code!! Thanks to both plog and vbaInet for all of your help!!

Hmmm.. I guess that would be a way to do it... I keep thinking that there has to be a better way. Maybe some way of autonumber type field that can be put into a query that gives a sequential reference to each line of data or some way of referencing the first, second, third, etc. record that...

Really? Copying and pasting is the only way to go? I suppose I could just export it directly from Acces into Excel in which case all the pretty formatting stuff (presentation is important in all business, don't you think?) is lost on the export. I was just hoping for an easier way to get a...

Hey everyone, I am sure there is another thread out there to this effect but I am having a hard time putting in the right search thread to find it. I am on Access 2000 building an mdb database to keep track of attendance at monthly community meetings. Based on past attendance (criteria...

Oh my God, you're a genius, elliotgr! Made a few modifications, but it worked like a charm!! The modifications below for those intending to use this in the future: Private Sub Command0_Click() Dim myObject as Object Dim Source as String Dim Dest as String Set myObject =...

Hey everyone, I have a database that keeps track of sketch comedy bits in Access 2003 .mdb format. Thanks to everyone's help here, it is a really bitching database that allows me to add information and watch those videos on a separate form. Now I want to take it one step further in helping me...

Hey MMaynard, You're a friggin' genius, dude! I am still trying to wrap my head around what you have there but I am starting to get the gist of it. Also, is there no way of getting rid of the last comma in the LeftString? Right now, it returns two checked conditions as "Mental Illness, and...

I got back to work and tried it out and it worked awesome! Thanks, MMaynard! Is there a way to get the last ctl.Name to be preceded by an "and" (like mental illness, domestic violence and chronic medical problem instead of mental illness, domestic violence, chronic medical problem)? I tried...

Hey MMaynard, I hate to be a bother considering the time and effort that you have given me, but is there any way to get that in an .mdb format? I am still running on MSA 2003 and am unable to open .accdb files...

Hey MMaynard, I hate to be a pest, but would you be able to upload that test form? I am still a relative beginner in Access and would love to know how you made it work. Kyu

Thank you so much for your help MMaynard! I am trying it out as we speak. BTW, is the text box that the string dumps into called "MyLongString"?

Would this particular code work on a continuous form, as well? I know that Form subroutines tend to only affect the first record on continous forms...

I have a database that keeps track of special needs of social work clients and I need some help displaying data a string of text based on data entered through check boxes. After case managers have gathered intake information from a client, they enter the data through a form that allows them to...

DARBID, YOU'RE A FRIGGIN' GENIUS!!! OK, so I tried using the timer to keep track of where the play back is on the media is at any given time. I tried duration and that did not work , but current position did! Using this method, it showed me that current position is indeed not static and can...

Because the input mask is set to h:nn:ss, you have to put in five digits: one for the hour, two for the minutes and two for the seconds. So if you want to put in 1:00 as in one minute, you have to enter 0:01:00 or if it's 1:00 as in one hour, then you have to enter 1:00:00. I did this to...