Search results for query: *

thanks for the response ED2020. I have decided to take this project in a different route. I have now given each site a separate query and separate export function. The first site opens the excel template, and exports the data. I want the 2-5 query's to export the data to the open excel files...

thank you for the response as well as the direction for later posts. I have decided on taking this project a different route, however I have another question for you. I have broken down each site into its own query. and given each query an export command button. the very first option opens...

I am trying to move the results of a parameter query to a formatted excel file. I use 2 command buttons on a form, the first to run the query (works) the second to export the data to excel (driving me insane) I am having problems having the information go to different work pages based on some...

thanks for the reply. However, I really need to the data to go to different sheets on the click. If I were around I would use your recommendation, however I am returning to school in a few weeks and I know that based on the people who will take over generating the recovery report, it would not...

I am using access to export a parameter query into excel. Upon the arrival of the data on the first workbook, I was wondering if it were possible to have the data duplicated onto other worksheets based on some criteria (location). example...all of the entries on the DB have a location. In...

I should also mention that upon hitting the export to excel command, the excel file does open. just no data gets passed...I'm assuming my problem is in identifying the record set? and by that i mean I really dont know also...sorry about the lack of TGML on that last post!

I am trying to move the results of a parameter query to a formatted excel file. I use 2 command buttons on a form, the first to run the query (works) the second to export the data to excel (driving me insane) I am having problems having the information go to different work pages based on some...

thanks alot! thats exactly what I am trying to do!

Is it possible to protect the data on the form level without installing user level security? If data must be deleted I would like the only way for it to be possible is to go to the table in datasheet view and remove it there. The reason for this is that I am having trouble with users...

thanks! this should take care of it! SL

Iv recently run into a problem with the database I have been creating. It stems from two user-entered fields, hours paid, and hours worked. The user enters information at weekend (employee, job number, hours worked, hours paid, pay period end) the information then gets exported into excel I...

Hi VRoscioli, thanks for the reply. I am not having much luck. The error msg is run time error 3061 "to few paramters" the line which is returned highlited is Set rstOutputCurrentDb.OpenRecordset(sqlString) = however I get the feeling that I am going about this the wrong way. any...

My file is used by several people on the network.However, when it is opened on a computer other then my own the formatting all changes on the forms.(pictures resize, windoes dont show all the icons, etc.) is there an option I need to select? Thanks Sean

hey everyone, it works, in the table i changed the data type to currency, and the format to fixed, in the combo box , I changed format to fixed it works, the zeros only show up when there is a decimal, and the dollar sign doesnt show up. thanks Sean

I have had to go back and make changes to my DB to allow databases in a field in both the table, and its form. I have tried going into design view and changing them but even with decimal selected under field size and format, but it still goes back to 28.0 when I try to enter 28.5 any suggestions?

this is the line which comes back highlited when I step through the program. Set rstOutput = CurrentDb.OpenRecordset(sqlString) However, that was the first time I have ever tried to step through, so I could have done it wrong. what does this mean? Does that mean that there is something...

Thanks everyone for your responses, sorry it took so long to get back to you, I was out of the country. I have made some changes and there has been some improvement however I am still missing something. now when I run Query, everything still works fine, when I click the export the program...

I'm having issues getting exported access data to go to different excel work pages. this is what I am using on the on click property of my export function Private Sub exportcmd_Click() On Error GoTo err_Handler Const cTabTwo As Byte = 1 ' Excel object variables Dim appExcel As...

awsome guys! everything works! You can bet I will be mentioning a donation on behalf of our company at the next meeting! You all have really helped me out!

First off...a HUGE thank you to both of you! you've both been so helpful! Today I finally got the application to work!! sort of... but it worked...and that’s what’s important! So what happens is...I click on it. and it looks like nothing happens. excel doesn’t pop up. But...if I go into...