Recent content by lookforsmt

  1. L

    Help with template

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

    Help with template

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

    Help with template

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

    Help with template

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

    Help with count of rows

    attaching the excel file
  6. L

    Help with count of rows

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

    Help to create table based on query date prompt

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

    Help to create table based on query date prompt

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

    Help to create table based on query date prompt

    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 =...
  10. L

    Help to create table based on query date prompt

    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;"...
  11. L

    Help to create table based on query date prompt

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

    Help to create table based on query date prompt

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

    Help to create table based on query date prompt

    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)
  14. L

    Help to create table based on query date prompt

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

    Help to create table based on query date prompt

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