Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 3.06 seconds.
Search: Posts Made By: JHB
Forum: Forms Yesterday, 05:23 PM
Replies: 12
Views: 119
Posted By JHB
Re: Form and Query Help Please!

I think that is what you want, (look at the attached database).
Forum: Modules & VBA 06-18-2019, 08:37 PM
Replies: 2
Views: 72
Posted By JHB
Re: Making pivots in xlsx files in Access VBA

You code is missing a lot reference back to the created Excel object.
You need the reference to the Excel object in front of the following words, (because they are unknown for MS-Access)


...
Forum: Forms 06-17-2019, 06:44 PM
Replies: 6
Views: 100
Posted By JHB
Re: Frame on subform won't update

Because the sub form is placed on the main form.
Forum: Reports 06-11-2019, 05:39 AM
Replies: 4
Views: 83
Posted By JHB
Re: report showing data it shouldnt

Do you have a field called "ComplianceCode" in the table "tblEmailAddress"?
I ask because I can't find it and you use it in the below Where clause.
Forum: Modules & VBA 06-08-2019, 09:43 PM
Replies: 19
Views: 364
Posted By JHB
Re: Pass Data from MS Access to AS400

Can't you use a comma separated file instead?
Why should it be from MS-Access to AS400, why not from AS400 to MS-Access?
Forum: Modules & VBA 06-04-2019, 02:33 PM
Replies: 18
Views: 233
Posted By JHB
Re: Compile Error Syntax Error in Search Form VBA Code

And a &, (sorry that I haven't seen that in first post.

Me.Filter = "CommitteeContact = '" & Me.CommitteeContact & "'"
Forum: Modules & VBA 06-04-2019, 11:59 AM
Replies: 18
Views: 233
Posted By JHB
Re: Compile Error Syntax Error in Search Form VBA Code

You are missing a '
Me.Filter = "CommitteeContact = '" & Me.CommitteeContact "'"
Forum: Forms 06-02-2019, 12:21 PM
Replies: 7
Views: 131
Posted By JHB
Re: uneditable textbox record source from recordset

Could it be so simple that you need the Recordset?
Set Me.Recordset = rst.Recordset
Else post your database with some sample data + name of the form. Zip the database because you haven't post 10...
Forum: Modules & VBA 06-01-2019, 08:30 PM
Replies: 14
Views: 226
Posted By JHB
Re: Using Year

Yes these two are the same, but it was not what you wrote, go back and read your post #2.
You wrote that 11/12/2009 and 21/11/2009 refer to the same date!
Forum: Modules & VBA 06-01-2019, 07:30 PM
Replies: 14
Views: 226
Posted By JHB
Re: Using Year

Sorry - I do not agree.
Forum: Modules & VBA 06-01-2019, 06:44 PM
Replies: 18
Views: 405
Posted By JHB
Forum: Modules & VBA 06-01-2019, 05:29 AM
Replies: 18
Views: 405
Posted By JHB
Re: Unwanted CR LF character when using Chr(26)

I think rpeare had the solution with the Filesystemobject. Looking at the output it looks perfect.
https://access-programmers.co.uk/forums/attachment.php?attachmentid=75088&stc=1&d=1559395713
Forum: Modules & VBA 06-01-2019, 05:13 AM
Replies: 18
Views: 405
Posted By JHB
Re: Unwanted CR LF character when using Chr(26)

How do you delete it, do you save the file afterwards?
Forum: Modules & VBA 05-31-2019, 11:04 PM
Replies: 12
Views: 389
Posted By JHB
Re: Exporting a graph/chart from Microsoft Access to PDF/JPEG/GIF

You can make a work around - close and open the form again by code, it is not perfect but it works.

Dim TheFormName As String
..
..
TheFormName = Me.Name
DoCmd.Close acForm,...
Forum: Modules & VBA 05-31-2019, 05:38 AM
Replies: 12
Views: 389
Posted By JHB
Re: Exporting a graph/chart from Microsoft Access to PDF/JPEG/GIF

Sorry - No.

Get use to it - the error message from Access isn't always clear, (mostly not, but you learn what it can cause the error when you stay long enough by MS-Access), by me it was a quiet...
Forum: Forms 05-31-2019, 02:59 AM
Replies: 10
Views: 174
Posted By JHB
Re: open Form from form

Sorry can't open your database, seems to be corrupt - hopeful others have more luck.
Forum: Modules & VBA 05-31-2019, 02:43 AM
Replies: 12
Views: 389
Posted By JHB
Re: Exporting a graph/chart from Microsoft Access to PDF/JPEG/GIF

It works by me with the below code, new codeline added marked with red, (remember to change the blue codeline).
Working database (by me) attached.
Set grpApp = Nothing
Set grpApp =...
Forum: Forms 05-31-2019, 12:22 AM
Replies: 10
Views: 174
Posted By JHB
Re: open Form from form

Post your database with some sample data, zip it!
Forum: Modules & VBA 05-30-2019, 10:58 PM
Replies: 12
Views: 389
Posted By JHB
Re: Exporting a graph/chart from Microsoft Access to PDF/JPEG/GIF

The database crash when I try to change the tab, (from Report Builder to Summary Charts).
I'm using MS-Access 2010, which version do you use?
Have you tried to download your database from here and...
Forum: Modules & VBA 05-29-2019, 08:19 PM
Replies: 12
Views: 389
Posted By JHB
Re: Exporting a graph/chart from Microsoft Access to PDF/JPEG/GIF

I'm not able to change the form to another tabs, so I can't look at your example.
Forum: General 05-28-2019, 07:12 PM
Replies: 23
Views: 699
Posted By JHB
Re: Weird printing phenomena

I've MS-Access 2010, could you give a description (include the data to input) step by step how to reproduce the error.
I've tried the attached database + inputting new data and then print the graph...
Forum: Queries 05-24-2019, 06:22 PM
Replies: 29
Views: 631
Posted By JHB
Re: range period of time in a date query access

Hmm - are you not able to show the result you want or ??? :confused:
Forum: Forms 05-23-2019, 07:59 PM
Replies: 2
Views: 107
Posted By JHB
Forum: Queries 05-23-2019, 07:26 PM
Replies: 29
Views: 631
Posted By JHB
Re: range period of time in a date query access

Okay - then show the final result you want!
Forum: Queries 05-23-2019, 06:25 PM
Replies: 29
Views: 631
Posted By JHB
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 02:29 PM.


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