Search results

My two cents on "giving good chances int the new world" is your ability to adapt and how quick you can learn a new language. Here we learned Java and .net... My first job was in Dataflex, now programming mainly in x++ (around September it will be c#). Still creating small programs like nfc...

Am i seeing a trend in all the posts of vba_php ? I think it is a great idea of a like button. I would hit that button more often than the thank you one. It feels like some personal button and sometimes I hesitate. I like the solution, but will not use it personally so giving a thanks for it is...

Welcome and have fun building the tools needed :)

My guess is that Date() will display the date in dd/mm/yyyy. But when comparing it will use the internal date format. (See the post in here : https://techcommunity.microsoft.com/t5/access/formatting-date-where-you-don-t-live-in-usa/m-p/255436 )

Welcome Moritz !!

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 : minutes He also had a holiday table.

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 AM to 17:00:00 PM each day)" So 5 days a week same hours. You will have to change it to add only...

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 Null)); That will concat all the container_ID from the staging table where ordernumber is null.

Welcome on this amazing forum :)

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 for it. I will try a more elegant solution for you... Basically you need to add an extra condition...

You can ask the questions all the time :) Maybe someone else than me can answer it.

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 The first one just calculates the time between 2 dates. The second topic calculates the time...

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.

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...

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 columns are not the same in all the tables you will search. So how will the search box handle that ?

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 control and that is it ?

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 include the new parts. (Extra joins and selects)

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 Destinations as B on A.DEST1 = B.DESTID join Destinations as C on A.DEST2 = C.DESTID join...

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 to remove the redundant information. (extra table maybe)

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 to change the layout :/ So best you can do is use the wizard for the content and after change the...