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...
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 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...
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...
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...
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
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?
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...
in a stroke of genius I managed to forget the password to a file I was working on a few months ago.
I am the owner of the document, is there anyway of retrieving the password?
thanks
Sean
I have a parameter query where the user can select the filters to each field through combo boxes.
I need to be able to send the results of the query to a template I have in excel.
I have been messing around with some code I have found online, but so far I am only able to export results of...
I have set up a parameter query. The user is able to select the criteria from a combo box and run the query. It is not limited to list so the user is able to use the wildcard property to return results from unfiltered fields.
I need to be able to allow a wildcard entry into the date field...
I am trying to run a parameter query (w/ access),
I am having major problems trying to insert the wildcard clause, mainly because my inexpierence with SQL.
Now...my first question is, Do I need to insert a line which will permit null values?
or will just putting in the wild card clause with...
I am trying to export the results of a query to excel.
I have my current code posted below.
with this...I can export the query as set up in the wizard to excel with no problems, however I want to be able to Query with parameters (ie select a date range, or specific employee) and then export...
hi everyone,
I export the results of a ms access query into excel (that’s how management wants it)
In excel I need to do some conditional addition; I'm not sure how to go about it.
X Y Z
1 S 7
2 r
3 S 8
4 r
I want to be able to Sum...
On a form I have 3 fields which I sum to get (total 1) for each entry.
For each entry, I wish to be able to add the previous entries (total 1) to their own (total 1), to get (final total).
does this make sence and is this possible? If so, what is the best way to go about doing it?
Thank you
Sean
On a form I have 3 fields which I sum to get (total 1) for each entry.
For each entry, I wish to be able to add the previous entries (total 1) to their own (total 1), to get (final total).
does this make sence and is this possible? If so, what is the best way to go about doing it?
Thank you
Sean
Once I run a parameter query and have my data ready for report form, I find that I have too many fields to fit onto one page. (which is all my boss wants to see)
What I want to be able to do is arrange the fields on separate sections on one page.
My Goal is this...
run my query and open the...
I have a main form (form a) which enters data into a main table (tbl a)
then I have a parameter query which filters the data by up to 6 fields and displays it in database view.
Then I have another form which displays the filtered data in its entirety (looks like the first form)
Now in the...
Hi- I have a database which tracks job numbers.
Form 1 (Job_frm) enters data into a table (jobfile)
(frmsearch) is a form that Queries by parameter to filter the jobfile so that only desired information appears.
The results appear in a popup box in a datasheet type view.
I wish to be able to...
I am a very elementary level access user.
I am trying to set up a database at work and am having some issues with Querying via a form and having it displayed on a sub form.
I have started off with a large job file containing numerous fields pertaining to each job. I then took several of the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.