Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 286
Search took 0.02 seconds.
Search: Posts Made By: Grumm
Forum: Politics & Current Events 03-20-2019, 03:52 AM
Replies: 362
Views: 18,179
Posted By Grumm
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Education systems may differ from country to country. But when there are strikes, it is all the same.
I see it now in Belgium. Teachers are angry because they must work harder...
I had the luck to...
Forum: Politics & Current Events 03-11-2019, 02:42 AM
Replies: 2
Views: 284
Posted By Grumm
Re: Canada - a nation crashing with No Survivors & Britain Abolishes Itself

This is not only a thing in London. I live in Belgium and I feel the same.
I am not racist, those people are running from war (strange that the majority are only men)
But the impact is great in...
Forum: Politics & Current Events 03-08-2019, 06:49 AM
Replies: 362
Views: 18,179
Posted By Grumm
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Maybe some of us want to see the beauty of the earth each morning when we look to the sky :p
Forum: Modules & VBA 03-08-2019, 02:30 AM
Replies: 11
Views: 313
Posted By Grumm
Re: Calculating Working Hours with Lunch Breaks

I know the solution was already made, but this was the reason why I asked him to make a new thread.
The code was made with conversion because the user asked for it. The time was formatted in hours :...
Forum: Modules & VBA 02-26-2019, 03:59 AM
Replies: 56
Views: 2,758
Posted By Grumm
Re: Calculating Total Work Hours Between Two DateTime Fields

The code is based on a x hour day. So if you have less, then change it to less.
Also note that what you ask is a little different. I made this with the following in mind : "(work hours are 08:00:00...
Forum: General 02-20-2019, 05:37 AM
Replies: 13
Views: 300
Posted By Grumm
Re: How to take all data from a column in query, and show in one form field

Maybe this does the trick :

SELECT staging_t.container_ID, ConcatRelated("container_ID","staging_t","staging_t.ordernumber Is Null") AS Expr1
FROM staging_t
WHERE (((staging_t.ordernumber) Is...
Forum: Introduce Yourself 02-06-2019, 07:34 AM
Replies: 9
Views: 202
Posted By Grumm
Re: Hello from Italy!

Welcome on this amazing forum :)
Forum: Modules & VBA 02-06-2019, 04:12 AM
Replies: 56
Views: 2,758
Posted By Grumm
Re: Calculating Total Work Hours Between Two DateTime Fields

The code was made 3 years ago. I just started to learn access stuff...
It needs indeed some extra work to make it pretty and more generic.
The code was for a specific need of the person who asked...
Forum: Modules & VBA 02-05-2019, 03:40 AM
Replies: 56
Views: 2,758
Posted By Grumm
Re: Calculating Total Work Hours Between Two DateTime Fields

You can ask the questions all the time :)
Maybe someone else than me can answer it.
Forum: Modules & VBA 11-22-2017, 07:34 AM
Replies: 16
Views: 7,277
Posted By Grumm
Re: Date difference - working hours only

Maybe you can use the code mentionned in
https://access-programmers.co.uk/forums/showpost.php?p=1516621&postcount=16
or
https://access-programmers.co.uk/forums/showpost.php?p=1464028&postcount=41...
Forum: General 02-06-2017, 06:15 AM
Replies: 16
Views: 963
Posted By Grumm
Re: Running a sub on a newly opened form

Yes, I see what you try to do.
My 2 cents will be to remove that macro and just add vba code to open the same form without the args in it. Maybe that way it will not cause confusion.
Forum: General 02-06-2017, 03:01 AM
Replies: 16
Views: 963
Posted By Grumm
Re: Running a sub on a newly opened form

I can open the file but I don't see any form where you made this code :
Private Sub cmdAddNewPayment_Click()

DoCmd.OpenForm "Payments", acNormal, , , acFormAdd, acDialog, "Edit"

End Sub...
Forum: Modules & VBA 02-05-2017, 11:48 PM
Replies: 3
Views: 462
Posted By Grumm
Re: afterupdate event from variable

Maybe this will help you : https://access-programmers.co.uk/forums/showthread.php?t=188663

But in your case it will be difficult. You will have to create different querys... Also I guess the...
Forum: Forms 02-01-2017, 05:25 AM
Replies: 7
Views: 341
Posted By Grumm
Re: Picture File

The pictures are indeed the same for all users that use Access. So you shouldn't need to find the path to that file. It is loaded when you launch the program.
Why not just change the picture of the...
Forum: Queries 01-30-2017, 05:01 AM
Replies: 6
Views: 286
Posted By Grumm
Re: Combined Left Joins

Maybe you can ask for a more efficient design of the database... And get a nice bonus for the effort.
Problem now is that if something changes, you will spend more time to read all the code again to...
Forum: Queries 01-30-2017, 02:29 AM
Replies: 6
Views: 286
Posted By Grumm
Re: Combined Left Joins

If that isn't an option, then you must create a query like this :
select A.ID, A.name,A.DEST1,B.description,A.DEST2,C.description,A.DEST3,D.description from Clients as A
join...
Forum: Queries 01-30-2017, 01:43 AM
Replies: 6
Views: 286
Posted By Grumm
Re: Combined Left Joins

So you have 3 columns in the client table ? What if next week the boss says to add a new destination ? Then what ?

I think that is also why you have trouble to do a normal left join.
Best way is...
Forum: Forms 01-26-2017, 04:51 AM
Replies: 6
Views: 293
Posted By Grumm
Re: Making forms look better?

You can just add normal buttons in the form header.
You can create a thema and then save it. Later you can apply it to all your forms.

I use access 2016 and during the wizard there is no option...
Forum: Queries 01-10-2017, 04:06 AM
Replies: 26
Views: 7,142
Posted By Grumm
Re: calculate time in hours minutes and seconds between two dates

I once made a similar function too : http://www.access-programmers.co.uk/forums/showpost.php?p=1464028&postcount=41

You just need to remove the holiday part and it is fully functionnal with any...
Forum: Queries 01-04-2017, 06:00 AM
Replies: 68
Views: 2,272
Posted By Grumm
Re: Running queries on specific dates

Or you can make an enum for field Letter_Dept and Canvas_Block. That way you can expand the enum in the futur if needed.
Forum: Queries 12-15-2016, 12:32 AM
Replies: 8
Views: 668
Posted By Grumm
Re: Access SQL grouped count

Can you post extra information about your database ?
I guess Ranman256 didn't see that the values of a job is done by a count. That value can't be stored in a field in that table.
That is why I...
Forum: Queries 12-14-2016, 07:31 AM
Replies: 8
Views: 668
Posted By Grumm
Re: Access SQL grouped count

So just to get the correct picture :
You select and count all the different jobs.
Then you have 1 control for each job in a form where a user can enter a number ?
If that is the case, put the...
Forum: Forms 12-13-2016, 05:44 AM
Replies: 7
Views: 774
Posted By Grumm
Re: Hoover Over Textbox Display Text In Textbox

I solved this problem once by not using the database list view.
I just created a normal form with all the lines on it. Then i could set the Controltiptext of the text box to the same value as the...
Forum: Modules & VBA 12-09-2016, 01:27 AM
Replies: 12
Views: 607
Posted By Grumm
Re: Changing value of fields a set of records based on a field value change

I think that since the order of the records is determined by a date, you don't need to store that number in the database. Just calculate it when you do a select on the data.
example :
select Date,...
Forum: Queries 12-06-2016, 01:38 AM
Replies: 3
Views: 671
Posted By Grumm
Re: Need Help For query

Not sure a big deal but you miss a closing ')' in the WHERE :
WHERE (((PTblPOs.POSelfDelivery)=False) AND ((PTblInv2GR.I2G_InvIDRef) Is Null);
Showing results 1 to 25 of 286

 
Forum Jump



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