Search results

jus to clarify that; - constructed an sql transform-select statement, using a number of varibles according to what the user has selected, this is assigned to a list box - I want to export the listbox contents onto a spreadsheet - the query is not a saved/predefined object -...

the select statement is not saved as an actual query... its a statement that is compiled according to many user specifications The problem is - i will need to create so many different types of queries - to manage all the possible outcomes.. this is why i would like to somehow use the...

Hi I have a list box which displays sales figures - the data has been transformed into a more user-friendly layout using sql in a complicated vb process. On the same form i wish to create a button which the user can press to export the listbox data/layout onto a spreadsheet. Im hoping...

hI I wish to convert my database into a an mde file. I belive this removes all of the tables/source code etc. I would then like to distribute the database on a CD. I want the database to run like a program - so it can be installed onto a computer with a shortcut. I have created the...

Thanks very much for your help... I finally got it working - the statement was correct - where ive been messing with the code iv accidently removed the file name it should pick up. many thanks

ok i thought so... i have used the spec before, its the saved import specification for that particular file. i still get the error msg "wrong data type"... it must be the way i use the variable in the statement

no i cannot get either working getDIR = "C" or getDIR = rstDIR.fields("Local_Admin") does the import statement not need quotes around the 'DIRAddress'? My orginal import statment specified the path with quotes eiter end... "C\myfolder\import\daily_a.csv" however the...

an error message appears: "wrong data type"

I have tried the following but no luck; '*** getDIR is assigned to data "C" from looking at the table entry '*getDIR = "C" getDIR = rstDIR.fields("Local_Admin") '*complete string for path DIRAddress = getDIR & ":\myfolder\imports\daily_a.csv" '*with final import statement...

oh sorry... I have used quotes in my actual vb: getDIR = "D"

when the database is installed on either a laptop, stand-alone machine or even on a network they sometimes use different drive letters. c:/, d:/, h:/ wherever the user is - im trying to give them the option to change the directory to import some files this was my orginal import statment...

the user inputs the drive letter on a form - when updated the drive letter is stored in a table. This module collects the drive letter... from here i wanted to assign this varible drive letter to a variable name and use in the import statement... and having syntax difficulty rgrds

Hi I have a peice of code i use to import a .csv spreadsheet. doCmd.TransferText acImportDelim, "DailySpec", "c:\myfolder\import\daily_a.csv", False, "" The drive letter C:\ may sometimes change according to the user specification My module gets the specified letter - how...

Those were useful points - i have built some security functions into the database. Has anyone got an example of a written contract - i still fill this will be neccessary???

Email? Hi Still havnt got the sample contract if its been sent...? If anyone else has examples please send to following email wazzer_h@hotmail.com regards

sorry the database is being leased...

thank you .... wazzer_h@hotmail.com anyone else who has samples - please forward them so i pick out whats relevant... rgrds

Hi A customer wishes to but a database - i am hoping to have a contract in place which will protect the software from being shared between unlicenced users etc... Has anyone got an example contract which i could maybe use to get some ideas??? This will be a big help - thanks you! Rgrds

- how do i run the global module from a forms, button click? - thers quite a lot of code, calulating varibles relevant to the form, it seems it would be a quick win to simply run the other forms on click event - is this possible?

Hi Please help - this is really frustrating me.... I have two forms - one form contains quite a bit of code attached to a button (on click event) I have now produced another form - I want to run the same code as the event on-click in the original form I have normally called procedures...