Search results

I want to open an excel document preferably from a command button. (after an export) but before the export, i would like to be able to replace the target excel document with its template...

I had a form that exports a query to an excel document... (some parameters on the form) I worked fine until I aded a criteria to the query,,, now the query still works fine but it wont export... tells me: to many defined fields.... can anyone help ?

I agree with Autoeng, I dont durrently see a need for other moderators

I have a couple pf external operation i would like to control from access and I dont know if i can be done... for instant, I would like to be able to open an excel document. And I would like to be able to perform a copy o peration..(copy an excel document from a folder to another) can this be...

I have a query wich is exported from a form... I this form, i have a drop down menu that contains search criterias... I had the folowing code in my query in the criteria field: [forms]![formname]![dropbox] but when the dropbox is empty, i want the query to display all the records as if there...

I tried all that... nothing is working... I tried the same code on another DB on a different computer and it worked... So i'm stuck... maybe its the computer

I have a problem with the folowing line DoCmd.TransferSpreadsheet acExport, 8, "tablenameQ", "C:\test.xls", False I get an error saying that update is impossible, database or objet is read-only. But neiter the database or excel document is read-only... why is this ? thx

I need to export a parameter query ... I have the folowing code: DoCmd.TransferSpreadsheet acExport,8,"queryname", "C:\test.xls" Then i am prompted for the parameters.... but is there a way to enter the parameter in a form... example... I would choose the parameter from a list... and then...

Maybe when you're on the network, someone is accessing data on your HDD and this takes ressources from the machine and slows down your data access time... or maybe ressources are used just maintaining the network connection...

Another thing a thought about... i could use a parameter query... but the parameters would have to come from a list in a form... how would i do this ?? and would it export the right data ?

Pat Hartman I'm not sure i understand.... I'm still a n00b in access... what do you mean by Just reference the query in the TransferSpreadsheet rather than the table. ? One other thing I thought... can the criterias of a query be changed with code ?

ok but i have to affect the dlookup to a variable... it wont let me run this command alone DLookup("[number 1]", "Tablename", "[critere 1] = 'c1' ") so i dit this : Dim varx As Variant varx = DLookup("[number 1]", "Tablename", "[critere 1] = 'c1'") DoCmd.RunSQL "UPDATE buffer SET [numero 1]...

hummm weird.. i get an error on the SQL string.... says sintax error on "Select [number 1] from tablename" the table and field name are correct...

I want to do populate a certain field of a blank table with part of another table (for exportation) What i thought about goes something like this but i doesn'work,,, dont know if it even possible ! Dim SQLstr As String SQLstr = "Select [number 1] from tablename where [critere 1] = 'c1';"...

ok ok ok thx :P but there is something i want to do before i export the table... I have a result table (3 results fields and other descriptive fields)with numerus reccords. I only need to export those 3 relult fields for a limited number of reccords... depending on the descriptive fields...

ow woulk ok ,,, thx, i'll look into that,,, but i'm not sure it will be usable for what i need to do ... I have a table of pruducts... and I want the user to be able to select search criterias (in a form) and see the normal distribution in a excell sheet... but only the distribution of part of...

Exporting ! HELP PLZ How do i export a field of a table to an excel doc ?? or even better ! can I export a SQL statement ?

I have a table containing numerical values,,, I need to display a graph of the normal distribution... someone told me i sould export the data in exel and then display the proper graph... but i dont know how,,, especially since this all neds to be done at the push of a button... can anyone help...

positions: IIF([Compression_Position]<>0,[Compression_Position],IIF([durabilité_position]<>0,[durabilité_position],IIF([MV-Absorption_position]<>0,[MV-Absorption_position],IIF([Entrée échantillonnage_Position]<>0,[Entrée échantillonnage_Position],null)))) this is the exact line giving me an...

Where do i put this code ?? <code> SELECT nz([fld1],0) AS a, nz([fld2],0) AS b, nz([fld3],0) AS c, nz([fld4],0) AS d, Switch(Val([a])>0,[a],Val([b])>0,[b],Val([c])>0,[c],Val([c])>0,[c],True,Null) AS z FROM Table11; </code> I need nomething to but in a qeery field... and the fields (1 to 4)...