Search results

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

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 output you want.

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.

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 proposed 2 solutions. Since you don't know vba, you can create a new table where you store the values...

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 result of the select in an array and change the correct index with the number in the control. You will...

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 textbox. Then hover over it will show all the text. (Warning : max length of the ControlTipText is...

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, ROW_NUMBER() OVER (ORDER By Date DESC) LessonNumber, LessonStatus

Not sure a big deal but you miss a closing ')' in the WHERE : WHERE (((PTblPOs.POSelfDelivery)=False) AND ((PTblInv2GR.I2G_InvIDRef) Is Null);

Note that the code from Ranman256 is to save a file. You need to change the filedialog into msoFileDialogFilePicker. Here is an example : https://msdn.microsoft.com/en-us/library/office/ff196794.aspx

I suppose [NodeID] is the Id of the node you just tried to save ? Not sure if get the correct value there if you force the dirty to update. Have you tried to refresh the data just before opening the form ?

Maybe you can use the event NotInList ? https://msdn.microsoft.com/en-us/library/office/ff845736.aspx Something like this :http://www.access-programmers.co.uk/forums/attachment.php?attachmentid=64608&stc=1&d=1480606660 If you open the form and enter a random text you will get a nice message...