Search results for query: *

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

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

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

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

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

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

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

...Dim fPercent As Single Dim lLenBar As Integer On Error GoTo ErrFailed fPercent = lPercentComplete / 100 lLenBar = fPercent * pbProgress.ScaleWidth 'Fill both sides of the bar (incase a backwards progress bar is required) pbProgress.AutoRedraw = True...

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.

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.

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.

...and store it in iYears iYears = CInt(cboTerm.Text) 'Use the Pmt function to calculate the Monthly Payment dPayment = Pmt(dRate / 12, iYears * 12, -1 * dLoan) 'Display the Monthly Payment in the lblPayment Label lblPayment.Caption = lblPayment.Caption & Format(dPayment...

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

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

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

....DefinedSize = 50 End With [!] With .Columns("RaceType") .DefinedSize = 25 **** Needs to be a ValueList - Car,Truck,Boat End With[/!] With .Columns("LaneCnt") .DefinedSize = 2 End With...

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

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

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

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