Search results

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...

This sounds kinda like what I need to do. Will setting a form's mode to read-only apply to the subforms too? Each form has 4 subforms and those are the main places that I need to prevent data entry (on the 4 subforms). If so... then what is the basic syntax of the code that I need to enter? I...

Please help!!! I am a newbie to Access and VB... but got bribed into deciphering and fixing this old database. Old database from my wife's work. We have recreated an access database and pulled in all of the old data. The old design only allowed a client company to have one employee. The new...

I understand that "good" database design does not usually allow for "repeated" info in several tables but in this case it is really the only good choice for what I need to accomplish. See the company table is really just serving as a "template" for information. While a customer may work for a...

Finally figured it out!!!! The trick was that my "Column Count" had to have the actual number of data columns specified correctly. In that I have 20 data fields I had to set the Column Count property to 20. Then I used the "Column Widths" property and set the Company Name field to 15" and the...

thanks for the help!!! I think I am on the right track with the info you gave me, but the problem is that the data is not filling in right. I think I have everything set up as you described but when I do the drop down it only correctly completes one other field (other than the value for the...