Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 164
Search took 0.04 seconds.
Search: Posts Made By: iankerry
Forum: Access Web 03-22-2019, 02:15 AM
Replies: 10
Views: 4,801
Posted By iankerry
Re: Life After Access

Thanks Both, that will give me something to look at and explore. Much appreciated.

Ian
Forum: Access Web 03-21-2019, 08:31 AM
Replies: 10
Views: 4,801
Posted By iankerry
Re: Life After Access

Yes that is what I need.

Sorry if i wasn't clear Plog and if it was too garbled.

Ian
Forum: Access Web 03-21-2019, 07:33 AM
Replies: 10
Views: 4,801
Posted By iankerry
Life After Access

Hi all,

Hope this is the right place to put this.

For 20 years I have developed a pretty good database system for looking after pretty much every aspect of the 1200 events we put on as a...
Forum: Tables 07-31-2018, 05:11 AM
Replies: 11
Views: 531
Posted By iankerry
Re: list of records that DON'T appear in another table

when i use this code - and add a date filter so i only look at future dates - it brings back zero results.


SELECT dbo_Venues.ID, dbo_Venues.VENUE, dbo_EventsFlicks.datefield
FROM dbo_Venues...
Forum: Tables 07-31-2018, 04:17 AM
Replies: 11
Views: 531
Posted By iankerry
Re: list of records that DON'T appear in another table

Hi jdraw,

this tutorial seems to be excluding records that one has typed into a table. rather than looking a two tables and providing a list of venues form one table that dont appear in the other....
Forum: Tables 07-31-2018, 04:02 AM
Replies: 11
Views: 531
Posted By iankerry
Re: list of records that DON'T appear in another table

Thanks folks, a few pointers there - will have a go now and see what i can do... i have tried the unmatched query wizard, but it didnt provide the expected results!

Am realising the query is...
Forum: Tables 07-30-2018, 07:11 AM
Replies: 11
Views: 531
Posted By iankerry
list of records that DON'T appear in another table

Hi Guys

I have been trying to work this out using posts from previous queries, but i cant seem to fathom it out.

i have a table called Venues and a table called EventsFlicks.

they are...
Forum: Modules & VBA 06-06-2018, 03:49 AM
Replies: 11
Views: 299
Posted By iankerry
Re: why does my code miss out a record?

Thanks both for replying.

Strange how these things work... you comment on getdate() made me think -

given the command does work, then it must be talking directly to the sql server.

sure...
Forum: Modules & VBA 06-06-2018, 03:18 AM
Replies: 11
Views: 299
Posted By iankerry
Re: why does my code miss out a record?

Hi Thanks for replying.

i took out the getdate WHERE clause, in case. It created an email with hundreds of dates in for that venue but that one record was still missing. the code skips over that...
Forum: Modules & VBA 06-06-2018, 02:23 AM
Replies: 11
Views: 299
Posted By iankerry
why does my code miss out a record?

Hi All, have been scratching more than my head about this one for sometime. hope i can explain it properly.

i have a database with 1000 records on it. on a form i will have a filter on which shows...
Forum: Queries 07-12-2017, 07:04 AM
Replies: 3
Views: 350
Posted By iankerry
Forum: Queries 07-12-2017, 06:38 AM
Replies: 3
Views: 350
Posted By iankerry
returning a list where they dont have a record!

Hi,

hope you can help.

I have two tables: Venues and Events.

The Events table has a field called VenueID which tells me which venue the events will be at.

What I would like is a list of...
Forum: Modules & VBA 07-25-2016, 06:30 AM
Replies: 7
Views: 312
Posted By iankerry
Re: format a currency field within arrSummaryData

Thanks all, have found solution.

the field curAdultTP is defined elsewhere and has not been defined correctly.
Forum: Modules & VBA 07-25-2016, 06:19 AM
Replies: 7
Views: 312
Posted By iankerry
Re: format a currency field within arrSummaryData

Thanks Bob, have just been googling, but I can't see how i can use it within the line:

arrSummaryData(intRecordCount).curAdultTP = IIf(IsNull(![adulttp]), "", ![adulttp])

I have just noticed...
Forum: Modules & VBA 07-25-2016, 03:30 AM
Replies: 7
Views: 312
Posted By iankerry
Re: format a currency field within arrSummaryData

Thanks for replying.


No, I have a button on a form, that runs a whole routine, which eventually brings up an email with all the data in it that i need to send to someone.

It is in that email...
Forum: Modules & VBA 07-25-2016, 03:28 AM
Replies: 7
Views: 312
Posted By iankerry
Re: format a currency field within arrSummaryData

hmmm - this code goes and gets the data from an SQL server. It then puts all the information I need into an email, ready to send to someone.

It is in this email that the [adulttp] doesn't show 2...
Forum: Modules & VBA 07-25-2016, 01:53 AM
Replies: 7
Views: 312
Posted By iankerry
format a currency field within arrSummaryData

Hi Folks

I have the following code:


f OpenConnection Then
If rs.State = adStateOpen Then rs.Close
rs.Open SQL, cn, adOpenKeyset, adLockOptimistic

If Not rs.EOF...
Forum: Forms 03-04-2016, 07:42 AM
Replies: 19
Views: 803
Posted By iankerry
Re: Validation - No Spaces

Well, good point jdraw. The simplest answer is that i think this might be beyond my skills to write such a routine.

I would have to get access to rename the jpg image, before it puts the images...
Forum: Forms 03-04-2016, 07:28 AM
Replies: 19
Views: 803
Posted By iankerry
Re: Validation - No Spaces

Correct so far!



The program is the access database. Say I am on a record for the film "Crimson Peak", and i want to assign an image name for that film. I click on the button that produces a...
Forum: Forms 03-04-2016, 07:07 AM
Replies: 19
Views: 803
Posted By iankerry
Re: Validation - No Spaces

Hi

I may not have been clear enough in a posts below - but i have, thanks to you guys, a solution that works well for me.

A message pops up if someone tries to enter a filename with a space in...
Forum: Forms 03-04-2016, 06:51 AM
Replies: 19
Views: 803
Posted By iankerry
Re: Validation - No Spaces

Well our database drives our website www.artsalive.co.uk and also our weekly email alert, and there is often strange behaviour with images if there is a space in the filename.

Ian.
Forum: Forms 03-04-2016, 06:19 AM
Replies: 19
Views: 803
Posted By iankerry
Re: Validation - No Spaces

Yeah, training has happened, staff were informed but you know what it is like - there is even some text below the field in RED saying "no spaces in this field please".

They do have the ability now...
Forum: Forms 03-04-2016, 06:07 AM
Replies: 19
Views: 803
Posted By iankerry
Re: Validation - No Spaces

Thanks fo your suggestion - as you might have gathered by now, the user chooses the filename, rather than typing it in, but i will bear this suggestion in mind for another field where they do type in...
Forum: Forms 03-04-2016, 06:01 AM
Replies: 19
Views: 803
Posted By iankerry
Re: Validation - No Spaces

Another staff member collects images that we can use for publicity purposes, and save them in a folder called images - this is all outside access environment. They often forget not to use spaces in...
Forum: Forms 03-04-2016, 05:14 AM
Replies: 19
Views: 803
Posted By iankerry
Re: Validation - No Spaces

The user does click on a button which brings up all the jpg's and they choose one, and the name goes into the field. Problem has been that when the jpg is saved it is often saved with a space in the...
Showing results 1 to 25 of 164

 
Forum Jump



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