Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 27
Search took 0.03 seconds.
Search: Posts Made By: AlexHedley
Forum: Modules & VBA 01-18-2014, 08:43 AM
Replies: 11
Views: 710
Posted By AlexHedley
Re: transfer company name from one form to another form

CompanyID = Forms!CustomerF!CompanyID
Forum: Modules & VBA 01-17-2014, 11:56 PM
Replies: 2
Views: 487
Posted By AlexHedley
You could use some VBA with a SELECT CASE ...

You could use some VBA with a SELECT CASE

Check the tracking number and set which type you need then build the URL.
Forum: Forms 12-21-2013, 03:00 PM
Replies: 7
Views: 1,854
Posted By AlexHedley
There is a button that converts macros to vba in...

There is a button that converts macros to vba in the ribbon.
You could then add to that.
Forum: Tables 12-14-2013, 04:30 AM
Replies: 4
Views: 544
Posted By AlexHedley
Yeah I would create a central Table that has...

Yeah I would create a central Table that has common Fields that all use then create separate Tables with the extra Fields needed. You could create a 1-1 Relationship and only allow certain users to...
Forum: Modules & VBA 12-11-2013, 01:30 PM
Replies: 3
Views: 1,926
Posted By AlexHedley
http://accessblog.net/2011/10/how-to-link-foxpro-t...

http://accessblog.net/2011/10/how-to-link-foxpro-tables.html?m=1


Set tdf = dbs.CreateTableDef(strTableName,
_ dbAttachExclusive,
_ strFileName,
_ "ODBC;DSN=Visual FoxPro...
Forum: Reports 12-09-2013, 06:28 AM
Replies: 1
Views: 379
Posted By AlexHedley
Tip on opening a Report for a specific record...

Tip on opening a Report for a specific record using a Query.

http://www.599cd.com/tips/access/open-report-specific-data/
Forum: Queries 12-08-2013, 12:01 PM
Replies: 12
Views: 793
Posted By AlexHedley
So there will be a "-" separating them?

So there will be a "-" separating them?
Forum: Queries 12-07-2013, 02:41 PM
Replies: 12
Views: 793
Posted By AlexHedley
Will it have the "-" separating the Countryname...

Will it have the "-" separating the Countryname and Personsname or was that just to indicate the separation?

If it does you could use Find, Search, InStr or Split to get the two parts.
Forum: Queries 12-07-2013, 09:19 AM
Replies: 12
Views: 793
Posted By AlexHedley
Will the XXX always be of a certain length or...

Will the XXX always be of a certain length or could it change?

Would it be camel cased?
SSSPhilipinesXxxx
Forum: Forms 12-02-2013, 10:20 AM
Replies: 2
Views: 773
Posted By AlexHedley
You could add them in another row as an OR...

You could add them in another row as an OR criteria.
Forum: Forms 12-02-2013, 10:18 AM
Replies: 4
Views: 1,464
Posted By AlexHedley
The second link should do that. You just...

The second link should do that.

You just need to create a Query that selects the single record you want. Base the Report on that Query then Print.
Forum: Forms 12-01-2013, 02:43 AM
Replies: 4
Views: 1,464
Posted By AlexHedley
There is a Search box at the bottom of the Form...

There is a Search box at the bottom of the Form which you can use.
Or you could create your own.
http://www.599cd.com/tips/access/multi-field-search-form-like/?key=AlexForum


You could create a...
Forum: Modules & VBA 11-30-2013, 10:13 AM
Replies: 18
Views: 1,042
Posted By AlexHedley
Make a "simple" calculator work, please

Say you have an unbound textbox on your form, let's call it "txtCalc".

You could then add a button to your Form.
Rename it "cmdAddRemoveYear".

Now in the events tab click the ... Button next...
Forum: Queries 11-24-2013, 06:57 AM
Replies: 3
Views: 1,970
Posted By AlexHedley
For Query criteria ACROSS like you have it is an...

For Query criteria ACROSS like you have it is an AND so the date ranges have to match in ALL 3 Fields.

Try putting each Criteria in its own row, so DOWN, this will be an OR.

It will look...
Forum: Forms 11-12-2013, 02:02 PM
Replies: 9
Views: 5,850
Posted By AlexHedley
There should be Save As options Choose .accde

There should be Save As options
Choose .accde
Forum: Reports 11-03-2013, 11:15 AM
Replies: 9
Views: 2,044
Posted By AlexHedley
Re: Export and automatic rename a report

You could link the Query Parameter to the control on the Form.
Add a textbox to the Form called "txtSeq_number".

Then in the Query add the Criteria of:
FORMS!frmName!txtSeq_number

Now when...
Forum: Reports 11-03-2013, 08:11 AM
Replies: 9
Views: 2,044
Posted By AlexHedley
DoCmd.OpenReport "rptNAME" Run export cmd...

DoCmd.OpenReport "rptNAME"

Run export cmd below.

DoCmd.Close acReport, "rptNAME"

- -
expression.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)
Forum: Reports 11-03-2013, 04:02 AM
Replies: 10
Views: 905
Posted By AlexHedley
You may need to change the Filter: ...

You may need to change the Filter:

expression.OpenReport(ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs)

Tip:
http://www.599cd.com/tips/access/open-report-specific-data/
Forum: Reports 11-03-2013, 01:22 AM
Replies: 9
Views: 2,044
Posted By AlexHedley
Export and automatic rename a report

You can refer to a control on a Form and then use it on the Filename when you export

Dim strPathAndFile As String
strPathAndFile = "C:/.../filename_" & CONTROLNAME &".pdf"
...
Forum: Reports 11-02-2013, 12:09 PM
Replies: 9
Views: 2,044
Posted By AlexHedley
How are you exporting the report? Are you using...

How are you exporting the report?
Are you using VBA?
Are you using a Macro?
Are you using the a Ribbon button?
Forum: Windows 10-30-2013, 02:08 PM
Replies: 3
Views: 1,216
Posted By AlexHedley
Have you tried adding it to the startup folder in...

Have you tried adding it to the startup folder in All Programs?
Forum: Forms 10-29-2013, 11:45 AM
Replies: 2
Views: 527
Posted By AlexHedley
The "Amount" Field, what Data type is it? ...

The "Amount" Field, what Data type is it?
Number, Single, Double, ...?
Forum: Forms 10-28-2013, 09:31 AM
Replies: 5
Views: 884
Posted By AlexHedley
Have you tried adding the AVG as a calculated...

Have you tried adding the AVG as a calculated field in a Query with the other data you require.
If you update a Field that the AVG uses it will update.

Aggregate Queries...
Forum: Modules & VBA 05-25-2013, 11:58 PM
Replies: 7
Views: 816
Posted By AlexHedley
Private Sub btnCopyFile_Click() Dim...

Private Sub btnCopyFile_Click()

Dim myFilePath 'original file
Dim myFolder ' destination folder

myFolder = "C:\Folder_B\"

Set FSO = CreateObject("Scripting.FilesystemObject")

dim fileName
Forum: Queries 05-25-2013, 12:14 AM
Replies: 4
Views: 574
Posted By AlexHedley
You could either set your Form to have a Record...

You could either set your Form to have a Record Source based on a Table and then have a list of records with a button to open the specified Record


DoCmd.OpenForm "frmName", , , "ID=" &...
Showing results 1 to 25 of 27

 
Forum Jump



All times are GMT -8. The time now is 10:19 PM.


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

Sponsored Links

How to advertise

Media Kit


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