Recent content by dynamix

  1. D

    Connect Program to Database Backend

    Sweet, it worked :O! One question.. With the importing of the text file, the formatting has gone all crazy and the fields/columns are absent (everything is being crammed into the one column (see screenshot attached). How would I go about sorting the fields out etc? See screenshot attached...
  2. D

    Connect Program to Database Backend

    Okay, so I'm a real rookie with VB and well.. Access too.. So I need it in Laymens (if ou can go anymore 'laymens' than you already have?).. To give you some idea what I've done, here goes: -----I added that code you gave me (above) and then created a database with one table and all the...
  3. D

    Connect Program to Database Backend

    Thanks for your reply. 1. How would I go about your option 1? 2. Just looking at the option 2 you gave me.. I do not have a server and I am not hosting this online.. It's just for a school project. Thanks again!
  4. D

    Connect Program to Database Backend

    I don't think it's possible to explain it anymore clearly.. It's a pretty straight-forward question.. I thought.. When the data is saved, instead of saving to the .txt file, I want the data to save to sme predefined tables in a database backend. I wanna drop the .txt file completely and just...
  5. D

    Connect Program to Database Backend

    Hey guys... I created a reaaaally simple wages calculation program some time ago in VB6. When you click the save button, the records are saved to a .txt file stored in the same directoy as the program itself. However, I'd like to take this a step further and connect this program with some...
  6. D

    'Make MDE File' - Gone..

    I;m using Office XP btw. Your guidance worked, thanks!
  7. D

    'Make MDE File' - Gone..

    What do you mean?? Isn't that supposed to compile the code?
  8. D

    'Make MDE File' - Gone..

    Hey guys.. I am trying to make my DB into an MDE file however that option which is in Tools > Database Utilities is not highlighted on this particular database. Anyone know why? Thanks! EDIT - This features seems to be inactive on all atabases on my computer (I haven't tried another computer...
  9. D

    Custom Tool/Menu Bar Added

    Ah. Sorry about this, but I rectified the problem. The settings in 'Startup...' had not been reset. Please delete.
  10. D

    Custom Tool/Menu Bar Added

    Hey.. I'm having a rather strange problem that no one can fix, apparently. My teacher is even baffled :S. Basically, I created a custom menu bar, took off some of the defaults, but now I am having a problem. I deleted the original custom menu bar and now I am posed with the following error...
  11. D

    Ordering Validation Functions

    Oh.. I see, that works :S.. How about if I wanted an alert box popping up if they have missed a field out and pressed the save button? So 'You must enter a value in F_Name" etc..
  12. D

    Ordering Validation Functions

    I have like 2 or 3 validation techniques on one field, most of which are triggered by clicking the Save button. One of these techniques checks to see if data in the field is present, the other is to format the date with a msgbox dd/mm/yyyy. But also, on the Save button click function there is a...
  13. D

    Best Post Code Validation?

    Thanks for that jgc. I'll give it a shot :). (Sorry mods, if this topic was not relevant)
  14. D

    Best Post Code Validation?

    Well the input mask in Access really sucks.. Though Post code is a tricky one. Just wondering if any of you guys have any solutions? Not urgent, just interested :). Would love to use something..
  15. D

    Space In MsgBox Code

Back
Top Bottom