Recent content by nIGHTmAYOR

this site does the very exact trick that is the topic of this post (5 years old now) and yet charge you heaps of money for it :)

Woo Woo Woo , where are you heading with that horse ? First of all what are you trying to achieve ? Replication ? If so could you use Virtual Private Network and Sync both dbs ? Or is it something more secure , then why wouldnt you send a saved setting table that you custom create and then have...

Oh as for the 10 line code ERP , I never asked the PHP programmer to show them for the reason that I assumed they must be listed open source somewhere ;)

Ok I like sarcasm , but think of the following scenario : A stuppid sales module : You have two tables - 1 - Items Records 2 - Sales Records And then you want to update Sales Records judging that : - -you want to type a number of letters -auto complete kicks in -drop down menu show availability...

Here is a peculier case that i was faced by alot and this is my discovered way around. In a continuious form , if you managed to bind the primary key to a combo box you might be faced by weired cases of random value display in field in combo box that are not what were initialy assigned by user...

formatting a report realy belongs to reports section , however i'd still suggest u open property of both charts and copy all the tweaks from the one you are satisfied with to the other. or a better and easier mean , just delete graph 2 and then copy paste your desired graph in its place , and...

If nz(Me.txtdate,"") <> "" Then strSQL = strSQL & "'" & Me.txtdate & "' AS date,"

first of all your question is missplaced , you should have asked that in Reports forum , i personnaly solve issues like yours using subqueries and joins in constructing the record source of the report for two main reasons : 1 - dlookup runs slow on reports and would render a beafy report dead 2...

ok let me take another wild guess , you splited your database and then you are now using one side as gui and the other as db , and now you are trying to run this code from gui side on a linked table generated by split wizard . interesting enough dao wont function that way , dao cant handle...

you cant , cz error will change to stack overfollow as ms access believes on repetition of error that it is falling within an endless loop. i would suggest for your quest using the form timer insted , use interval of 1 second then let it loop on failure at check on whatever it is you want to...

loads and loads to enquire to have this solved .. 1 - are you talking about a text box or a combo box ? 2 - did you try compact and repaire at least once ? 3 - did u try copy / paste all controls to a new form and check if problem persisted ? 4 - Finaly did you try it on a different pc and the...

Despite the vaguness and valiedity of your question and that you can get access or whatever vba supporting application to mail your lotus notes workbook . what object have you been using ? was it outlook ? was it sendobject function ? third party ? Yet before you answer do note the following ...

i'll try to assume u mean u have a table named : Table1 also a field named : Subject and then a listbox named : listbox1 i will niglect the rest of the odd setting and the reason for all of this , then the code goes (in "On Filter" property of a form add the following code) : Form.Refresh '...

Ok as per request i managed to attach a working model of the EXE project discussed above to add to your work along with its source code in visual basic 6 format . Please follow the instructions above carefully before requesting assistance . Best regards :) nIGHTmAYOR

1 - ok i'm not realy sure what phase you are in and what troubles came with but all i saw were covered issues , securing back end was tackled during illustration (disabling bypassing and compiling your project/stripping out the hash). 2 - you are mixing encryption with password protection...