Recent content by jeffm3434

Anybody know why the commas are getting dropped? I've been researching and not found anything. Thanks

Cool... I got it mostly working. The loop of copying the data back into Outlook from my "report.html" file seems to loose some (not all) of the formatting. Like there are some spaces that get dropped and a comma or two. EDIT: Just figured out the problem is only related to commas. The commas...

Sorry if this has already been answered but I was unable to find it... I have a button on a Form that I want to email a Report from. The problem is that the Report is always an attachment. Is there an easy way to make the report appear in the body instead of as attachment? Here is what I...

Thanks... All I needed was the "SetFocus" The "MoveSize" is for moving the entire window and so does not apply here and maximize didn't solve it either. I did make the blank text box and put it on the form above the tabcontrol in the detail section and then I move the tabs back up over top of...

Thanks for the suggestion guys... unfortunately I could not get any of this to work like I needed. So I just modified my design slightly (not as elegant as I had in mind but it works). Basically I leave the main form open if they click the edit client button. Then when they close the edit...

I've searched this forum and have been reading for over 2 hours now and still can't find an answer to this (although I have learned a bunch of other stuff :) ). So I appoligize if this have been answered before... When I open my form my tab control is off screen (above the current view). I can...

autonumber field

Ok so I changed the control part... but I still get a type mismatch error. Any ideas what that could be coming from?

for some reason rs.NoMatch is not valid. I do not have "NoMatch" as possible choice after typing in "rs." And if I just type it in anyway I get a compile error. also same with "FindFirst" but there is a "Find" and I switched to that... does that matter? Is this a VB version issue? I'm using...

Ok so I think you are describing what I am wanting to do... where does this code need to be placed (which form and part of which button)? And can you give a quick english description of what this code says? (I'm trying to understand it... but I just don't know enough about VB objects and...

I have a form ("Clients") that points to a "Clients" table. I also have a form ("AddEditClient") that points to same table. Open Clients form and you see client info. Have at the bottom 2 buttons. One to create a new client and one to edit the current client. B/c we do not want user to edit...

Private Sub Form_Open(Cancel As Integer) If Me.OpenArgs > 0 Then Dim rst As Recordset Dim strSearchName As String Set rst = Me.RecordsetClone strSearchName = Str(Me.OpenArgs) rst.FindFirst "ClientK_ID = " & strSearchName...

Ok... another try at this... I think by changing some of my ideas here I get around one problem but have created a new problem... however the newer problem may be easier to fix (at least for those of you who know something about VB, unlike me :( ) So here is my new design (I just need a...

Thanks for your help... This mostly worked. So far I am unable to get the actual sub-forms locked... but I did get the main forms locked and then made a label visible (with BIG red letters) only when locked that warns the user not to enter new data. That is probably all I really have to do. Not...

I have a form ("Clients") that points to a "Clients" table. I also have a form ("AddEditClient") that points to same table. Open Clients form and you see client info. Have at the bottom 2 buttons. One to create a new client and one to edit the current client. B/c we do not want user to edit...