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: Reports Today, 05:54 AM
Replies: 20
Views: 124
Posted By Gasman
Re: Custom shortcut menu

Arne,
I dare say a person like yourself, could write some code that would add that menu to all reports in a database?, rather than having to edit them one by one.

Thank you for that tip, it could...
Forum: Forms Today, 03:20 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Ok,
I've amended the code as below, and it seems to work a lot better. No error message when adding a record and can close the form OK if no data has been entered.
Delete code seems to work as...
Forum: Forms Today, 02:17 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Hi Moke,

There I am attempting to see if a client was processed previously in the Excel sheet we were using. Just trying to cover the changeover period?

If there are two Smiths, we would need...
Forum: Forms Today, 02:12 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Oops, sorry my mistake.:banghead:


There I am attempting to see if a client was processed previously in the Excel sheet we were using. Just trying to cover the changeover period?

The rest is...
Forum: Forms Yesterday, 12:07 PM
Replies: 35
Views: 227
Posted By Gasman
Re: Delete Files Based On a Text Field

OK, think about what you are trying to get and what you have.?

You have coded for a space after the last backslash.?
Do you ever see that in real life?

Then as it is a string it just needs to...
Forum: Forms Yesterday, 09:00 AM
Replies: 28
Views: 384
Posted By Gasman
Forum: Forms Yesterday, 08:59 AM
Replies: 35
Views: 227
Posted By Gasman
Re: Delete Files Based On a Text Field

Click the # icon and post between the tags, then look to see what is generated.
Forum: Forms Yesterday, 08:53 AM
Replies: 35
Views: 227
Posted By Gasman
Re: Delete Files Based On a Text Field

As has been amply demonstrated, the site removes the last backslash if in quotes and not in code tags.

If you post within code tags and copy and paste the code we can see exactly what you have.
...
Forum: Forms Yesterday, 06:55 AM
Replies: 35
Views: 227
Posted By Gasman
Re: Delete Files Based On a Text Field

C:\Folder1\Folder2\

"C:\Folder1\Folder2"

Doesn't appear to work when you use quotes and outside of a code window?
Forum: Forms Yesterday, 06:51 AM
Replies: 35
Views: 227
Posted By Gasman
Re: Delete Files Based On a Text Field

MyVar = "C:\Folder1\Folder2\" & CustomerID
Forum: Forms Yesterday, 02:02 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Morning all,

I've moved the setting of the FK to the On Enter even as recommended, but left everything else as is, so I can make the changes all in one go.

TIA

Option Compare Database...
Forum: Queries 11-19-2017, 07:55 AM
Replies: 13
Views: 126
Posted By Gasman
Re: unmatched query without PK

Perhaps so, but they appear to be repeated for different fabrications/colours?
Forum: Queries 11-19-2017, 05:31 AM
Replies: 13
Views: 126
Posted By Gasman
Re: unmatched query without PK

I don't think you have to match on keys, but you have to match on something, otherwise how can you find unmatched.?

Even if you concatenate fields to get something to match. From your pics I...
Forum: Forms 11-19-2017, 03:50 AM
Replies: 3
Views: 101
Posted By Gasman
Re: Calculate Date

Have a look at the DateAdd function

https://support.office.com/en-gb/article/DateAdd-Function-63befdf6-1ffa-4357-9424-61e8c57afc19
Forum: Forms 11-19-2017, 03:44 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Thank you Pat,
I believe I have that code in the OnCurrent event at present. I will move it to that other event.

I'll post all of the form code on Monday, as it is now, then correct everything...
Forum: Queries 11-18-2017, 12:21 PM
Replies: 20
Views: 164
Posted By Gasman
Re: Query with some sort of sum?

Urgh! I can't stand whiskey, well at least Scotch. I can and have drunk Bourbon, but very seldom these days. My mother loved Scotch, but then she was Scottish :)

Beer is my tipple, real ale with a...
Forum: Queries 11-18-2017, 11:18 AM
Replies: 20
Views: 164
Posted By Gasman
Re: Query with some sort of sum?

I can help you out there :)
Forum: Forms 11-18-2017, 11:04 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

I only have some code to set the FK for the record, as the form is opened from another form and I pass in the ID of the parent.

Something along the lines of

If me.newrecord then
...
Forum: Forms 11-18-2017, 09:12 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Hi Pat,

I want to validate the data, whether a new record or not. What I was trying to say, was that my code did not even give me the chance to enter data when adding a new record, before it was...
Forum: Forms 11-18-2017, 09:04 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Moke,

I have not had a chance to implement your code, as the DB is in work.

Yes my code currently shows each message twice before I can get to put any data in a control after I click the New...
Forum: Forms 11-18-2017, 03:35 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Hi Colin,

Yes, I only want to see each message once.

It's in work, so cannot try until Monday.
I would also want both messages to be displayed, but I can do that easily enough using Mokes'...
Forum: Forms 11-18-2017, 02:38 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Moke,
Just to clarify both messages get displayed twice.?
The event is being called twice for some reason?
Forum: Forms 11-17-2017, 09:42 AM
Replies: 28
Views: 384
Posted By Gasman
Re: Form validation and new record?

Ah I see now.:o
Thank you Moke, I'll give that a go on Monday.
Forum: Modules & VBA 11-17-2017, 06:47 AM
Replies: 33
[SOLVED] Help with Msgbox
Views: 372
Posted By Gasman
Re: Help with Msgbox

I would still question why the user is being offered a delete button when there is nothing to delete?
Would also solve your problem as well.;)
Forum: General 11-17-2017, 03:51 AM
Replies: 11
Views: 303
Posted By Gasman
Re: Upgrade advice for a retired DB programmer

Colin,
I am happily using 2007 with win 10 home. I was on 2003 :-)

I have had a few problems with some apps developed in a newer version, but nothing I could not live without.

Even if you...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:34 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 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World