Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.08 seconds.
Search: Posts Made By: MickJav
Forum: Modules & VBA 09-17-2019, 11:52 AM
Replies: 16
Views: 254
Posted By MickJav
Re: To 'Call' or not to 'Call'

I don't really use it, but sounds a good idear for the function return value I will use it for the same in future thanks


mick
Forum: Theory and practice of database design 09-15-2019, 01:53 PM
Replies: 6
Views: 134
Posted By MickJav
Re: Position Msgbox

Dont think so but you could use a form made to look like a message box then move it where you wanted I know isladog posted code for moving a form.

Hope it helps mick
Forum: Queries 09-14-2019, 08:11 AM
Replies: 15
Views: 275
Posted By MickJav
Re: How to filter a Union query?

This is one I use in my employees example SELECT * From QryYearlyEventsAll WHERE [EventMonth]=" & F!Cmonth & " UNION SELECT * FROM QryYearlyEvents WHERE (([EventMonth]=" & F!Cmonth & " AND...
Forum: Queries 09-02-2019, 12:01 PM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Lol


https://access-programmers.co.uk/forums/showthread.php?t=156396
Forum: Queries 09-02-2019, 09:48 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

DONE IT you have to add both the Criteria and paramiters

Criteria = Between [Forms]![frmRota]![txtFrom] And [Forms]![frmRota]![txtTo]

paramiters
Forms!frmRota!txtFrom
Forms!frmRota!txtTo

...
Forum: Queries 09-02-2019, 09:25 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

I just found this which might be of interest he might share the code he uses if you ask nicely lol.


I didn't think of a coded solution I'll give it a try but got to write a time validation...
Forum: Queries 09-01-2019, 10:27 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

That worked nicely might use tables with mine and create it manually.


tried useing the where like they did and thing still wouldn't open.


I might right a code solution as that I know would...
Forum: Queries 09-01-2019, 09:05 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

If it's opened without the form then it displays all data I had a look at your one could see where you made the change but as you said it mucks the date data up.


thanks
mick
Forum: Queries 09-01-2019, 09:02 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Well had no luck tried every way I can think of to add the limiting dates I've run out of idears
Forum: Queries 09-01-2019, 08:45 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Added the peramators both the way thedbguy and Isladogs suggested


PARAMETERS Forms!frmRota.form.txtFrom DateTime, Forms!frmRota.form.txtTo DateTime;
TRANSFORM First(QryJobCrosstabData.Times) AS...
Forum: Queries 09-01-2019, 08:35 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

I have the same problem with crosstabs this is my first in years
thanks for your help I'll try the db guys solution again with my rota screen be back soon
Forum: Queries 09-01-2019, 07:55 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Well the data query opens with the limiting txtboxes on the main rota but the crosstab just opens with a white screen.


I may run the office repair but not sure if that will make it worse or...
Forum: Queries 09-01-2019, 07:47 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Lol I did have the Crosstab on a datasheet subform but when I changed dated the fields created got broken so had to change it for what it is now but when I had the subform I kept getting that...
Forum: Queries 09-01-2019, 07:00 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Taken everything out thats needed and added to uploaded db


thanks all for your help mick
Forum: Queries 09-01-2019, 06:44 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Sorted the ordering there are dates missing as these haven't had time assigned but would have for the complete weekly rota



Just tried adding form but no luck Going to see if I can pull what I...
Forum: Queries 09-01-2019, 06:26 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Hi Just tried that no luck I have also noticed when I make changes to queries It no longer asks me to save the changes it just does it but on forms and others it asks me to save
Forum: Queries 09-01-2019, 06:24 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Yes I only intend for their to be one weeks entries so havent set an order as yet will try adding form to the expression Thanks
Forum: Queries 09-01-2019, 05:14 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Just About to go shopping but can pull that data and queries out Have got rid of the datasheet subform and now using the Query As the subforms recordsource like Query.QryJobCrosstab I no longer get...
Forum: Queries 09-01-2019, 04:58 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

I have a feeling it's related to windows update as had a problem yeasterday with another between query I found a work around there will try using your idear but not done that before with a query

...
Forum: Queries 09-01-2019, 04:49 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

This is the SQL for the crosstab just in case it'll help


TRANSFORM First(QryJobCrosstabData.Times) AS FirstOfTimes
SELECT QryJobCrosstabData.Employee
FROM QryJobCrosstabData
GROUP BY...
Forum: Queries 09-01-2019, 04:45 AM
Replies: 37
Views: 355
Posted By MickJav
Re: Crosstab Between dates

Yes Just using it so I can get it wright
Forum: Queries 09-01-2019, 04:25 AM
Replies: 37
Views: 355
Posted By MickJav
Crosstab Between dates

I have a query that I built to feed data to a crosstab query As Below


Hope somebody can point out where I'm going wrong with the between data And date I created these with the expression builder...
Forum: General 08-31-2019, 07:39 AM
Replies: 16
Views: 253
Posted By MickJav
Re: Current date as default value in text box.

If your control is bound to a field then use


Me![ControlName].DefaultValue = Date
Or you could set the default Value on the properties sheet by using
=Date()


hope it helps mick
Forum: Forms 08-29-2019, 11:17 PM
Replies: 6
Views: 127
Posted By MickJav
Re: Age field in form

Just Added that to my employee example version 5
https://www.access-programmers.co.uk/forums/showthread.php?t=306487

...
Forum: Forms 08-27-2019, 12:14 PM
Replies: 8
Views: 150
Posted By MickJav
Re: Expression Builder pointing to subform field

Shouldn't it be forms arnelgp

I.E. Forms!frmDetectIdleTime!WorkingDays
Showing results 1 to 25 of 500

 
Forum Jump



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