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 Wanet Telecoms Ltd 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. badrion

    mql unsign bus? question?

    In Signatures, you can code to unsign a signature but anyone know how to set up to sign or bypass a signature if it is not needed??
  2. badrion

    ComboBox in side of a DataGrid

    Anyone know how to do this? I have a table with my Master data that contains regular fields and some comboboxes. BUT in VB when I bring them into a DataGrid, I don't get the comboboxes. Help!
  3. badrion

    Setting Tab order on FORMS in Matrix?

    Anyone know if this is possible?
  4. badrion

    Opening Excel over Network Failure

    Yes I've already got this, i contacted support and got it. It didn't work, still getting the error. Beginning to think it is a Client for Microsoft Network issue. I can open the document from here and have NO problems at all.
  5. badrion

    Opening Excel over Network Failure

    Blue screen of DEATH everytime our other factories try to open an XLS file over the network. Looked up on Microsoft Website, spoke with microsoft support, gave me a download. Didn't work. Exception OE in Vredir.vds durning cocreateinstanceex() on remove DCOM server. Anyone else have any...
  6. badrion

    Running a macro on Save and setting format

    I got it...... By setting the column to left Justify it fixed the problem. WIERD! No need for a macro afterall...... Sorry for taking up your time. Thanx.....Brandi
  7. badrion

    Running a macro on Save and setting format

    Actually I got this far, but the on save isn't working. I thought it was IF ActiveWorkbook.Save = True then Columns("C:C").Select Selection.NumberFormat = "General" End If MsgBox "Workbook format has been saved" 'just a check msg to see if it works I...
  8. badrion

    VBA, what is the command to EXIT the EXCEL PROGRAM!

    sorry, i put this in the wrong spot.....
  9. badrion

    Running a macro on Save and setting format

    I want to run a macro on save. The macro needs to check all cells that are 'numeric' and either change the format to 'general' or put a 'tick in front of the numeric expression. The reasoning behind this is I use this file in a VB application, it opens the file, queries out the data I need and...
  10. badrion

    VBA, what is the command to EXIT the EXCEL PROGRAM!

    I want to run a macro on save. The macro needs to check all cells that are 'numeric' and either change the format to 'general' or put a 'tick in front of the numeric expression. The reasoning behind this is I use this file in a VB application, it opens the file, queries out the data I need and...
  11. badrion

    SaveFile Excel as DBF file behind the scenes

    I would think there is a simple line of code that would take one file and rename it. I've tried what you said, modified alittle and still no go..... Thanks for the ideas though.
  12. badrion

    SaveFile Excel as DBF file behind the scenes

    I have tried so many different ways to do a SaveAs .dbf and nothing is working. I tried the savecopyas and saveas and excel.activeworkbooks.saveas...Ive even tried the xlbuiltindialog.saveas. Any ideas from anyone would be great!
  13. badrion

    SaveFile Excel as DBF file behind the scenes

    Any help would be great. I have an excel file that I would like to save as a DBF... but I don't want the user to see it happening.
  14. badrion

    ADODC Provider Not Found

    Is there another way to set up ADODC? I sent my .exe to a user and they keep loosing the provider. HELP!
  15. badrion

    Formating Excel

    I have a program that reads an Excel spreadsheet looks for a field with a "Y" flag and then exports it to a text file. Problem is: the excel file has all the fields set to General, but if a dealer changes their partnumber to a full numeric 12345, I have it reading it as a string thru...
  16. badrion

    excel to text file problem

    I have a program that opens up an excel file and grabs any line that has a "Y" and writes it to a text file. BUT when the user changes the "CUSTNO" to a numeric "12355" it kicks out that line. I have the EXCEL file set to general and I have the VB program set at a...
  17. badrion

    REPLACE function

    Rick, I apologize, it did work. I had it in the wrong spot. That's the problem when working with someone else's code. Thank you SO much.! Brandi
  18. badrion

    REPLACE function

    Rick, Thanks but it didn't work. It cleared out everything. Any other suggestions?
  19. badrion

    REPLACE function

    I'm still alittle new with FoxPro but I need to search a field NAME for a "#" sign or an "@" sign and replace it with nothing. I tried to do a SEEK FOR then a REPLACE/WITH but it didn't work. I'm guessing I put it in the wrong order or syntax. Any help would be appreciated.
  20. badrion

    Save existing Log file to a new log file

    Dim errordate1 errordate1 = Date Dim errordate2 As String errordate2 = Replace(CStr(errordate1), "/", "") PCpathLOG = DATpath + "WMS_error" + errordate2 + ".log" I got the path/filename and date to work. I just needed to copy this file...

Part and Inventory Search

Back
Top