Search results

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

I'm using the following code as a confirmation validation type thing, but currently F_Name and L_Name are not spaced apart. So it looks like: JaneMorris on the alert box when I want it Jane Morris for example.. The code: I guess its a really easy thing, but I am such a rookie. Thanks again...

Damn.. I solved the problem.. I forgot to change cboPlan to the fieldname that it converts to on the payments form which was Plan_Name. Now it works! Thank you all ever so much, yet again!

Sorry for the double post.. Anyone can help? :confused:

I am still getting the same erro as described in my previous post. It also brings up the code view with this object name highlighted '.cboPlan'. Which is the combo box it uses to get the string from.. Any ideas? Thanks again!

Hey guys thanks for the help, but I am getting the following error message: Is it because I am supposed to code the parts in the 'comments' bits myself? If so, I don't know how.. :(.. I'm so close I can smell it lol.. Thanks so much for any help at all!