Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 87
Search took 0.01 seconds.
Search: Posts Made By: damian
Forum: Queries 11-26-2013, 11:30 PM
Replies: 7
Views: 716
Posted By damian
Re: Training Records

Many thanks to all 3 of you and apologies for not getting back sooner - work is taking over my life.

Have yet to sort queries but it's a lot clearer now that the foundations are in place. I...
Forum: Queries 11-20-2013, 02:48 PM
Replies: 7
Views: 716
Posted By damian
Re: Training Records

Thanks for both your responses. I had already set up the attached tables /relationships (should have posted originally) and I think that it captures what you guys have advocated.

I had also set...
Forum: Queries 11-19-2013, 04:03 PM
Replies: 7
Views: 716
Posted By damian
Training Records

Iím attempting to set up a database to record employee training. Iíve set up the autolookup query (pic attached) to help form a set of default training courses/procedures that are mandatory for each...
Forum: Queries 11-11-2013, 01:29 PM
Replies: 1
Views: 1,104
Posted By damian
Re: Automate Outlook Task - Access query

Probably too late for you now - I use some freeware called FreeByte as an alternative to Windows Scheduler. May be permissible by your network administrators (ours frowned upon Win Sched but...
Forum: Forms 06-11-2013, 01:24 PM
Replies: 1
Views: 425
Posted By damian
Re: Tab Control

Are you familair with VBA - you could use on your command button to check that all controls are completed and call following function:

Private Function CheckForCompletion() As Boolean
'will check...
Forum: Modules & VBA 08-06-2012, 10:53 AM
Replies: 4
Views: 1,125
Posted By damian
Re: OpenRecordset Loop

Cheers, got confused with all the quotation mark business so decided to simply reference a query that filtered out the information instead.
Forum: Modules & VBA 08-01-2012, 06:01 AM
Replies: 4
Views: 1,125
Posted By damian
Re: OpenRecordset Loop

When I attempt to include following 'Where' clause, results in syntax error 3075:

Set rst = dbc.OpenRecordset("select * from TBL_SurveyDetail where (((TBL_SurveyDetail.txtimagename)<>"")) ORDER BY...
Forum: Modules & VBA 08-01-2012, 05:19 AM
Replies: 4
Views: 1,125
Posted By damian
OpenRecordset Loop

Hi

Attempting to adapt some VBA in order to sequentially number a field (named Code) based upon whether another field (txtimagename) is either blank or Is Null.

Code I have to date for a button...
Forum: Queries 08-01-2012, 04:56 AM
Replies: 5
Views: 1,352
Posted By damian
Re: Dcount Counter

Will go down the VBA route instead. Thanks for your help John
Forum: Queries 07-31-2012, 03:07 PM
Replies: 5
Views: 1,352
Posted By damian
Re: Dcount Counter

Think I've over simplified my initial query in the first post.

Due to the user having the ability to input records anywhere within a subform and in any order, I'm unable to sort on the autonumber...
Forum: Queries 07-30-2012, 12:18 AM
Replies: 5
Views: 1,352
Posted By damian
Re: Dcount Counter

Thanks John.

In the event that a record doesn't contain an image, the ranking result gives a 1. If there are no images, I'd like this value to be blank and for the next record with an image to...
Forum: Queries 07-29-2012, 03:15 PM
Replies: 5
Views: 1,352
Posted By damian
Dcount Counter

Hi
Is it possible to include a Dcount function in a query (qrySurveyDetail) to sequentially number records where a text field (ImageName) is not null?

RecordID
67
68
57
71

ImageName
Forum: Reports 07-24-2012, 12:40 PM
Replies: 8
Views: 1,488
Posted By damian
Re: SubReport Problem

Solved it by basing my subreport on a query that showed records where the text field containing the location of the image was not equal to null.
Forum: Reports 07-13-2012, 01:48 PM
Replies: 8
Views: 1,488
Posted By damian
Re: SubReport Problem

Apologies for delay in responding.

On a form, I've used an image frame linked to a text field containing the location of the image (.bmp) on my PC. I set the text field using VBA behind button...
Forum: Reports 07-06-2012, 04:40 PM
Replies: 8
Views: 1,488
Posted By damian
Re: SubReport Problem

Thought I had everything sussed and now I've realised that the page break business may be causing havoc with my page numbers (eg Page 11 of 9). Only established this by searching this forum and...
Forum: Reports 07-06-2012, 04:17 PM
Replies: 8
Views: 1,488
Posted By damian
Re: SubReport Problem

Thanks for taking time to get back to me - have opted to populate the main (parent) report fields using the form values. This means that the images can remain linked to what was SubReport1...
Forum: Reports 07-05-2012, 12:53 PM
Replies: 8
Views: 1,488
Posted By damian
Re: SubReport Problem

Attempted to look at the DIR() function as a way to overcome issue but couldn't fathom out how this can put the images on a separate page straight after a sub section of a subreport.

I can get the...
Forum: Reports 07-04-2012, 02:05 AM
Replies: 8
Views: 1,488
Posted By damian
SubReport Problem

Hi, I've been working on a report for several weeks and have yet to come up with a solution for the following setup.

On the main (parent) report I have Contact Name and address fields with a...
Forum: Modules & VBA 06-18-2012, 02:13 PM
Replies: 7
Views: 1,661
Posted By damian
Re: MainForm to Subform Focus

Looks like I'll have to accept defeat on both this one and the football..... Thanks Michael
Forum: Modules & VBA 06-18-2012, 12:20 PM
Replies: 7
Views: 1,661
Posted By damian
Re: MainForm to Subform Focus

Apologies Pat - little engrossed in the Ireland v Italy soccer match and didn't see your response.

It is the user that is changing the record not code. However as they can click on the subform,...
Forum: Modules & VBA 06-18-2012, 12:01 PM
Replies: 7
Views: 1,661
Posted By damian
Re: MainForm to Subform Focus

Thanks for the responses.

Essentially what I need is to somehow intercept and stop the AfterUpdate event of the mainform by identifying if the subform has been clicked. Focus could therefore go...
Forum: Modules & VBA 06-18-2012, 08:44 AM
Replies: 7
Views: 1,661
Posted By damian
MainForm to Subform Focus

Hi
Is it possible to prevent the AfterUpdate event firing on a main form when a subform on the same form has been selected?

Have tried Screen.ActiveControl.Name to identify if the subform has...
Forum: Forms 06-17-2012, 12:46 PM
Replies: 5
Views: 1,100
Posted By damian
Re: Active X Control Shrinks

Thanks for all your feedback (well almost all), didn't realise anyone replied and did exactly what linq recommended and it worked. Cheers
Forum: Forms 05-18-2012, 05:54 AM
Replies: 2
Views: 1,036
Posted By damian
Re: video on a form (ms access 2007)

Little late, I've acheived this using the Windows Media Player ActiveX. I'm using Access 2010 but suspect it's available on 2007 (if you're still on that version after all this time)
Forum: Forms 04-30-2012, 01:15 PM
Replies: 5
Views: 1,100
Posted By damian
Active X Control Shrinks

Hi

I've embedded a Windows Media Player (WMP) active x control in the header of a continuous form. Works well until I either scroll through the records or click on different records - the WMP...
Showing results 1 to 25 of 87

 
Forum Jump



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