Search results

Hi pbaldy, Thanks a lot for your reply, It's working fine now. Can you pls help me with below issue as well. I need help on one more thing .i.e. in my database table .i.e. commentary table I have column called "Expected Data As of Date" now this column has those dates which the data provider...

Hi pbaldy, Thanks a lot once again for your reply, I have incorporated the change and below is the error which I am facing. Error msg: Compile error: can't find project or library When debug it highlights the Chr text the following line : sSQL = sSQL & "[Commentary] = " & Chr(34) & Me.Text15...

Hi pbaldy, Thanks a lot for your quick reply, Post incorporating the change suggested by you now I am facing a different error. Error Msg: Run-time error '3464' Datatype mismatch in criteria expression When I debug it highlights the same line .i.e. DoCmd.RunSQL sSQL But this time I have...

Hi pbaldy, Thanks a lot for your quick reply, I have incorporated the change suggested by you in my sql statement but still I am facing the below error msg. Error Msg: Run time error '3075': syntax error (missing operator) in query expression 'ID = FI Cash' When I debug the above error it...

Hi All, I have database in which I have data table called commentary table now I created a userform to input/modify data in the same table the form has 1 Combobox which contains a list of products populated from the product column of the datatable same way there is dtpicker which is updated...

Hi All, As mentioned earlier I just want input some code in the background of the submit command button on my form which will save back the commentary updated in textbox and the date selected in the datepicker by product guy against the product selected by him in combobox to the data...

Hi All, Did anyone get the chance to look into the above thread. Thanks a lot for your help in advance :)

Hi All, I have sharepoint linked table table name "table1" in my access database and a form .i.e. form1 which has one combobox, one datepicker and one textbox which are linked to that sharepoint table in the following way, the combobox is linked to table column which is product column so the...

Hi All, I have around 6 to 7 sharepoint linked lists as data tables in my access database .i.e. access 2003 I them to make a local table directly with some shortcut. some VBA code or some other shortcut I know in excel 2007 there is option to make them work offline but in access 2003 we don't...

Hi B, I am bit confused with the solution which you have posted. Can you please help me with the below sql statement. strSql = "SELECT [Local - RAG Status].[ProgramID], [Local - RAG Status].[SILO], [Local - RAG Status].[PROGRAM_NAME], " _ & "[Local - RAG Status]." & strSelectedFieldName & "...

Hi B, Thanks a lot for your quick reply, I have incorporated the code provided by you in my form and it's working fine but when I try to add some criterias to the same it doesn't work. Below is what I am trying to do .i.e. filter JAN_RAG .i.e. MONTH_RAG column for only AMBER and RED items...

Hi Everyone, I have a table in my database from which I am trying to query the data for a particular month. Now in that database table I have separate column for each month I want to come up with a query which will filter the columns and will give me only one particular month column in the...

Hi Bob, I have made the changes as suggested by you in your earlier posts but I am facing the below error now post making those changes whenever I open the file. Thanks a lot for your help in advance.:)

Hi Bob, I have encountered some issues which I have mailed to you. Can you please look into the same. Thanks, Abhy

Hey Bob, Apologies to bother you again but did you get the chance to look at my mail in this weekend. Regards, Abhy

Ok. No worries. Please let me know once you get the chance to look into the same. Thanks a lot for your help in advance. Regards, Abhy

Hi Bob, Did you get the chance to look at my mail msg. Regards, Abhy

Hi Bob, Thanks a lot for your quick reply, I have incorporated the change posted by you in my code but unfortunately it's showing a syntax error in FROM Clause. Please expedite. Thanks a lot for your help in advance. :)

Hi Bob, I tried to incorporate the change suggested by you in the my code but still I am getting a syntax error on the below line strSQL = "Select * From Query1 WHERE [FullReportname] = " & FullReportnameBelow is the SQL code of query1 SELECT [Table1].Region, [Table2].Country...

Hi All, I have form in one of my mdb file which gets opened automatically when I open the mdb file. Now I have two combo boxes on that form first one is Region and second one is country and then I have command button to print. The first combo box gets populated with regions like USA, Asia...