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!

  • Congratulations SkipVought 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: *

  1. AccessGuruCarl

    MS ACCESS HELP

    Strange... Memo Fields are for text only.... Are they all numbers or mixed alpanumeric? A few things to try. 1st.. Change the data type to OLE Object. Open the table, if it says Package or Bitmap(instead of your numbers). Double click it, the image should open. If its Long Binary... then 1...
  2. AccessGuruCarl

    MSFlexGrid - Help with looping issue.

    SBerthold... I created the recordset... QuickLoan_Recordset() It stores everything nicely. Debug.Print... How do I set the Datasource to it from the DataReport. Keep getting error.. Invalid Data Source Unfortunatly, Access 2003 doesn't show this. They show how to save the recordset to disk...
  3. AccessGuruCarl

    MSFlexGrid - Help with looping issue.

    Thanks for the posts.. I had trouble with the Printer.PaintPicture as well. Getting a runtime 5 error. Andrzejek - As long as none of them are string varibles, whats the difference? I was taught that variants should only be used when your not what the data result will be. Hence, they can hold...
  4. AccessGuruCarl

    MSFlexGrid - Help with looping issue.

    FYI.... The MSFlexGrid Amortization Schedule is working like a charm... All but one problem solved... Printing the MSFlexGrid Results, and the info in the text and combo boxes. I'll make another post regarding this in a few days if I can't solve it. If anyone knows how to create a report...
  5. AccessGuruCarl

    Progress bar color

    Thanks Skenny, Realized how do it after posting.. Here is how I did it. Dim lPBHwnd As Long lPBHwnd = ProgressBar1.hwnd Call SetBarColor(lPBHwnd, 255) Call SetBackColor(lPBHwnd, vbGreen) Basically the same thing... Rotate Text or Label.... Can be done with API calls... Try one of...
  6. AccessGuruCarl

    Progress bar color

    You don't need to rotate the picturebox. Just set the FillSyle = 4 You'll need to recode the code displayed so the line prints horizontal instead of vertical. I'll play around with it tonight if I get I chance. .... HQ or Strongm... Were you referring to guitarzan post? I can't get...
  7. AccessGuruCarl

    Progress bar color

    Found 1 other that I thought I should post in case your working with MDI forms... http://www.vb-helper.com/howto_mdi_status_bar.html My google search term was: vb6 picturebox for progressbar There is SEVERAL great examples.... Good Luck AccessGuruCarl Programmers helping programmers you...
  8. AccessGuruCarl

    Progress bar color

    I found a link to several... http://www.freevbcode.com/ShowCode.Asp?ID=317 Here is another really good site.... http://www.thescripts.com/forum/thread14905.html Here is code example found at http://www.visualbasic.happycodings.com/Forms/code13.html Create a progress bar from a PictureBox...
  9. AccessGuruCarl

    Progress bar color

    If guitarzan link didn't help. Why not use a picture box. I have samples if needed or do a search on google for it. AccessGuruCarl Programmers helping programmers you can't find a better site.
  10. AccessGuruCarl

    How do I define column properties using VB

    Thanks for info Bob... For this app, I do know what the values would be. Do you have a sample of hard coding it. For future reference. Thanks again... AccessGuruCarl Programmers helping programmers you can't find a better site.
  11. AccessGuruCarl

    Rotate printer output

    Hello Unscruffed Check google for... Fineprint... This may do it. Or search for Microsoft Printer Code I have a sample of the MS code in access db. http://www.noise-emission.com/tektips/rotateprinteroutput.html AccessGuruCarl Programmers helping programmers you can't find a better site.
  12. AccessGuruCarl

    MSFlexGrid - Help with looping issue.

    Hello, Need help fixing a looping issue, and a few others. First off I'm new to VB, After searching for vb sample of FlexGrid with amortization schedule I had no luck. I found a sample that outputted the data to excel so I starting playing around with it, after finding a few links on how to use...
  13. AccessGuruCarl

    How do I define column properties using VB

    Thanks for the confirmation... AccessGuruCarl Programmers helping programmers you can't find a better site.
  14. AccessGuruCarl

    Pre-secect printer

    Hello dedo8816 Take a look at this thread. http://www.tek-tips.com/viewthread.cfm?qid=892456 Scroll down about 4 or 5 posts and look for the code I posted for getting/setting printers. Make sure you get the all the code, their is a seperate function posted in another post a few posts down. I...
  15. AccessGuruCarl

    How do I define column properties using VB

    Thanks for the posts... Just to verify then, If you open Access, then open a table in design view add a few fields, set one of the data types to Yes/No(booleen), If you look at the second tab for the field properties "Lookup" the Display Control option is set to Checkbox... With combobox...
  16. AccessGuruCarl

    How do I define column properties using VB

    Create a new Access Database using VB. I have 2 procedures. One creates a new Access .mdb file. The next sub creates the tables. My question is how do I set/format booleen valued properties to a checkbox. During execution it creates a Textbox! Next issue is formatting a valuelist, and...
  17. AccessGuruCarl

    PMT function not working for me!

    Thanks, That did it... AccessGuruCarl Programmers helping programmers you can't find a better site.
  18. AccessGuruCarl

    PMT function not working for me!

    Please Help.... When asked if I could do this, I found the PMT worksheet function in excel and thought it was a no brainer... What am I doing wrong.... Here is the formula I'm using, straight from ms help. =PMT(C3,C4,C5) Calculates the payment for a loan based on constant payments and a...
  19. AccessGuruCarl

    Help Diagnose --- Need Administrative Rights prompt...

    QB licensing is fine... Company is running a Westall DSL Modem and Linksys 4 port wireless router. Basically... Here's the story I got after going in to diagnose problem. When the employee added the 5th PC(a wireless) to the 4 (wired) the orginal 2 PC that could connect were powered off...
  20. AccessGuruCarl

    Help Diagnose --- Need Administrative Rights prompt...

    Hello, I'm trying to diagnose a small network issue of 5 computers running Win XP Pro. An employee setup the 5th PC! So I'm aware what they have done! Here is the senerio--- PC -(1) - Acts a file server. That has the C drive shared. It's been in place and working fine for 2 computers that...

Part and Inventory Search

Back
Top