Search results

I need to export a report to a microsoft excel spreadsheet. How can I achieve that? Thanks. :D

I have a query that returns a list of the months that are present in a table. The month's properties is Date/Time, with a format of mmmm, so the month appears as a word not a number (i.e. November instead of 11/11/2008) I need for the users to select a month within that list of values. I...

Thanks it was the single quote on field4.

I did that, this is the String: UPDATE Table1 SET Table1.Field1 = 'Test', Table1.Field2 = 'Medium ' WHERE Table1.Field3 = 'Exxxxxx' AND Table1.Field4 = '54' AND Table1.Field5 = '10 - October' AND Table1.Field6 = '1';

I am trying to run the following query and it's giving me this error: Microsoft Visual Basic Run-time error '3144': Syntax error in UPDATE statement. [ stSql = "UPDATE Table1 " & _ " SET Table1.Field1 = '" & Me.txt1 & "', Table1.Field2 = '" & Me.txt2 & " '" & _ " WHERE Table1.Field3...

But the query that is using it is in the code of a form, and the header includes some data (calculations) from that query, and I want the all the fields used in that calculations in the detail section of the report, and I don't think what you have suggested will work for me in this case.

I want to put in report the results of a query, which has multiple values, and I want for each of the result have a different row. I know I have to put a Loop in the code, but I don't have and idea of how to do it. Please HELP!

Thank You that worked like a charm!

Yes I am trying to add the word 'All' into the values. I have done the query you suggested, this is how it looks, SELECT DISTINCT ([table1].[field8]) AS Expr1 FROM table1 UNION SELECT 0, "<All>" FROM table1 ORDER BY [table1].[field8]; It gives me this error, The number of columns in the...

I know this may be a stupid question, but I am trying to add the value all into a combo box. I have been able to insert all of the values of a query into it, but I want to give the option to users to select all of the values. Can someone help me with this. Thanks.

That wasn't it. It is saying that the text box is the one who can't take the value.

Hello, I am getting the following error while trying to put a value of a form into a text box of a Report. You can't assign a value to this object This is the code Dim strId As String 'Variable to take data from a form strId = Forms!Form1!EID_drp.Value 'Getting values from a drop down...

Thanks so much, that was it, I had a number in one of those!!

I changed it to this, but is giving me this error now. Run-time error '-2147217913 (80040e07)': Data type mismatch in criteria expression. Private Sub Sub_Btn_Click() Dim con As Object Dim rs As Object Dim stSql As String Dim strId As String Dim strMonth As String Dim strWeek As String...

Try using % as the wildcard instead of the *

Table1.Charge is a string, the % is the Wild card, I want to search for everything that begins with 7

The problem is not in that part of the query, I made a test of having a pop up display the string and the values are posting correctly. My three problems are: 1. The like section of the query, AND ((Table1.Charge) Like '7%'; 2. Executing the query. 3. Having the results of the query in...

I need help urgently on executing a query which calculates a percentage (when a button is clicked in a form) , and I need the value of that percentage to be posted in the same form. This is the code that I have so far, please help me out since I am STUCK. Private Sub Sub_Btn_Click() Dim db As...