Search results for query: *

Hello I am trying to create a report from multiple queries. The queries are already created and working. How can I combine these queries into One Report? Queries: 1. Day Shift Avg Totals 2. Night Shift Avg Totals 3. All Shift Avg Totals 4. Location1 Totals 5. Location2 Totals 6. Location1 Day...

I have created many Queries in Access 2010. When I create the report of the query, some fields are asking me to enter data when the data is Sum and Avg by the query. what am I doing wrong?

What property is the one to figure out if the check-box is cheked or not?

How can I make the Combo box item selectable? Is there a property for making the Combo box item selectable? Help np3il

Is there a function in Access to display the Time at run-time or to view the system time including seconds? Ex. hh:mm:ss and displaying every second like a clock. Is there a function to do this in Access? Thanks Np3il

My query is mad of two tables with the same fields and I need to requery or refresh this query at run-time. Is there a way to refresh a query after a new record has been added or if a record is modified? Thanks Np3il

Hello, MS-Access (VBA) subform problem. I have two subforms that I need to open by dbl-click an field on the record. Is there a way to do this? I tryied the On Double-click property but this only works for one subform in an old apps. If I am looking at a Subform1/Subform2 and double-click...

Hello, Is there a way to change a number in the formula dynamically in a Excel Macro? Ex. =100*VLOOKUP($P2,QUERY!$A$2:$Q$3191,17,FALSE) Change the 3191 with a variable or the contents of another cell. Thanks Np3il

Query Is there a way to read data from more than one table with the same Layouts and append the data as one table? In better words: Merging two tables into another table. Any suggestions are appreciated. Thanks Np3il

How can I get/read the user/computer name? or In better words, The user that is currently logged on in VB6. Is there any existing variable or code for this? Any suggestions appreciated. np3il

Is there a way to add a field to the Page header Section??? Ex. Report header (Section4) NOT ok here Variable field OK Text field Page Header (Section2) NOT ok here Variable field OK Text field Detail (Section1) OK here Text & Variable fields Page Footer (Section3) Report Footer (Section5)

Is there a way to make a variable part of the Data Report Header??? Ex. Report name <Company Name> <Store #> Page where <Company Name> & <Store #> denoted as variable value. Thanks B-)

How do I make the report &quot;rptDailySales.Show&quot; get the new query generated by &quot;DEConn.rsSQLCommand.Requery&quot; ??? I have tried rptDailySales.Show = DEConn.rsSQLCommand.Requery and rptDailySales.DataSource = DEConn.rsSQLCommand.Requery but these generated an error. Any...

using VB6 and Access db ... I created a query in Access DB and I need to select a portion of this data within VB6. I am using a SQL command to do this, BUT I am unable to get the data that I want. This is the command I am using: 'Create SQL Command sSelect = &quot;SELECT TICKETS.TICKET_NO...

I created an SQL comant and I need to generate the report at run-time. I am using DataReport in VB6 and use the report.DataSource = rsRep command and I get an error (Compile Error: Method or Data Member nor found). If I create a data member, it can not be done at run-time. For example, the...

With SQL Statemet, How do I create a report? How do I use the data coming from the SQL Command in VB6 to Generate a report of it ???

The date is formated MM/DD/YYYY and the Designer in VB Reports changes to { d '2002-02-15' }. I also tryed to PD = '2/15/2002' and I stil get errors. What am I doing Wrong here ??? SELECT TICKET_NO AS TN, PU_DATE AS PD FROM TICKETS WHERE (TICKET_NO > '01999999') AND (TICKET_NO < '03000000')...

1)In the SQL Builder from VB6, I need to segregate the data with the user entered date. Ex. Report for the Date: 02/15/2002 the SQL Builder is changing it to ={d '2002-2-15'} format. Is there a way to prevent vb6 to change the format?? 2) I also need to compare a portion of the Item to the...

I am trying to execute SQL commands from VB6 ... strSQL = &quot;SELECT Count([Stores].[StoreID]) AS iTotStore FROM Stores;&quot; rsStores.Open strSQL, dbConn cmdSQL.CommandText = strSQL cmdSQL.Execute ... This command is executing ok but it is not assigning correctly to iTotStore...