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

    Activex control using Access 97 for CD Archiving

    you might try finding the cd recorder controls on their website and add that component then programming your burn option.
  2. WhiteZiggy

    dumb Question..What does a recruiter mean by ADO experiance?

    Heres is a good example... If this is your code... "Public Function ProcDataMIN(ByRef xlwb As Workbook, ByRef xlws As Worksheet, _ ByRef currentrow As Long, filename As String, fpath As String, _ SearchValue1, override, xCount) As Long Dim adoXL As ADODB.Connection Dim adoRS As...
  3. WhiteZiggy

    dumb Question..What does a recruiter mean by ADO experiance?

    Ok, I might be dumb, but what as far as recruiters does ADO mean? If you use VB 6.0; dont most use ADO? Is ADO where the SQL is built in? Are you doing ADO by using the MSGRIDS?( is that the definition?) Is it a special packaging within VB? I specialize in user interface and reporting and am...
  4. WhiteZiggy

    Running VB from Switchboard

    you should be able to call the code by simply : "Call ImportValues" . Make sure your procedures are public. WZ
  5. WhiteZiggy

    faxing word document from within visual basic application

    Here is a way if you have a database of numbers... You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
  6. WhiteZiggy

    faxing (SendObject) w/ Outlook 2k / Win 2k ???

    I use XP Pro. Here is what works for me... You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
  7. WhiteZiggy

    Faxing a Report?

    You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
  8. WhiteZiggy

    Printing multiple forms or reports to a single fax document

    You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
  9. WhiteZiggy

    Auto Faxing Reports

    You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
  10. WhiteZiggy

    Any Win Fax Pro gurus out there

    You can use MSFAX is you wish. You just need to set up in outlook (thats my email client) add a new email called Fax Mail Transport. It is in the list you chose from. Then in the modules section place this code...
  11. WhiteZiggy

    Adding "ALL" to Combo Box

    I was having the same problem. I have it i Think. The problem is the "Like" . You dont need the IIF. Just change criteria in the query to read. "Like [Forms]![frmQuery]![cboAccount]" With the "Like" in the front. Then use the other example with the * as the holder. Column 1 | Column 2...
  12. WhiteZiggy

    How do you add an "*" or all line to combo box?

    Question, I have a combo box that gets its data from a table/query. How can I add a value that is not in the table or query? I want to have a value at the top such as a "*" or the word "All". They are searching by 2-3 criterias. They dont have to select a region for instance. Thus they would...
  13. WhiteZiggy

    Error on Calculated field in print only

    There is no source. I add all where credit = CR and deduct all where credit = db.I could set 2 boxes and then another to the sum of the 2. But I want to get it working first, before I "hack" a solution. :) If you have never used code you haven't used 1/2 of what you can do with the reports...
  14. WhiteZiggy

    Error on Calculated field in print only

    Help... I have a field, totaldollars. It is a sum of all credits minus the debits. This is done during the onformat property of the detail. I Then set a text box to the number. At the group header i reset the number to 0. I have the variable declared and everything looks great, until I print...
  15. WhiteZiggy

    Summary Info not exporting to excel....

    Ok.. I have this nice report. I have made all the details invisible, since I only care about the totals. I have it looking correct in access, but when I export to excel i get a blank sheet. Why? Does access not export totals? I know I can go and make the query with totals first then base the...
  16. WhiteZiggy

    Suggestions needed on reSetting a Combo BOX after a new entry ..

    Yes thanks...I will try that first thing in the morning.. Jeremy
  17. WhiteZiggy

    Suggestions needed on reSetting a Combo BOX after a new entry ..

    When I do that it gets stuck in a loop and keeps saying the entry isn't there. Yet when i look, it is.. It is really annoying to have it say its not there, then it is... :((
  18. WhiteZiggy

    Suggestions needed on reSetting a Combo BOX after a new entry ..

    OK, I have a combo box (cbo), that gets its values from a table/query. I want to add the entry to the table if its not there and then reset the drop down. Here is what I have so far.. Private Sub cboVendorNames_NotInList(NewData As String, Response As Integer) Dim strSQL As String Dim...
  19. WhiteZiggy

    How do you update db (ie. new forms) without deleting data?

    Question, I have made databases, but never compiled them into exe except vb projects, which of course didn't contain the DB in them, just the connection strings. If you compile your Access DB, how do you do the enhancements? Won't upon install overwrite the previous db or is that an option to...
  20. WhiteZiggy

    Question involving using the Excel.Getopenfilename..

    Thanks. As I thought, and you pointed out, the reason my object wasnt working was because the excel was invisible. So I couldnt ever get back to it... Thanks, Jeremy

Part and Inventory Search

Back
Top