Recent content by vicky666

OK, well I've searched far and wide and I found this... http://www.mvps.org/access/modules/mdl0027.htm hope it helps anyone else with this problem. Cheers Vicky

Hey SkipVought, Sorry about the late reply, I thought I had already reponded to this but shortly after the server went down, must have messed it up, so here it is again :) A multi-level bill of materials is exactly the kind of thing I need. Would you be able to help me in designing it, or...

Hey All, I'm hoping this won't be too difficult, but I'll see how it goes. This database will be a list of drawing numbers. Now each drawing number can have many other drawing numbers linked to it. Basically a drawing number has many other items of stock within a drawing, which also have their...

Chance1234, I think that may have worked, although I needed the list box displayed in numerical order. Thank you for helping me out regardless though :) TonyJollans, you were nearly right :P The code you wrote just needed to go after the line you put them before. i.e. .GoTo...

Hey All :) The following code loops around and takes all the selected values from a list box and places them into a word document at a certain breakpoint. (this all works) Naturally the code starts from the lowest number, and works it's way up. This causes a problem, as when the data is...

If I enter a memberid into a text box I need to be able to see if it exists in an access database. Basically a comparison string cheers

I managed to figure it out just re-edited the file to remove the data, thanks for ya help though :)

ok now i know this is simple but i cant remember it to save my life, How do you either delete all content of a text file or delete a text file and recreate an empty one in its place? sorry for the lack of knowledge vix :)

Cheers matey works a treat

HI guys have a small problem, basically i have this data that I want to save into a textfile which will be called whatever the date happens to be, but because the date contains "\" these things, it say file path not found. The code below works as long as you put your own filename in...

Cheers for the help guys :)

I would like to create a unique key with the format G0200000 (G02 Must not be changed) to be incremented automatically (G0200001, G0200002, etc) when a new record is created. I know this problem was posted earlier but the result wouldnt work on my mysql command prompt.The attribut to be...

Thanks for the help it worked :D

I want to open an access database from within visual basic, the code below seems to open access and then shuts it again, any ideas?Could something be running in the background that is conflicting with the code? This is driving me mad :) Dim appAccess As Access.Application Dim strDB As String...

I am trying to open a specific access database from within vb which runs when i click a button, below is the code i have so far but when it runs it opens access and then shuts it down straight away - any ideas? Dim appAccess As Object 'Open excel and make visible Set appAccess =...