Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: Gasman
Forum: Reports Today, 03:34 AM
Replies: 1
Views: 16
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 Today, 02:09 AM
Replies: 55
Views: 942
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 Today, 01:41 AM
Replies: 55
Views: 942
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 Today, 01:14 AM
Replies: 55
Views: 942
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 Today, 12:55 AM
Replies: 9
Views: 94
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 Today, 12:36 AM
Replies: 9
Views: 94
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 Today, 12:03 AM
Replies: 55
Views: 942
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 Yesterday, 02:32 PM
Replies: 13
Views: 133
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 Yesterday, 09:06 AM
Replies: 29
Views: 234
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 Yesterday, 08:54 AM
Replies: 29
Views: 234
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 Yesterday, 08:37 AM
Replies: 29
Views: 234
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 Yesterday, 08:10 AM
Replies: 29
Views: 234
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 Yesterday, 05:36 AM
Replies: 2
Views: 58
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 Yesterday, 03:50 AM
Replies: 7
Views: 110
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: 87
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:
Forum: Reports 11-10-2019, 03:02 PM
Replies: 4
Views: 87
Posted By Gasman
Re: report conditional formatting

A quick look does not show anything standing out.?

However I would probably have one report and open with different criteria.?

So use rpt all and filter?
Else copy report all and amend for...
Forum: General 11-10-2019, 09:22 AM
Replies: 12
Views: 129
Posted By Gasman
Re: VBA Text

Only applies to Memo types I believe?
Forum: Modules & VBA 11-10-2019, 09:11 AM
Replies: 5
Views: 124
Posted By Gasman
Re: Unable to edit tables after running a macro/VBA code

Aren't you running this code from the report?

You are using Me.Name ? :confused:
Forum: Forms 11-10-2019, 07:09 AM
Replies: 4
Views: 69
Posted By Gasman
Re: Special background color for NOT activated textbox ??

Have you tried jut locking it instead?
Forum: Forms 11-10-2019, 06:32 AM
Replies: 15
Views: 151
Posted By Gasman
Re: OpenArgs not evaluated in Current event

I do not think that is a limitation as you are not opening the form again?

A TempVar would probably do the job.?
Forum: Forms 11-10-2019, 05:52 AM
Replies: 15
Views: 151
Posted By Gasman
Re: OpenArgs not evaluated in Current event

If the form is already open, doesn't it just go to the form when you try a second open statement.?

You could use a Tempvar instead.?

If you want the form open multiple times, you need to setup...
Forum: Forms 11-10-2019, 04:11 AM
Replies: 15
Views: 151
Posted By Gasman
Re: OpenArgs not evaluated in Current event

I've just tested it and it is available in the On Current event?
Forum: Forms 11-10-2019, 04:00 AM
Replies: 15
Views: 151
Posted By Gasman
Re: OpenArgs not evaluated in Current event

Wouldn't a requery do that.?

Store the OpenArgs to a form global variable on load if it is not available in any other event.?
Forum: Site Suggestions 11-09-2019, 01:28 PM
Replies: 19
Views: 190
Posted By Gasman
Re: session timeout

I would have thought that if you were 'attached' to another hotspot, that ip address would change.?

I only logon from PCs, two devices in the house and one in office, so never have the problem...
Forum: Site Suggestions 11-09-2019, 11:18 AM
Replies: 19
Views: 190
Posted By Gasman
Re: session timeout

I use chrome and have New posts in my bookmarks bar and just click to get them each time.?
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 05:50 AM.


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