Search results for query: *

I have a series of queries that I transfer to a workbook and then format using VBA. My problem is the section of code below that only works correctly on the first spreadsheet. Dim xlApp As Excel.Application Dim objExcel As Object Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Set...

I have a dataset that I import and then need to concatenate. The dataset comes in the form of two record sets that then need to be parsed into one record. There is no connecting id, the only thing that I can do is grab them in two record groups and then concatenate that into one. I have...

I am having trouble getting started on this project and would appreciate some direction. I have a table for Standing Orders where the user enters a client and the timeframe for which their orders should be generated. For example, they want their order bimonthly, the user would select...

I have a report that prints for a location and has a subreport that prints the people associated with that location in columns. I have written code into the subreport that changes the fontsize depending on the recordcount in the subreport. I would also like to change the number of columns and...

I have a subreport that has an On Activate event that changes the fontsize depending on the number of records. It works great when I run the subreport but does not work when I run the report. Private Sub Report_Activate() Select Case Me.Countrec Case Is > 4 Me.txtdocname.FontSize = 5 Case...

I hope this is a simple question. I am writing a query where I want it to check for the first parameter and if it does not exist, then choose the second parameter. My query returns results for both. I have tried as my parameters: 1. "High" OR "SMH" 2. IIf(ismissing([Prsched]="High")...

I am pulling data into reports from a program where the tables are not normalized. I would like to pull data into a new table in order to simplify reporting. The original table has fields like: ID#, Order#, Orderdate, Test1, Test2, Test3, ...Test19, AOtest20, AOtest21...AOtest59. The fields...

I have a table with the fields: ID, OrderID, Test0, Test1, Test2, Test2, ...Test40 I know this is not normalized but I don't have control over that part. What I need to do is build a report that is grouped by ID that displays each test (matched to another table by testname (Billrules) for the...

I want to run a query that captures records that have a date and any time during that day. I am currently using >=Date(). I would like to use a between statement but not sure what to write. Any ideas?

I have a main report and am trying to insert 3 subreports. For some reasons, when I save and close the report, the second and third subreport revert back to the first subreport inserted. Am I doing something bizarre? I don't think I had this problem before.

I am trying to print the results of a query in a textbox on a report. There are 99 fields for each record that may or may not have data. The fields are named test_id1, test_id2 and so on through test_id99. I would like to build a Function that would loop through the fields and then...

I need to write a function (or nested query if that is easier) for a table with 39 fields: component(n) where n=1 to 39. I want to compare each field against another database and include if criteria is met. Where do I start?? Gillian

I have a record that has 39 fields of test results, I would like to display the ones that are not null in a row with commas. I have thought of arrays or for next loops (the field name is "fieldname(n)" with n=1 to 39 but am not sure of the correct code. Please help!! Gillian