Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.07 seconds.
Search: Posts Made By: Gasman
Forum: Modules & VBA Today, 11:43 AM
Replies: 9
Views: 108
Posted By Gasman
Re: VBA Help

Why not use/adapt arnelgp's function here

https://www.access-programmers.co.uk/forums/showthread.php?t=307389&highlight=calculate+age

You can even get the months and days :D
Forum: Modules & VBA Today, 03:34 AM
Replies: 9
Views: 119
Posted By Gasman
Re: URGENT: Access VBA Error

You have not changed anything.? :confused:
Forum: Modules & VBA Today, 02:37 AM
Replies: 9
Views: 119
Posted By Gasman
Re: URGENT: Access VBA Error

I'm afraid not.
Please post your code as you have it now.
Forum: Queries Today, 02:35 AM
Replies: 3
Views: 41
Posted By Gasman
Re: Query ifff statement with calculation?

You need True and False arguments I would have thought?

However try


IIf([daytext]="vrijdag" Or [daytext] = "Friday",([timediff]-48))
Forum: Modules & VBA Today, 01:52 AM
Replies: 9
Views: 119
Posted By Gasman
Re: URGENT: Access VBA Error

If your count is > 3 then it is too late I would have thought?, you already have more than you require?

I've fallen into this trap before, as the dlookup will not take into account your current...
Forum: Code Repository Yesterday, 11:16 PM
Replies: 5
Views: 83
Posted By Gasman
Re: View & Edit IMEX Data Task Specifications

Yes, entries are in there. I have a few specs I use in my SSAFA DB.
I used your code to populate your Usys table and reviewed the result which looks good.

I do not use specs that much, but no...
Forum: Code Repository Yesterday, 10:02 PM
Replies: 5
Views: 83
Posted By Gasman
Re: View & Edit IMEX Data Task Specifications

Hi Colin,
Not to worry, I found this site http://remove-line-numbers.ruurtjan.com/ which did the job admirably.

Yes, I have those tables and can recognise some linkages between them.
However...
Forum: Site Suggestions Yesterday, 01:59 PM
Replies: 23
Views: 530
Posted By Gasman
Re: Another strange site quirk?

Yes, I had that one today as well.
Forum: Site Suggestions Yesterday, 12:14 PM
Replies: 23
Views: 530
Posted By Gasman
Re: Another strange site quirk?

Yes, I just had it.
Forum: Code Repository Yesterday, 12:04 PM
Replies: 5
Views: 83
Posted By Gasman
Re: View & Edit IMEX Data Task Specifications

Colin,
How does one remove the line numbers please?
Forum: Reports Yesterday, 03:34 AM
Replies: 2
Views: 64
Posted By Gasman
Re: DSUM Function Criteria

Put your criteris into a string variable and then debug.print that to get it correct

strwhere = "[Date] >#08/01/2018# and [Date] <#08/31/2018# AND ID > " & tt
?...
Forum: Forms Yesterday, 02:09 AM
Replies: 56
Views: 990
Posted By Gasman
Re: Saving changes to records on Form

OK, I think I might have it working now, as my old version still had the link fields. :-(

It still needs a fair bit of work, but at least the package id is now being saved to the child table
Try...
Forum: Forms Yesterday, 01:41 AM
Replies: 56
Views: 990
Posted By Gasman
Re: Saving changes to records on Form

Well I found out that there is code for the Click event of the save button, you just lost the link, but I am having difficult finding bloc in All :(
Forum: Forms Yesterday, 01:14 AM
Replies: 56
Views: 990
Posted By Gasman
Re: Saving changes to records on Form

OK, but please give the sequence steps on how it is meant to work.?

Eg
Create new package, Save, then add new records in subform?
Forum: Tables Yesterday, 12:55 AM
Replies: 9
Views: 112
Posted By Gasman
Re: Locking problems altering a table ??

When you next go to the store, buy yourself a cane, as you are shooting yourself in the foot.;)
Forum: Tables Yesterday, 12:36 AM
Replies: 9
Views: 112
Posted By Gasman
Re: Locking problems altering a table ??

You do not go to multiple stores asking each store to order the item for you.?

That is pretty much what you are doing here, using your analogy.?
Forum: Forms Yesterday, 12:03 AM
Replies: 56
Views: 990
Posted By Gasman
Re: Saving changes to records on Form

Can you explain the steps in how it is meant to work?
There is no code behing the Save button.

Any reason why the controls are unbound in the main form.?
Forum: General 11-11-2019, 02:32 PM
Replies: 16
Views: 192
Posted By Gasman
Re: Import/Export Data Tasks

Would that be for 2010 onwards Colin?

There are some functions here (https://stackoverflow.com/questions/143420/how-can-i-modify-a-saved-microsoft-access-2007-or-2010-import-specification) that...
Forum: Modules & VBA 11-11-2019, 09:06 AM
Replies: 29
Views: 237
Posted By Gasman
Re: RgExp.Pattern

I thought that strange, as the site I worked out the pattern on produced two matches for the strings originally posted.
Forum: Modules & VBA 11-11-2019, 08:54 AM
Replies: 29
Views: 237
Posted By Gasman
Re: RgExp.Pattern

Both my last pattern and theDBguy's come back as true for both the sample strings?


Sub testRegex()
Dim rst As DAO.Recordset
Dim strSQL As String
Dim RgExp As Variant
Set RgExp =...
Forum: Modules & VBA 11-11-2019, 08:37 AM
Replies: 29
Views: 237
Posted By Gasman
Re: RgExp.Pattern

Do we even know if it is not working?

If the expression is found Field1data is set and nothing else.?

Or am I missing something obvious?
Forum: Modules & VBA 11-11-2019, 08:10 AM
Replies: 29
Views: 237
Posted By Gasman
Re: RgExp.Pattern

Well the expressions I posted worked on the test site I linked to?

Plus, what is TestDate doing?

Is your code even doing what you think it should be doing?


Dim rst As DAO.Recordset
Dim...
Forum: Visual Basic 11-11-2019, 05:36 AM
Replies: 2
Views: 64
Posted By Gasman
Re: Retrieve data from Excel cell-by-cell

Sounds like you will kow exactly which cells you need to refer to?

Have a look at this thread.

http://www.utteraccess.com/forum/lofiversion/index.php/t1983041.html
Forum: Queries 11-11-2019, 03:50 AM
Replies: 7
Views: 128
Posted By Gasman
Re: Combining two rows into one..

All I could think of would be a recordset approach and a loop as long as every record is in the same format.
Forum: Reports 11-10-2019, 03:29 PM
Replies: 4
Views: 92
Posted By Gasman
Re: report conditional formatting

Thought I'd found it as the forecolor in rptall is different from rpt3months, but even after copying the forecolor it does not vchange? :confused:
Showing results 1 to 25 of 500

 
Forum Jump



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