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

    From C to VB and back

    Hey, I've got the following problem. I've got a program written in C that receives a character buffer and i've got a Visual Basic program that can transform plain tekst into an image (an .tif file ). The buffer that my C program receives needs to be converted to an image file so want my C...
  2. Namlop

    Propertybag problem

    My program is giving the following error: Run-time error '5': Invalid procedure call or argument It happens when in the following code: Private Function GetImage() As Picture Dim BinaryData() As Byte Dim mstream As ADODB.Stream Dim pb As PropertyBag Dim picPicture As...
  3. Namlop

    Outlook - Change from...

    Unfortunatly not. .SenderName is read-only and .SentOnBehalfOfName can only be used in combination with the adressbook. But since i have no access to the adressbook that's not an option either. I love work. I can just sit and look at it for hours.
  4. Namlop

    How to read the content of text file?

    First goto: Project --> References then select Microsoft Scripting Runtime Then in your code add the following Dim objFso as new FileSystemObject Dim objTxtStr as TextStream Dim strFileContent as String set objTxtStr = objFso.OpenTextFile(your filename) Do while not (objTxtStr.AtEndOfStream)...
  5. Namlop

    Outlook - Change from...

    Hi, I've got a question. What do i need to change in my code so that when my program sends a mail, the recipient will see my programs name by From instead of my name This is my code: Sub SendMail(strEmail As String, intResultaat As Integer) Dim olApp As New Outlook.Application Dim olNs...
  6. Namlop

    Change printer

    Oops, my mistake. I've already figured out how. ps. And i feel stupid, because it's so simple I love work. I can just sit and look at it for hours.
  7. Namlop

    Change printer

    I can use 2 printers. If i want to print with VB it automaticly uses my default printer, but i want to use the other one. How do i change this? I love work. I can just sit and look at it for hours.
  8. Namlop

    Can Access record symbols?

    Yep, set field type to 'OLE-object' I love work. I can just sit and look at it for hours.
  9. Namlop

    Print queue

    Lol, that was my first intention. But some field have to be calculated in a way that reports can't handle. So i had no other option then to use forms. I love work. I can just sit and look at it for hours.
  10. Namlop

    Print queue

    Is it possible to make your own print queue? I've made a form that can't be printed the normal way. If i want to print out all records i have to do the following: DoCmd.PrintOut acSelection DoCmd.GoToRecord , , acNext I've got 51 records, so in this case it means i've got 51 print jobs. I'd...
  11. Namlop

    combobox search system

    The code is fine. Check if the names in your combobox are exactly the same as the fieldnames of your table. Have you tried selecting every value from your first combobox? I love work. I can just sit and look at it for hours.
  12. Namlop

    Printing problem

    I figured out what the problem was. I had to set the timerinterval to zero before i started printing. I love work. I can just sit and look at it for hours.
  13. Namlop

    Printing problem

    Let me rephrase the question. After the line DoCmd.PrintOut acSelection the program has to wait before going futher with the next code line until the page has been printed. Is this possible? I love work. I can just sit and look at it for hours.
  14. Namlop

    combobox search system

    ...ComboBox2.ItemData(0) End Sub Private Sub ComboBox2_AfterUpdate() If ComboBox0.Value = "City" Then ComboBox4.RowSource = "Select * from tbl_MyTable Where " & ComboBox0.Value & " = " & Chr$(34) & ComboBox2.Value & Chr$(34) Else ComboBox4.RowSource =...
  15. Namlop

    combobox search system

    ...type, right? So you can make an if statement. Something like this if ComboBox1.Value <> &quot;City&quot; then ComboBox3.RowSource = &quot;SELECT * FROM MyTable WHERE &quot; & ComboBox1.Value & &quot; = &quot; & ComboBox2.Value else ComboBox3.RowSource = &quot;SELECT * FROM MyTable WHERE...
  16. Namlop

    ComboBox

    No problem. But remember, you can't copy from the combobox when it is invisible. So you'll have to make it visible for a sec to copy it's content, after which you can make it invisible again. I love work. I can just sit and look at it for hours.
  17. Namlop

    combobox search system

    Unfortunatly not. But how do you fill your first combobox? Manually? I love work. I can just sit and look at it for hours.
  18. Namlop

    ComboBox

    You could add a textbox to your form that copies it's content from the combobox and make your combobox invisible. I love work. I can just sit and look at it for hours.
  19. Namlop

    combobox search system

    Oeps. I've been a bit sloppy It should be ComboBox3.RowSource = &quot;SELECT * FROM MyTable WHERE &quot; & ComboBox1.Value & &quot; = &quot; & ComboBox2.Value And there's a restriction to this solution. All the fields have to be of the same type. (If the type is text it should be like this...
  20. Namlop

    combobox search system

    ...= &quot;SELECT &quot; & ComboBox1.Value & &quot;FROM MyTable&quot; ComboBox3.RowSourceType = &quot;Table/query&quot; ComboBox3.RowSource = &quot;SELECT * FROM WHERE &quot; & ComboBox1.Value & &quot; = &quot; & ComboBox2.Value I love work. I can just sit and look at it for hours.

Part and Inventory Search

Back
Top