Search results for query: *

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

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

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 :)

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

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

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

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

I am designing a mini system in Excel, and I want the user to be able to select any number of cells and when they click a button, their selected cells will be copied onto a seperate worksheet. I can get certain cells that i pre-define to tranfer over but can not work out how to transfer user...