Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.10 seconds.
Search: Posts Made By: Gasman
Forum: Modules & VBA Today, 07:13 AM
Replies: 2
Views: 69
Posted By Gasman
Re: RegEx & Code128 barcodes & GS1

I would construct a Regex expression string for each supplier, and store in a table with their other details.
Then lookup the regex expression for the required supplier and apply that.?

HTH
Forum: Forms Yesterday, 01:45 PM
Replies: 4
Views: 88
Posted By Gasman
Re: Duplicating records in a form-based on check boxes

You should not be duplicating the data for the invoice?
I would have thought you would have


Customer
Invoice
Invoice Details (Line Items)


So each Line Item would have...
Forum: Site Suggestions Yesterday, 08:47 AM
Replies: 55
Views: 537
Posted By Gasman
Re: session timeout

I *think* it is one process for each addin as well as one for each tab.?
I only have one tab open, but 4 processes, as I have 3 addins running.?
Forum: Modules & VBA Yesterday, 08:40 AM
Replies: 47
Views: 765
Posted By Gasman
Re: can't figure where I'm going wrong

Not really, just been there, done that. :D
Forum: Modules & VBA Yesterday, 08:24 AM
Replies: 47
Views: 765
Posted By Gasman
Re: can't figure where I'm going wrong

Well times could cause an issue, but it did look like the dates were backwards from what was expected from what you had said.

Congrats on getting to the bottom of it. :D

The conts is handy...
Forum: Modules & VBA Yesterday, 07:10 AM
Replies: 47
Views: 765
Posted By Gasman
Re: can't figure where I'm going wrong

Can you post a cut down generic version of your DB.?

We are going around in circles here.

As you say, it is a date issue. It is just being able to get to the bottom of it.?
Forum: Modules & VBA Yesterday, 05:28 AM
Replies: 47
Views: 765
Posted By Gasman
Re: can't figure where I'm going wrong

So why not format as mm/dd/yyyy as a test at least? :confused:

In one of my DBs I have


Public Const strcJetDate = "\#mm\/dd\/yyyy\#" 'Needed for dates in queries as Access expects USA...
Forum: General Yesterday, 03:03 AM
Replies: 26
Views: 448
Posted By Gasman
Re: The Surface Go 10" and Access Office 365

Mike,

Could you post a link for this super USB hub please.?

TIA
Forum: Modules & VBA 11-20-2019, 08:12 AM
Replies: 8
Views: 199
Posted By Gasman
Re: ADODB Recordset Closed, why?

So you never had a connection really?
Forum: General 11-20-2019, 08:09 AM
Replies: 2
Views: 75
Posted By Gasman
Re: Please help me...

A quick Google

https://www.citizensadvice.org.uk/debt-and-money/debt-solutions/individual-voluntary-arrangements/managing-your-iva/failure-of-an-individual-voluntary-arrangement/
Forum: Modules & VBA 11-20-2019, 06:03 AM
Replies: 4
Views: 86
Posted By Gasman
Re: Conditionally Control Report Fields Visible Property

I would have thought you would want the code in one of the detail events? On Print perhaps?
Forum: Modules & VBA 11-20-2019, 04:36 AM
Replies: 8
Views: 199
Posted By Gasman
Re: ADODB Recordset Closed, why?

Just guessing here, but do you get a connection?
What does MyUserCode and MyPassword hold? Are they global?

What hapens if you walk through the code with F8?
Forum: Modules & VBA 11-20-2019, 01:49 AM
Replies: 24
Views: 430
Posted By Gasman
Re: Dealing with Null value on SQL Statement

June7,
I've already queried that and got no response.?:(
Forum: Queries 11-20-2019, 01:45 AM
Replies: 9
Views: 174
Posted By Gasman
Re: Delete query is working very slow

Instead of deleting, could you just mark them as deleted/not active with a flag?
Then perhaps delete periodically if necessary?
Forum: Queries 11-19-2019, 10:45 AM
Replies: 6
Views: 108
Posted By Gasman
Re: IIf Error Expression in Query

Would this logic satisfy your requirements?

https://www.techonthenet.com/access/queries/divide_by_zero.php
Forum: Queries 11-19-2019, 09:34 AM
Replies: 6
Views: 108
Posted By Gasman
Re: IIf Error Expression in Query

In English, what are you trying to identify that would produce a zero value?
Forum: Queries 11-19-2019, 09:14 AM
Replies: 6
Views: 140
Posted By Gasman
Re: Combining data from different records

ALso look at the Similar thread at the bottom of the page. I am sure someone asked this very question just the other day?
Forum: Queries 11-19-2019, 09:07 AM
Replies: 6
Views: 108
Posted By Gasman
Re: IIf Error Expression in Query

I *think* you are way off base.? Do you use Excel mostly?

This user tried much the same thing.?

https://stackoverflow.com/questions/22670418/iif-iserror-function-still-returning-error
Forum: Forms 11-19-2019, 08:59 AM
Replies: 8
Views: 133
Posted By Gasman
Re: Countdown Timer

I *think* the o/p wants to display to the user that they have x minutes and y seconds before the DB will shutdown, as opposed to z seconds ?
Forum: Modules & VBA 11-19-2019, 08:23 AM
Replies: 6
Views: 96
Posted By Gasman
Re: Wits end trying to get VBA code to work

Well the dirname will probably need to be

"B:\" to start with?

Site removes backslash when not in code tags :(

I'm not sure you can create sub folders if the parent is not created.?

You...
Forum: Queries 11-19-2019, 08:18 AM
Replies: 15
Views: 156
Posted By Gasman
Re: Help required

I cannot view some of it due my old version. Sorry
However even my version does not appear to have those tables.?
Forum: Modules & VBA 11-19-2019, 08:10 AM
Replies: 6
Views: 96
Posted By Gasman
Re: Wits end trying to get VBA code to work

First question would be, what is it not doing?
Why not walk through the code with F8 ?


Sub Nothing1()


Dim Holon1 As String
Dim Location As String
Dim DirName As String
Forum: Modules & VBA 11-19-2019, 07:36 AM
Replies: 8
Views: 126
Posted By Gasman
Re: error in code

My understanding is that if you use unbound controls, you update/append with a query.?
If bound controls, then you save as a matter of course and can force a save.

I tend to use bound controls,...
Forum: Modules & VBA 11-19-2019, 07:05 AM
Replies: 8
Views: 126
Posted By Gasman
Re: error in code

Are you wanting to do this bound or unbound as you have both?

Might be better to give us what you are using, rather than the dummy form that appears to be a bound and unbound form for the same...
Forum: Modules & VBA 11-19-2019, 06:50 AM
Replies: 8
Views: 126
Posted By Gasman
Re: error in code

For the benefit of others, this is the code

Private Sub Command103_Click()
If IsNull(Me.txtFrist) Then
MsgBox "Please Write FirstName", vbInformation, "Warning"
FirstName =...
Showing results 1 to 25 of 500

 
Forum Jump



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