Search results for query: *

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 :-)

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

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

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.

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

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

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

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

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

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

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

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

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

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

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