Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.42 seconds.
Search: Posts Made By: Gasman
Forum: Reports Today, 06:49 AM
Replies: 8
Views: 54
Posted By Gasman
Re: Textbox position

So it never really moved at all? :D

Took me 20 mins to work it out though. :banghead:
Perhaps something I can use in the future, which is why I played around with it.
Forum: Reports Today, 06:10 AM
Replies: 8
Views: 54
Posted By Gasman
Re: Textbox position

You need to specify location in in twips ?
That worked for me



Private Sub Command16_Click()
'Error handling
On Error GoTo Error_Handler

Dim strFormName As String, strReport As String
Forum: Reports Today, 05:13 AM
Replies: 8
Views: 54
Posted By Gasman
Re: Textbox position

Would you not need a Refresh ?


Edit: Ignore please, not available in a report. :o
Forum: Modules & VBA Yesterday, 07:54 AM
Replies: 5
Views: 69
Posted By Gasman
Re: Getting "Invalid use of property" trying to compute a date

Firstly if it is an integer then you do not use quotes.?
Secondly you have to assign something, so it would be along the lines of

DateLastSunday = Date -DayOfWeek +1


No need for all the...
Forum: Forms Yesterday, 07:47 AM
Replies: 13
Views: 195
Posted By Gasman
Re: Run Report From Subform

I believe you need something along the lines of


Forms![frmHome]
at the start.?

You need the control name that holds the subform. Sometimes that is the same as the subform name, but not...
Forum: Forms Yesterday, 07:29 AM
Replies: 13
Views: 195
Posted By Gasman
Re: Run Report From Subform

Sorry, I only have 2007, and am unable to open frmHome
However I did manage to open frmReport and the query and then used the builder to build the criteria as
...
Forum: Forms Yesterday, 05:52 AM
Replies: 13
Views: 195
Posted By Gasman
Re: Run Report From Subform

It cannot find that control, that is why.
Is the form open at that time?, are the names the same between parameter and control name?
Forum: General 08-17-2018, 12:42 PM
Replies: 14
Views: 303
Posted By Gasman
Re: Share Name v/s Mapped drive

I have just split a database of mine and split to the L: drive.?
Tables now show L:\ when you hover.
I seem to recall that when you relink I have always taken care to use the UNC path and NOT the...
Forum: General 08-17-2018, 11:40 AM
Replies: 14
Views: 303
Posted By Gasman
Re: Share Name v/s Mapped drive

The share name could well change if they install a new drive, but it is up to them to keep the share name the same, just as they would keep the mapped drive letter the same.

If you think about it,...
Forum: Excel 08-17-2018, 03:48 AM
Replies: 24
Views: 531
Posted By Gasman
Re: Mathematically predict date of holidays, such as Easter

Sorry, I had my Access hat on and a blonde moment.:banghead:
Forum: Excel 08-17-2018, 03:46 AM
Replies: 24
Views: 531
Posted By Gasman
Re: Mathematically predict date of holidays, such as Easter

That crossed my mind, but somewhere where it could be accessed easily by whoever inherited it.
The problem I would have thought is getting all the pages etc. It appears to have been created in...
Forum: Modules & VBA 08-17-2018, 03:43 AM
Replies: 12
Views: 204
Posted By Gasman
Re: Immediate, Locals and Watch windows no longer visible

I'd be rolling back that office update and see if all is fixed. If so advise MS. That is what Ridders did for a problem he experienced.

Good luck anyway.
Forum: Excel 08-17-2018, 03:31 AM
Replies: 24
Views: 531
Posted By Gasman
Re: Mathematically predict date of holidays, such as Easter

DateSerial ?

https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/dateserial-function


TBH I just look up the holidays and add them to my table periodically. Job...
Forum: Modules & VBA 08-17-2018, 01:23 AM
Replies: 12
Views: 204
Posted By Gasman
Re: Immediate, Locals and Watch windows no longer visible

FWIW I have had the KB4343909 installed on the 15th and my IDE is still working, but then I am on 2007.
Forum: Tables 08-17-2018, 01:18 AM
Replies: 6
Views: 230
Posted By Gasman
Re: Ms Access Relationship

Speaking from experience, I'd also alter any 'ID' fields to a better more meaningful name, as you have done with the other tables..
If you combine tables in a query with same named fields, Access...
Forum: Excel 08-17-2018, 12:23 AM
Replies: 24
Views: 531
Posted By Gasman
Re: Mathematically predict date of holidays, such as Easter

Sadly, I cannot see that happening. Eventually the site will come up for renewal.
That is 2019-06-22.
Forum: Excel 08-16-2018, 11:25 PM
Replies: 24
Views: 531
Posted By Gasman
Re: Mathematically predict date of holidays, such as Easter

Well I broke it down into it's component parts (thank God for BODMAS :D) to see why it was giving the incorrect date, then spotted the 5 at the start of the formula.
But still have no idea as to why...
Forum: Queries 08-16-2018, 05:49 AM
Replies: 3
Views: 71
Posted By Gasman
Re: Record locking and update queries.

Most batch processes are run at night, when no users are on a system?

I think to get the report you are after, you would have to run the query on each record in the batch payments table, one at a...
Forum: Excel 08-16-2018, 05:08 AM
Replies: 24
Views: 531
Posted By Gasman
Re: Mathematically predict date of holidays, such as Easter

Not found out what you have done incorrectly yet, if anything, but if you enter 2018 in the field at the bottom of that page, his site returns 01/04/2018 ?
and if you look at the source, that is the...
Forum: Forms 08-16-2018, 01:43 AM
Replies: 13
Views: 156
Posted By Gasman
Re: SQL for List box search form

What does


debug.print SQL
show?
Forum: Forms 08-15-2018, 06:19 AM
Replies: 13
Views: 195
Posted By Gasman
Re: Run Report From Subform

Obviously the control name is different?
On issues like these I tend to populate a TempVar and use that/them as the criteria for the query.
That was before I found out about parametised querydefs.?...
Forum: General 08-15-2018, 05:32 AM
Replies: 13
Views: 1,227
Posted By Gasman
Re: Send outlook reminders to multiple recipients

This works for me, albeit it goes in the users draft folder for one user but as a task and another as an email not task, unless I set a rule to move to another folder.
Either way it is sent.

...
Forum: Modules & VBA 08-15-2018, 05:09 AM
Replies: 4
Views: 119
Posted By Gasman
Re: add file name to a table after import

Assuming you want a date it was imported as well?


sSQL="INSERT INTO tblexcelfilename ( ImportDate, Fname )"
sSQL = sSQL & " SELECT Date() AS ImportDate, '" & SelectedFile & "' AS FName"...
Forum: Forms 08-14-2018, 06:52 AM
Replies: 7
Views: 154
Posted By Gasman
Re: Need help fixing xlsx copying from on sheet to another one when a form's control

Your code has the cell being copied in the opposite direction?, E14 to M59 ?

Is it actually being copied, but E14 is empty?
What happens if you wlak through the code with the debug window and...
Forum: Reports 08-13-2018, 10:29 AM
Replies: 8
Views: 179
Posted By Gasman
Re: Travel Itinerary Report

Don't bother with the last query as you can do all that in the report.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 09:39 AM.


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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World