Search results

I am not sure how to create the query in this case. I appreciate if you could walk me through the process. Thank you

I was not able to create a count query with date-range criteria :(. Please see the attached image and advise if you can. I appreciate it. Thank you

Hi, Regarding variable: compDate; when I finish my work on a project I send it to upper manager on compDate (completion date). He then needs time to review and close the case. It can be closed in the same day or days after I complete my work. I am still not quite understood all your codes from...

Thanks for the help. I will try to create the query as you suggested and if I couldn't make it run I will get back to you. Thank you

Thanks for the reply, I wrote a function that accesses the table and can count the number of the projects that are in the same date range as the first one. I am sure if I create a loop then it can repeat the same process in all rows (I haven't done that yet). They will work like two nested...

Hi all I have a simple database with a simple table. Table t_projects has a column called serial and four more columns that are called assignDate, compDate (completion date), closeDate and concurrentPrjs . This table can have too many rows but I think it doesn't matter. I need to find the number...

Your solution works fine now. I am sorry to make such simple mistake and couldn't catch it. Now I am wondering about error handling. Please explain the best approach and how to implement it. I have never done this part. Thank you Happy Holidays and Merry Christmas Wish you all the best in new...

Hi all I have a list of the projects I am working on. They usually assign me a project or multiple projects at any given time. I start working on my project and it takes a few days before I finish my task. Once I finish my task and submitted they have to review my report and close the project if...

I used the function call in BeforeUpdate as well as AfterUpdate. It never worked: =fFill_MT_Field() I have it attached here. Thank you

@ Pat I am not OK with that. I need complete and valid data being saved in my table. Sorry if I was not in the right track. I knew what you were asking but didn't answer properly. Thank you for following up anyways

I employed your code in my db and the only thing I changed was the name of the fields. You had F1, F2 & F3 but my names were Gprice, Gamount & Gtotal. In your code you looked the controls that have F as first letter of their name where as in my code I looked for G. After all it is not still...

Hi Pat, This is the situation: You have many invoices from gas stations and need to have all these in a table. Two records are necessary and enough to obtain the third one. Although user have the third one printed on the receipt but we don't use all three (to save time) because we can always...

Hi, I opened your db attached here but I couldn't save even one record properly. I guess you can see the issue on the picture. Here for instance I entered 8 as gas price in first filed and 2 for gas amount. Expecting to see 16 in total (third field) but it would display the first saved record in...

Your example works very well. I need to implement it into my db now. Since I have too many other controls and don't want them to be included in this process then how do I use the tags? Could you please show me the modifications? In your example I noticed once a new record added it goes to the...

To trigger the function my goal was to use "GotFocus" or "AfterUpdate" or "Change" or similar attributes of three controls. Once user starts writing the number of any of three controls function should start in the background and as soon as he enters the second value (total or one of the...

Lets assume user needs to enter hundreds of gas receipts into a table. Some of them are old enough to have faded one of the values but other two are readable. In this situation one solution is to use a calculator and always obtain two operands and let a simple VBA calculate the total or have the...

Can you please explain with an example. I was not able to create the desired query. Thank you

Hi, I have a simple bounded form. There are three controls (A, B & F) in my form bonded to three fields of a table. A = Gas price $/litter B = Amount of gas, litter F = Total value of the gas F = A x B Assume user enters the gas price (A) in the first control and amount of gas in the second one...

Hi all friends, I've not received any help since last week I've uploaded the database. Does it mean I need to reopen a new thread? Do I have done something wrong? Please if you know the answer write me a respond so that I can solve this issue and continue working on my database. Thank you

Thanks for your reply. I am still thinking about what you and arnelgp suggest. I have my database attached. you can look at it and see what would be the best scenario. I was thinking about a temp table. Please tell me what you think. I appreciate your help and other friends. Thank you