Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: snoopy80
  • Order by date
  1. snoopy80

    Asterick Logger

    Thanks, for the quick reply HarleyQuinn. Yes, That did it. Thanks!!
  2. snoopy80

    Asterick Logger

    Hi, I have a form that is used for user to enter password, is there some setting in Access that when user enter their password it shows only asterick? Thanks.
  3. snoopy80

    Underline Text

    Thanks PHV. It works! And thanks to Huggyboy.
  4. snoopy80

    Underline Text

    Thanks Huggyboy for your post. Here is what I tried: Private Sub CmdSend_Click() Dim objmailitem As Outlook.MailItem . . 'All Declarations strHTMLbody = "" strHTMLbody = strHTMLbody & "<html>" & vbCrLf strHTMLbody = strHTMLbody & "<head></head>" & vbCrLf...
  5. snoopy80

    Underline Text

    Thanks PHV and HarleyQuinn for your replies. I have been trying to create an HTML email from Access but have been unsuccessful. Does anyone know a link to some Examples I can learn from? Thanks in advance.
  6. snoopy80

    Access Table Field Size Limit

    Thanks Dhookom. I relinked the table and now I can see the rest of the fileds. Thanks. Also thanks to Genomon and Smedvid for your replies. Thanks.
  7. snoopy80

    Access Table Field Size Limit

    Thanks for your replies. I actually mean to ask how many field I can have in a table. According to Genomon's, it says 255 fields in a table, but I have 80 in SQL table and when I link it from Access, the last field I see is about 70th. Can you help me to make those field visible so I can include...
  8. snoopy80

    Access Table Field Size Limit

    Hi Everyone I have an Access DB that link table to an SQL Table that has about 75 fields. When I create queries, I noticed not every field are shown in Access. Is there a field size limit in Access? if there is, how can I make it to see the rest of the field? Thanks for help.
  9. snoopy80

    Underline Text

    Hello, I have a send button in a form when clicked it put some text information on an Outlook email so I can email it. My question is is there a way I can underline or bold part of text body? Here is the body of my email: strBody = strBody & "UserName: " & Me!UserName & vbCrLf & vbCrLf...
  10. snoopy80

    Highlight certain rows in a Form?

    Yes! It worked. Thank you Missinglinq. appreciate your quick reply and help.
  11. snoopy80

    Highlight certain rows in a Form?

    Hi Everyone. I have a subform which in Detail line have Item#, DateShipped, Qty, and a Returned Checkbox. What I want to do is when the user check the Returned chkbox, I want to make the Item#, DateShipped, Qty Backcolor to grey for a better visual effect. My problem is when the checkbox is...
  12. snoopy80

    Check box to clear value or to re-insert value

    Yes. You did AceMan1. I misunderstood and did not store in advance the value but instead assigned the Cost to it each time. I modified my codes to store the hldCost in advance and it worked. Thanks for both of your Helps. Appreciate your time.
  13. snoopy80

    Check box to clear value or to re-insert value

    Thanks PH for your help. I tried this but it did not Zero out on the second uncheck but it still back to my original problem, that is insert back the last value saved. Using AceMan1 code, when the chkbox is checked, then: Me!hldCost = me!Cost this statement will assign the Cost of the...
  14. snoopy80

    Check box to clear value or to re-insert value

    Thanks for your reply AceMan1. I tried your solution. It did similar to the problem I had. And if I uncheck more than once the value would be zero out. I do appreciate your suggestion.
  15. snoopy80

    Check box to clear value or to re-insert value

    Hi, Let say I have a form with 5 records that displays: Last Fist Unit Cost TotCost chkbox Smith John 2 $5.00 $10.00 Hill Mary 3 $2.00 $6.00 . . When I check the chkbox for example on Smith record I need the Cost and...
  16. snoopy80

    Sorting in View

    Good Morning All. I have created a view from SQL2005 using a table that include a Primary key (named UserID). Let say in the view, I have something simplified like that: "Select TOP (100) Percent UserID, Last, First, Age From dbo.tblUser Order By Age" In the Design when I execute...
  17. snoopy80

    Freeze Gridview Column Header

    I was trying to learn ASP.NET and found something interesting that I though I can use in the future. This is the link http://mattberseth.com/blog/2007/09/freezing_gridview_column_heade_1.html I click on the live demo and I found it really slick. Unfortunately this is in C#. If I was to do...
  18. snoopy80

    Object Variable or with Block variable not set error

    I Keep having this error when I click on Newrecord button in my Access ADP form. "Object Variable or Block Variable Not Set". Could someone give me an advise, please. This is my code: On Error GoTo Err_CMDNEW_Click DoCmd.GoToRecord , , acNewRec Dim dbs As Object Dim qdf As Object...
  19. snoopy80

    Converting an Access query to SQL view

    Thanks George. It worked. Really appreciate your fast response and great help.
  20. snoopy80

    Converting an Access query to SQL view

    Sorry accidently clicked submit. Can someone help me to convert this to SQL view? Thanks.

Part and Inventory Search

Back
Top