Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.13 seconds.
Search: Posts Made By: Trevor G
Forum: General 11-30-2018, 05:01 AM
Replies: 28
Views: 811
Posted By Trevor G
Re: eMail Databases with attachment option

The 5th line from the bottom is .Display place the line just above it

.Attachments.Add Me.FilePath
Forum: General 11-30-2018, 04:18 AM
Replies: 28
Views: 811
Posted By Trevor G
Re: eMail Databases with attachment option

Add this before the:

.Attachments.Add Me.FilePath
.Display
Forum: Excel 11-07-2018, 05:10 AM
Replies: 3
Views: 862
Posted By Trevor G
Re: Reset Named range.

You can look to delete the named range before you recreate it, incase it is causing conflict. I would suggest record a macro to find the named range and delete it then create the new named range...
Forum: Macros 11-07-2018, 05:06 AM
Replies: 3
Views: 1,502
Posted By Trevor G
Re: Export to Excel with filters enabled

You could look to convert the form button macro to VBA and then you can add the code to apply the filter no problem. Do you look to open the excel workbook when you run the macro?
Forum: Word 10-26-2018, 05:47 AM
Replies: 3
Views: 1,921
Posted By Trevor G
Re: Word drop down list populated from acess table

Have you tried to use Mail Merge to populate your document?
Forum: Word 07-12-2016, 02:39 AM
Replies: 1
Views: 4,074
Posted By Trevor G
Re: How to make a Check Box Form Field red if not checked?

You would need to use VBA to accomplish this.
Forum: Tables 07-12-2016, 02:28 AM
Replies: 12
Views: 854
Posted By Trevor G
Re: table design

Is the database created from within 365 as a new app? if so in the design of the table create a number field, in the properties you should see in the drop down

Number Subtype: Floating-point...
Forum: Modules & VBA 11-09-2015, 01:12 PM
Replies: 2
Views: 439
Posted By Trevor G
Re: [Help] Import & Validating Excel Spreadsheet

Why not consider running a duplicate query so you can identify the duplicates and deal with them in access.
Forum: Forms 11-09-2015, 01:10 PM
Replies: 2
Views: 321
Posted By Trevor G
Re: Issue with subform in navigation form in A2010

If you can place a copy of the database into your thread then you have more chance of someone identifying the issue.

Strip away any sensitive data make sure it is 2mg or less when zipped.
Forum: Excel 10-27-2015, 06:23 AM
Replies: 4
Views: 766
Posted By Trevor G
Re: Macro to add rows from wbk1 to end of wbk2

To make it easier for the code to follow correctly it would be better to have the Column Headings to be laid out the same.
Forum: General 10-27-2015, 06:05 AM
Replies: 3
Views: 2,184
Posted By Trevor G
Re: How to get system language in Access 2010 vba

Read this thread it provides the code you are asking for

http://www.access-programmers.co.uk/forums/showthread.php?t=184723
Forum: Excel 10-27-2015, 05:53 AM
Replies: 4
Views: 766
Posted By Trevor G
Re: Macro to add rows from wbk1 to end of wbk2

The code you have found is copying a sheet not a row, if you can supply a little more information then you get a better response.

Questions:



Which sheet is the data to be copied...
Forum: Reports 10-26-2015, 03:49 AM
Replies: 2
Views: 500
Posted By Trevor G
Re: Excel 2007 = Export Format

Hi Nicole what method are you using for your transfer? Do you have Office 2007 on your machine?
Forum: Forms 10-26-2015, 03:40 AM
Replies: 6
Views: 470
Posted By Trevor G
Re: Multiple Entries On A Same Person

I would suggest you have a One to Many relationship so when you add more to the employee record you can use the Many relationship then you can run queries, forms and reports from there for each...
Forum: Tables 10-26-2015, 03:13 AM
Replies: 3
Views: 473
Posted By Trevor G
Re: Memo field character truncate issue

Check out this thread

http://www.access-programmers.co.uk/forums/showthread.php?t=257440
Forum: Word 10-20-2015, 05:26 AM
Replies: 1
Views: 3,368
Posted By Trevor G
Re: Word product catalog from Access data

Either from Word you would use Mail Merge or from Access in Reports same thing.
Forum: Modules & VBA 10-20-2015, 01:37 AM
Replies: 2
Views: 1,561
Posted By Trevor G
Re: Print report based on the checkbox selection

Please don't cross post on other forums without complying with rules of the forum.

http://www.mrexcel.com/forum/microsoft-access/895242-print-report-based-checkbox-selection.html
Forum: Macros 10-20-2015, 01:34 AM
Replies: 5
Views: 672
Posted By Trevor G
Re: Is it possible to supply an argument for a macro?

Create a form and add a textbox name the textbox something like txtPath and then refer to the txtPath in your code and it will work.
Forum: Reports 10-13-2015, 08:07 AM
Replies: 20
Views: 2,380
Posted By Trevor G
Re: Export datasheet results with user defined sort order

Excellent news, well done indeed.

Thank you for the kind comments, and also thank you for the final reply and sharing the code I am sure others will be grateful.
Forum: Modules & VBA 10-06-2015, 05:19 AM
Replies: 1
Views: 237
Posted By Trevor G
Re: Format characters in an MS Word table

First you can always record a macro in Word to provide the code and then take that code into your VBA in Access. So having recorded a macro in Word to place bold onto some text it records as follows:...
Forum: Reports 10-06-2015, 05:01 AM
Replies: 20
Views: 2,380
Posted By Trevor G
Re: Export datasheet results with user defined sort order

What if you use the following at the beginning of the code;



This is the same as using Screen Updating in Excel.
Forum: Reports 10-03-2015, 03:21 AM
Replies: 20
Views: 2,380
Posted By Trevor G
Re: Export datasheet results with user defined sort order

Can you upload a sample of your database it will be easier to help you with a solution that will work for you. Strip away any sensitive data.
Forum: Modules & VBA 10-01-2015, 04:34 AM
Replies: 11
Views: 767
Posted By Trevor G
Re: Library to Export tables as XML

Then the only thing I can suggest is strip down a copy of your database (remove any sensitive data) and upload a copy into your thread.
Forum: Queries 10-01-2015, 04:32 AM
Replies: 3
Views: 549
Posted By Trevor G
Re: Number of letters in a field

You can't do this with Functions in Access, you would need VBA to do this.
Forum: Modules & VBA 10-01-2015, 04:27 AM
Replies: 11
Views: 767
Posted By Trevor G
Re: Library to Export tables as XML

I have no additional references checked, you shouldn't need to add any with this code. What happens if you remove the reference you checked.
Showing results 1 to 25 of 500

 
Forum Jump



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