Search results for query: *

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

ooops! Thanks for all the help, as you can probably tell ive been working on this for too long and keep making silly mistakes lol, im going for a break :)

My code is below and on the line wbkSaveData.SaveAs strResponse is where the error occurs and it says "object required" Sub SheetSave() Dim wbkDataSave As Workbook Set wbkDataSave = Application.Workbooks("TeachingPlan.xls") strResponse =...

The code is consistent and the value of strResponse is the filepath that i specified but the error still appears in that line wbk.SaveAs strResponse also it doesnt save the file to the location specified

It brings up the save as box but then when you enter the file name and select the location you want and click ok, there is an error in the line wkbSaveAs strResponce and suggestions?

I want to create a Save As dialog box that appears when i click on my label, i have this code below so far but i don't know what to dim my dialog box as, can anyone help as I am new to this? Dim wkbDataSave As Workbook Dim strResponse As String Set wkbDataSave =...