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

    Reading MSWord .DOC as binary stream (offsets)

    Thanks, johnwm! It wouldn't be piece of cake, I know. But anyway, I have to write the app otherwise my coleagues have to open .DOC file outside the word, manually locate the text, copy it and throw away all unicode garbage. Unfortunately not all software support unicode chars :-)
  2. valtersp

    Reading MSWord .DOC as binary stream (offsets)

    I've already implemented another offset (A00h) for files created on PC's propably hurted by virus. The text into these .DOCs are not contigous, but divided into 2 parts with "space" length of 61Ah. I hope the exception list would not be too long :-) Currently I gave the app to my...
  3. valtersp

    Reading MSWord .DOC as binary stream (offsets)

    Hi all! I have had to develop the cross-platform app allowing to read ONLY text from MS-Word doc file into text box. Inspecting the .DOC file I found text begins at offset 600h. So I put the pointer to this offset and read the file as binary stream until 3 or more 0-valued bytes encounter. In...
  4. valtersp

    Newly Installes System Keeps Freezing and Crashing

    Try following 1. Restart system, press & hold left SHIFT key while starting up. If computer boots up normally, propably there are conflicts in extensions. Open Extensions Manager Control panel and select "minimal" option in dropdown mnu. Try, and tell, what's happening.
  5. valtersp

    find all worksheets in a workbook?

    All worksheets or only those who matches criteria? If so, try this Sub FindActualWorkSheet() For sh = 1 To ActiveWorkbook.Sheets.Count if sheets(sh).name=YourCriteria then ............ else ........... end if Next End Sub Hope it'll help
  6. valtersp

    compile excel workbook to web page - is it possible

    Of course, it's possible, but you need quite a much time to write the VBA compiler :-) At first, you should make a html page to make sure this is what you want to see and consider, which information will change (dynamic content) and which will remain untouched (static content). Dependently on...
  7. valtersp

    Excel and VBA UserForm - what a hell is going on?

    Hi all! There are some very strange things going on with Excel's VBA UserForms. 1st - when designing an UserForm, sometimes it becomes corrupted and I don't know, why (expecially, when save excel file as an add-in and edit it later). 2nd - all captions, which are used to name form's controls...
  8. valtersp

    PC MAC LAN

    If users on PC's want to connect Macintosh computer, they can use Miramar AppleTalk Network ( My Network Places) to choose a computer they want to connect to. If it does not work, check if: Only latin chars are used when providing Name and Password. I'm afraid, any çå?ßé¬ etc chars could...
  9. valtersp

    What is going on in UserForms???

    Hi all! There are some very strange things going on with Excel's VBA UserForms. 1st - when designing an UserForm, sometimes it becomes corrupted and I don't know, why (expecially, when save excel file as an add-in and edit it later). 2nd - all captions, which are used to name form's controls...
  10. valtersp

    Using SQL as a control source.

    The other solution is to create query while in run-time and use it how and when needed (as a ControlSource). You must specify QueryName and SQL string. Dim dbs, qdf, strSQL set dbs=CurrentDb set qdf=dbs.querydefs for each qdf in dbs.querydefs if qdf.name="QueryName" then...
  11. valtersp

    copy record does not copy all fields

    I am afraid you cannot copy whole record because primary index key is set to be unique. Why don't try to build up a set of controls with definite values (comboboxes and/or listboxes and/or textboxes) bound to fields you need to change rarely and textboxes bound to fields you have to change every...
  12. valtersp

    Search for a record using ComboBox

    Thanks evalesthy! As I have a string instead of number, single quotations must be included. So, it'll look like this: Dim strCId If Not IsNull(cmbXquick) Then strCId = "'" & Me.cmbXquick & "'" Me.RecordsetClone.findfirst...
  13. valtersp

    Update field on a table from a form

    As I suppose, You must put an "DoCmd.RunSQL" before query. So, it'll look like this: Private Sub Comando4_Click() docmd.runsql "UPDATE tblemp SET tblemp.imp =salary*0.04 WHERE tblemp.salary>=3000;" End Sub
  14. valtersp

    Search for a record using ComboBox

    The problem is the form contains another controls, such as textboxes, combo's which are used to edit records. The combo box described above should be used as a pointer to allow user jump and edit the record he (or she) wants - whether it'll be the first, last or tenth. Currently I've made...
  15. valtersp

    Search for a record using ComboBox

    Hi all! I've got a very simple problem, but still can not solve it at all. There is a ComboBox bounded to a field of a table and contains all records the table currently has (all values are unique). When user choose a value from ComboBox, it is necessary to find out, which record have been...

Part and Inventory Search

Back
Top