Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 428
Search took 0.02 seconds.
Search: Posts Made By: Tieval
Forum: Modules & VBA 10-22-2019, 07:40 AM
Replies: 12
Views: 166
Posted By Tieval
Re: How to export report to PDF with dates and cbo criteria?

I only changed the date bit, if you look at the data source of the report you just need to change the other bit there.
Forum: Modules & VBA 10-22-2019, 07:13 AM
Replies: 12
Views: 166
Posted By Tieval
Re: How to export report to PDF with dates and cbo criteria?

There is an odd issue in access with filters and the like only working when you open the report, not when you export it. I would put the date from and to in the data source of the report as date...
Forum: Modules & VBA 10-22-2019, 06:43 AM
Replies: 12
Views: 166
Posted By Tieval
Re: How to export report to PDF with dates and cbo criteria?

Make a date from and date to on a form and configure your report to work between them, make a button with the following on-click event:

Private Sub Command25_Click()
On Error Resume Next...
Forum: Modules & VBA 10-17-2019, 12:50 AM
Replies: 13
Views: 222
Posted By Tieval
Re: Output Open Form to PDF

Many thanks Arnelgp, I may be a while working that out but will give it a go.
Forum: Modules & VBA 10-16-2019, 05:07 AM
Replies: 13
Views: 222
Posted By Tieval
Re: Output Open Form to PDF

Well, I am beginning to think no :rolleyes:

I was hoping I had missed an obvious easy solution but thanks to all for their help.
Forum: Modules & VBA 10-16-2019, 04:02 AM
Replies: 13
Views: 222
Posted By Tieval
Re: Output Open Form to PDF

Hey, you learn something new everyday, this gives you the primary screen.

Unfortunately I was looking for something that allowed a button press to just dump an image to a file in case it were ever...
Forum: Modules & VBA 10-16-2019, 03:20 AM
Replies: 13
Views: 222
Posted By Tieval
Re: Output Open Form to PDF

Well no, print screen would capture the content of both monitors as it is in extended mode, this is why I was hoping to grab just the form or even the database window.
Forum: Modules & VBA 10-16-2019, 03:03 AM
Replies: 13
Views: 222
Posted By Tieval
Re: Output Open Form to PDF

Many thanks Arnelgp, I had basically done this as follows:
DoCmd.OutputTo acOutputForm, "frmQuoteNew2", acFormatPDF, "z:\test.pdf"
My trouble is that I am using a full screen and it is too wide for...
Forum: Modules & VBA 10-16-2019, 02:32 AM
Replies: 13
Views: 222
Posted By Tieval
Output Open Form to PDF

I have a strange question.

I have a form that I use as a calculator for quotes and happily store only the data I usually require in a table but throw most of it away. Occasionally I want to keep a...
Forum: General 04-17-2019, 06:59 AM
Replies: 8
Views: 215
Posted By Tieval
Re: Chart Currency

There is a setting in the chart for 'Primary Values Axis Format' which you can set to currency, this seems to achieve the $ sign rather than your universal currency setting.
Forum: General 04-17-2019, 06:02 AM
Replies: 8
Views: 215
Posted By Tieval
Re: Chart Currency

It's only for my use so I don't care too much, suspect it is a bug from our friends at Microsoft but just put it out there in case I had missed the obvious.
Forum: General 04-17-2019, 05:51 AM
Replies: 8
Views: 215
Posted By Tieval
Re: Chart Currency

I guess I am using a modern chart then :banghead:
Forum: General 04-17-2019, 05:29 AM
Replies: 8
Views: 215
Posted By Tieval
Chart Currency

I have a chart in a form that displays monthly figures from a query. All aspects of my database that are currency display as currency with the symbol set to as per my windows settings, the chart...
Forum: Modules & VBA 03-20-2019, 07:58 AM
Replies: 25
Views: 446
Posted By Tieval
Re: ORDER BY will not work in report's Me.RecordSource

Yes, Colin is correct, the lack of a sort order in the report sorting and ordering will overwrite your original on-load setting. I have had this in the past and despite the lack of logic, I found...
Forum: General 02-22-2019, 01:03 AM
Replies: 5
Views: 145
Posted By Tieval
Re: Intermittent Start up issues

Could be completely different but I also have a similar problem.

Using Windows 10 my systems do not always connect the network drives on start-up, you can occasionally see a red x against them in...
Forum: General 02-18-2019, 02:41 AM
Replies: 8
Views: 213
Posted By Tieval
Re: Price auto value

What you need to do is store the price with the order when you enter it but to take this price from a table of current prices.

Basically have a table of current prices which you can update as and...
Forum: Forms 12-07-2018, 12:43 AM
Replies: 13
Views: 648
Posted By Tieval
Re: Switchboard - Odd Request

Thanks for all the comments and advice, pretty much what I thought, just hoping for one of those hallelujah moments when somebody said 'just do this', I did suspect it wouldn't happen though. :cool:
Forum: Forms 12-04-2018, 04:14 AM
Replies: 9
Views: 248
Posted By Tieval
Re: Form Field Calculation Errors

After much head scratching, this seems to be a network issue, I am thinking that the maths is done on data not yet received occasionally:mad:
Forum: Forms 12-04-2018, 04:06 AM
Replies: 13
Views: 648
Posted By Tieval
Switchboard - Odd Request

Is it possible to make the standard switchboard multi-column?

This may sound a strange question but I find using a switchboard as an entry page for a database for too space-taking.

As the...
Forum: Forms 12-03-2018, 07:25 AM
Replies: 9
Views: 248
Posted By Tieval
Re: Form Field Calculation Errors

The vba setting of this is in the load event and that triggers but gets it wrong randomly.
Forum: Forms 12-03-2018, 06:56 AM
Replies: 9
Views: 248
Posted By Tieval
Re: Form Field Calculation Errors

Hi Missinglinq,
It is not a continuous form, Just similar items stacked(as attached).

It is used as a calculator so a quantity of hours (default value zero) can be applied to the hourly rate...
Forum: Forms 12-03-2018, 03:12 AM
Replies: 9
Views: 248
Posted By Tieval
Re: Form Field Calculation Errors

Interestingly you cannot set it in vba (me.textbox.value = 0) as this errors.
Forum: Forms 12-03-2018, 03:09 AM
Replies: 9
Views: 248
Posted By Tieval
Re: Form Field Calculation Errors

Hi Minty,

As the default value of the text box in the property sheet.
Forum: Forms 12-03-2018, 02:53 AM
Replies: 9
Views: 248
Posted By Tieval
Form Field Calculation Errors

Hi,

I have some form fields which a calculation is based on when a form is loaded, unfortunately it works randomly.

As per the attached examples, the consultancy rate (unbound) has a quantity...
Forum: Modules & VBA 11-28-2018, 03:06 AM
Replies: 31
[SOLVED] Requery Method
Views: 685
Posted By Tieval
Re: Requery Method

Hi Colin,
I do like to understand what I am doing rather than just sticking code in so hence my curiosity. A bit of confusion set in here as I think what I was seeing occurred when there was no If...
Showing results 1 to 25 of 428

 
Forum Jump



All times are GMT -8. The time now is 08:37 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