Search results

I have written the following criteria in a 'Date Submit' field in a query and it gives me an error 'The expression you entered has an invalid date format' >=#Forms!frm_RMS_Dashboard!txtStartDate# and <=#Forms!frm_RMS_Dashboard!txtEndDate#

If I add date filter in one of the queries then the following error message appears: The Microsoft Access database engine does not recognize Forms!frm_Dashboard!txtStartDate as a valid field name or expression

All the queries work fine. If I set the row source of a graph in the property sheet then again it works but just when I try to leave the row source blank in the property sheet and set the row source of the graph on the click event of a button using vba then that error appears.

Hi All I have a form and there is a graph on it which needs to be filtered using the date range on the form . When I set the row source property of the graph in the property sheet then I don't receive any error message but if the row source is set on the click event of search button then when...

Hi there My boss wants me to present some ideas on how to link frontend and backend if they are stored in different networks . The frontend will be stored on one network in a company and the backend Is stored a different network in another company . Can we do something like exporting data in...

Hi Guys I am looking for solutions that we can employ where server side issues impact database performance. Permutations to consider are: 1) Where the server performance is degraded and options are needed to streamline Db to reduce overhead 2) No server is available removing the...

Hi guys I am writing the following code to insert a table in word document using access vba . I want to display 2 columns in a table i.e assessment questions and the scoring against each question . My code displays the assessment questions in the table but scoring doesn't get displayed. Any...

Hi there I am getting runtime error 3061. Too few parameters expected one in the following line of code. The query itself works absolutely fine. Set rs = CurrentDb.OpenRecordset("qry_FormsCat_CallAudit_CustomerOutcome") Any help will be much appreciated. Thanks

I have used chart control on the form and written the following query. It shows separate bars on the charts for each reason type. I tried to overlap by setting it to 100% but one set of data which is larger than another hiding the smaller set. Any ideas ? TRANSFORM...

Hi Guys I want to display a Stacked column chart on a Form. The X axis should display all the managers names and Y axis will display "Number of reasons" and stacked bars will display "Name of the reasons for not signing the forms". Please see attached the example of the graph I want on my...

My first query is giving me following result: 1stRefuseReason Times In dispute with the score / grade 9 Sent in error 9 Disagree with the content 20 Missing Content 11 The query is SELECT tbl_RMS_Paperless.[1stRefuseReason], Count(tbl_RMS_Paperless.[1stRefuseReason]) AS Times FROM...

Thanks Minty, Another question is I have another field named "2ndRefuseReason" which also stores reasons. Is there anyway I can combine the "1stRefuseReason" and "2ndRefuseReason" so that answer of the query will be something like below where Reasons A,B,C,D come from two fields...

Hi Guys The following query works fine but if the reason is blank then it also shows a record with blank reason and count=0 I don't want the blank reason to be displayed in the query. SELECT tbl_RMS_Paperless.[1stRefuseReason], Count(tbl_RMS_Paperless.[1stRefuseReason]) AS Times FROM...

Guys, The error was in the other part of the function. I have fixed that. But My following code (written in the form) doesn't seem to call the function in the module. Can anyone please help me in this? Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then Call...

even if I change the data type to variant then still same error : Public Sub AuditChanges(IDField As Integer, UserAction As String) On Error GoTo AuditChanges_Err Public Sub AuditChanges(IDField As variant, UserAction As String) On Error GoTo AuditChanges_Err

I have changed the data type from number to integer but getting type mismatch error. the textbox on the form named txtGenMeetingID stores data from the field GenMeetingID in the table and this field has autonumber data type. Any help guys on this one ?

Hi Guys I have been trying to add audit trail functionality to my database. I have written following code on the Add button on form: If Me.NewRecord Then Call AuditChanges(me.txtGenMeetingID, "NEW") Else Call AuditChanges(me.txtGenMeetingID, "EDIT") End If The...

Ridders, thanks for this. But this code doesn't show how to import csv file into access database using vba. Can anyone please help me in this? Thanks

Hi Guys Can anyone please provide some guidance on how to import data from a csv file to the access table using vba? Do we need to create a table first those number of fields and what if any csv file has different fields or some different file format? How the validations can be placed...

It still gives me argument not optional compiler error at .additem statement . Set rs=currentdb.openrecordset("qry_mysignoff") Rs.movefirst Do while not rs.eof I=me.lstitems.lstcount-1 If isnull(rs.fields("datesign")) then With Me.lstitems .columncount=3 .additem...