Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 39
Search took 4.90 seconds.
Search: Posts Made By: gippsy
Forum: Queries 09-28-2018, 04:20 PM
Replies: 8
Views: 20,003
Posted By gippsy
Re: Format within Query to 2 decimal places.

When I typed "0.00" MS Access automatically changes to "#.000".

Fortunately, I found useful for my project the format: "Standard"
When I typed "Standard" and run the query it returns 1.080,00...
Forum: Queries 09-28-2018, 02:54 PM
Replies: 8
Views: 20,003
Posted By gippsy
Re: Format within Query to 2 decimal places.

Hello.
In a Union Query, I used Round([field],2) for every single query.
However, when I run the union query shows the value as 1080 and I need 1.080,00
I already Format the query column with 2 in...
Forum: Modules & VBA 09-03-2018, 04:49 PM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

June7, Cronk, JHB, Ranman256
For all of you, many thanks.
Finally, I have a code to export and create a chart in excel.
This is my code:
ub cmdTransfer_Click()
Dim sExcelWB As String
Dim xl As...
Forum: Modules & VBA 08-24-2018, 05:17 PM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

June7.
I will test the code. As soon as possible, I will let you know if I succeed.

Also, I have been trying this line of code.
Range("C2", range("D2").End(xlDown)
However, I don't know what I...
Forum: Modules & VBA 08-24-2018, 02:24 PM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

June7. Many thanks.
I just tested this code and works fine:
Set ws = wb.Sheets("qry_task")
Range("C2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection,...
Forum: Modules & VBA 08-24-2018, 12:59 PM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

Cronk. Many thanks
I'll keep your code lines. I see these are another ways to create a chart.

Now, I'm focused on writing Range("C2:D" & i - 1) from the query to create the graph.
I really...
Forum: Modules & VBA 08-24-2018, 12:44 PM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

June 7.
Your code with my query works fine. Many thanks.
In my database, I have a command button to export a query to Excel Worksheet and create a chart.

Nevertheless, I need the chart data...
Forum: Modules & VBA 08-24-2018, 09:47 AM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

Thanks to JHV, this line of code use all range of data from the query to insert the graph.
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "qry_task", sExcelWB, True
Set wb =...
Forum: Modules & VBA 08-08-2018, 05:37 AM
Replies: 10
Views: 650
Posted By gippsy
Re: ERROR 3011 when exporting access qry to excel to create chart

Cronk.
You are right with the bad yellow colour, it is in my vba editor. I really apologize.
Your code works perfectly.
Thank you for your contribution.

I have been googling for a code to...
Forum: Modules & VBA 08-07-2018, 06:54 PM
Replies: 10
Views: 650
Posted By gippsy
Re: ERROR 3011 when exporting access qry to excel to create chart

Mark
I really appreciate your reply

Well, I did your recommendation.
The MsgBox is "Exporting to: D:\testing\01_08_2018 * 03_08_2018_85_qry_task.xls"

I wrote the code using the Intellisense...
Forum: Modules & VBA 08-07-2018, 03:39 PM
Replies: 10
Views: 650
Posted By gippsy
ERROR 3011 when exporting access qry to excel to create chart

Hello
I have a form with three txtboxes to query between dates, one to select Date1, other to select Date2, and another to type the value of a code.
When exporting the file I need the file name as...
Forum: Modules & VBA 08-06-2018, 05:25 AM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

JHB
The problem was ERROR 91. Now the Error is fixed
The use of With is unnecessary
'With xl
'.Workbooks.Open sExcelWB
'End With

Thanks, again
Forum: Modules & VBA 08-06-2018, 03:48 AM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

Hello.
The code works nice and now I see the chart in Sheet Chart and the query in Sheet qry_01.
How can I do to display the Chart and the Query in the same sheet with the query name?
I really...
Forum: Modules & VBA 08-05-2018, 07:52 PM
Replies: 18
Views: 743
Posted By gippsy
Re: Export query from ms access to excel and create chart

Many thanks for your reply.
I apologize. The Editor displays the ERROR 91 on the line:
sExcelWB = "D:\testing\testchart.xlsx"

On the other hand, when I add your code the editor displays this...
Forum: Modules & VBA 08-05-2018, 06:21 PM
Replies: 18
Views: 743
Posted By gippsy
Export query from ms access to excel and create chart

Hello
I am trying to run a code to access-query-to-excel-2010-to-create-a-graph-via-vba. However, anytime the editor displays ERROR 91.:confused:
I cannot see the final product.
Moreover, I need...
Forum: Queries 02-28-2018, 06:52 AM
Replies: 17
Views: 639
Posted By gippsy
Re: exported query to excel with dates range file name

BoBaxter.

In my previous message, the access-programmers website didnīt allow to send the image that illustrates the error.
Forum: Queries 02-28-2018, 06:44 AM
Replies: 17
Views: 639
Posted By gippsy
Re: exported query to excel with dates range file name

BoBaxter

I ran the code you recommend me. However, anytime I enter the same date or different dates, vba displays error 13 in this line:
If DateValue(Me.txtday1) = DateValue(Me.txtplot) Then

I...
Forum: Queries 02-28-2018, 05:48 AM
Replies: 17
Views: 639
Posted By gippsy
Re: exported query to excel with dates range file name

Pat.
As I am improving my knowledge in vba, your explanation is clear and very useful.
Thank you very much
Forum: Queries 02-26-2018, 07:08 AM
Replies: 17
Views: 639
Posted By gippsy
Re: exported query to excel with dates range file name

June7 and Mark. Many thanks for your reply and help.

I attach the Database I am working.

The code in Command Button "Export All to Excel" runs well
The code in Command Button "Export All to...
Forum: Queries 02-25-2018, 11:55 AM
Replies: 17
Views: 639
Posted By gippsy
Re: exported query to excel with dates range file name

Gasman. Many thanks for your help.
I tried this code but does not work.
filename1 = "C:\Path" & Replace(Me.txtday1, "/", "_") & Replace(Me.txtplot, "/", "_" & "_") & "_"_"_qry_01.xlsx".

Could...
Forum: Queries 02-25-2018, 09:14 AM
Replies: 17
Views: 639
Posted By gippsy
exported query to excel with dates range file name

Hello

On 03-25-2017 sneuberg gently helped me with above code.
With this code I export a query to excel. If for example I search by day1 20_02_2018 and day2 20_02_2018 the code assign the...
Forum: Forms 06-02-2017, 03:01 PM
Replies: 7
Views: 456
Posted By gippsy
Re: Combo box to display 5 charts and 3 single images

Minty

I enclose the forms displaying 5 charts and one image.

The charts are displaying by the combo box. The image is displayed using the built-in navigation buttons.

I am looking for that...
Forum: Forms 06-02-2017, 07:34 AM
Replies: 7
Views: 456
Posted By gippsy
Forum: Forms 06-02-2017, 07:17 AM
Replies: 7
Views: 456
Posted By gippsy
Re: Combo box to display 5 charts and 3 single images

Minty. Many thanks for your reply.
My combo already displays the 5 charts, however, I have been unable to displays the 3 images at a time.

I Tried with no success.

[Private Sub mycbx_Change()...
Forum: Forms 06-02-2017, 06:48 AM
Replies: 7
Views: 456
Posted By gippsy
Combo box to display 5 charts and 3 single images

Hello

In Access 2013, I have a combobox that when selecting a value displays 5 charts, each chart based on query.

I need in the same combo box that when selecting a value displays 5 charts and...
Showing results 1 to 25 of 39

 
Forum Jump



All times are GMT -8. The time now is 02:11 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World