Search results

Both techniques in nature wont slow things no , yet do note that useing timed requeries often annoy users (jet retrieve full tables then virtually construct the query which takes a moment of uncalled for pause within application - Hopefully you dont use small time intervals)

Yes you can use a 20 line code posted on microsoft OR : Private Sub GreenBack() Dim Green As Long Green = RGB(0, 128, 0) Me.Label5.BackStyle = 1 ' Changeing Backstyle to Normal so you can edit BackColor ;) Me.Label5.BackColor = Green End Sub

Welp for a start you should have used "file system object" since you plan on creating / editing / formating text files , however i hate to see all that code thrown away so why not use file system object to just clear the file before Open function can APPEND to file , just enter the following...

Well u can always use the Form's "On Key Press" property to reset your Requery timer (And thus buy you more time as you type) and remember to enable "Key Preview" property for form for such event to activate. Also if that doesnt do it for you you can dig for resources on a windows api called...

xzy this problem happens even in Arabic however the problem doesnt happen on data retrieval nore texts bound to a control source but only on design view of both forms and reports. The faster and less hassel way to solve it is to type the text you want to insert in your control in note pad then...

Ok i have tried to work with that control but it returns OLE object non registered for me , however i could access its properties but it's very limited as u have noted. however here goes a trick that works under all conditions : in On Got Focus event property use : Form.Allowedits = False...

on your head be it :) Dim rst As DAO.Recordset Set rst = Me.RecordsetClone rst.MoveFirst 'if on abort you want to start from an exact record use instead rst.Bookmark = Me.Bookmark Do Until rst.EOF If MsgBox("Do You Realy Wanna Do This ?", vbCritical + vbYesNo...

are you by any chance useing a third party list box object or one that isnt in access default library ? i have worked hard to make a list box editable but the closest to it was a 10 line of code leap , so how is ur control doing it ?

interesting , why isnt "On error resume next" doing it for u since u r about to use coding anyway?

For petes sake , ever since u started ur project and u r trying to achieve something so small with as much code as possible , now for a start why would a professional try and help with a code that's so puffed up , why wouldnt u ask for how it would be done than rather brake it and ask...

simply cover a number of security holes by inserting invalied charachters on where they are triggered and reassigning original charachters on the need of use through an external hex editing api

hmm so what if altering the binary was what matters ?

Presto....

interesting , comparing notepad to hex editors .. hmmm ok let me put this straight , yes its possiable , how it failed with banana was merily because notepad converts control charachters to unicode font bu never mind that . if u r intrested in another amazing fact you can do it while users...

by default reports can be export to both excel and word format , look for office export for analysis icon in tool bars ..

Could hex editing a microsoft access db pass as data manipulation ? :) thats about it.

Anybody still have documentations on dns-less connections as for a mysterious reason it hasnt been updated a while now and hard;y shows on search engines Best regards.

Ur welcome . Polite people always get to me :)

heh hassel it is. after further development on a form (declaration of subs , etc.) General Declaration Section of a form is known to have this bug of shifting codes other than Options to become part of the very next procedure (thus generating the error he was haveing) while users could swear...

all you miss is just a line saying : rst.Open "Query1", cnn and yes , access programmers just copy paste DAO scripts so you bring ADO to a discussion and too much hair scratching arise :) (Commenting his 6 hours wait :) )