Search results

Appologies Gasman, for writing without using code tags. Error msg: #Error

Thanks for your response, Yes, Field_Y contains calculation [TotalAMT]-[PaidAMT] i tried this =Sum([TotalAMT]-[PaidAMT]), still getting error msg

Hi and Good evening to all, i am trying to total a particular field [Field_Y] and show it on a Form footer, getting an error msg on control source =Sum([Field_Y]) what am i doing wrong or is there a better way to do it through vba Thanks Mahesh

Dear Pat, again i am saying and i am not just praising for getting anything in return as you say free labor from Mr. Arnelgp and neither do i want to react to your statement. Also, i don't mean to hurt the others who have equally helped me a lot too and take away the credit from them. Dear...

Yes, very much Pat, i have such high regards to Mr. Arnelgp. anyways, thanks for your time in responding to my post.

Thank you Pat and June7 for your response, Yes it sounds stupid that they will be going to remove Access from the org. Well thats their decision. Yes Arnel was very kind and he is the only person on this forum who has helped me and others on this forum to get their projects completed. I just...

HI All Hope you are all fine and in the pink of health The reason to initiate this thread after a gap of 18 months is that very soon my organisation will be discounting MS Access in few weeks time. Well, i dont have any control of them and the day they stop Access it will be disaster for me and...

attaching the excel file

HI all i am working on automating the recon process which is coming out from the source file. It with three tabs a) DataSource b) Summary c) Recon DataSource is the actual data for a particular date with 40+ columns a) I am able to get code for unique Names based on the account in column (D...

Thanks Gasman, i realize that i will be creating table once in a while. However, i wanted to understand how this works. With the steps 1 to 5, i have got some what idea how to do this. I will leave it for some other day. i want to thank for your time and support that you given. Thanks again...

Thanks Gasman I wanted to make this dynamic, so i can use the code based on the table name in the subform mentioned which is selected as "Yes" How can i do this. As mentioned earlier, i have union all query from the two queries which has date prompt, which is used for make-table query. So the...

Thanks Gasman, the date prompt is there in the Union All Query. I tried to put the sql code but got an error, so left it as is. i tried to come up with something which i have i done in the attached db. below is the code Dim qdf As QueryDef Set qdf =...

Hi! Gasman, i seen the link from post #9, tried to write the below code but i am getting error Private Sub cmdCreate_Click() Dim qdf As DAO.QueryDef Set qdf = CurrentDb.QueryDefs("qry_Create_tbl") qdf.SQL = "SELECT qry_dmd.* INTO tbl_tempError " & _ " FROM qry_dmd;"...

Good Morning all Yes thats right Gasman suggested to run vba with DoCmd.Execute (Sql) which will prompt for the dates. i am searching through net for similar code. i am attaching my db for what i have done so far.

yes, the logdate is replaced to Rejectdate. I have got the table name as tbl_tempError. how do i put this code under vba. I am looking for date prompt on the click event for the user to enter date.

HI! Gasman, the make table sql is SELECT qry_dmd.RejectDate, qry_dmd.DispatchLocation, qry_dmd.CustomerAC, qry_dmd.RejectReason INTO tbl_tempError FROM qry_dmd WHERE (((qry_dmd.RejectDate)>=[StartDate] And (qry_dmd.RejectDate)<=[EndDate])); RejectDate which has prompt date (StartDate and EndDate)

HI! anyone here who can help me to fix the code from post#1. i can create new table from make-table query, but i need to create table based on date prompt through click on form

i am just attaching snapshot of the db, Thanks Ranman, but how can i use make table with date prompt in vba.

Hi! All I am trying to create a Temp Table based on date prompt (busStartDate & busEndDate) using something similar vba code Currently the below code is to export data into excel, while i am looking to create Table in the same db My table to be created is TempError from tbl_DispatchDetails and...

HI! bastanu and everyone here, Apologies for the delay, I have checked the codes and adjusted to my requirement and it works perfectly fine. Want to thank bastanu and everyone for their valuable time and help. thanks again, i will close this thread as Solved