Search results

Hi all, How do I run a query and have the result show in a textbox on my form? I have already created my query but not sure how to get the results in the textbox Thanks, SteveG

I would like my query results to total my field by weekending date for a rolling year. I am able to query a rolling year using the below criteria. criteria: Between [Forms]![fmRptOpt]![txEndDt]-365 And [Forms]![fmRptOpt]![txEndDt] But it returns every day. How do I make it return by weekending...

Thanks, I was mistakingly using "Output to" in my macro.

can I create a macro to do this task?

I am having trouble outputting a table to Excel. Access automatically saves the excel file in the older 95 format. How can I save the outputted table to an Excel 2000 format?

Hi all, I have a query that gives me results of my database. Each record has a unique ID number that corresponds to that record. Now I would like to print out only the records that come back in my query as a report. Any suggestions??? Thanks, Stevegr

Option 1.) I would like to have a message box pop up to ask if I would like to run a macro when I move to a particular sheet in my workbook. Option 2.) I could have a button on my sheet to run my macro. I have already saved and named this macro, but what is the code to achieve either of these...

Basically I want to use data in my maketable query (Field name: "Delays") as new criteria for a another query. How do I use the field data "delays" as query criteria? Under the field "Delays" there are ten numbers that are queried by the most hours for a date range, What I want to do is use...

here is a jpeg of my query. I would like to use all of the data under the delay field to use as my new criteria

This is the code that creates a make-table query: SELECT DISTINCTROW TOP 10 tblPress.PressNumber, [DelayCode] & [DelaySubCode] AS Delay, tblDelay.PrimaryDesc, Sum(tblSummary.DelayHrs) AS SumOfDelayHrs, Count(tblSummary.DelayHrs) AS CountOfDelayHrs...

Can you be more specific when you say "join the two tables? I have added both tables to the query and it gives me an error. If I delete one of the tables, then I don't get the error. I am not sure if my tables need to have a relationship or not to get this query right.

I want to use the data (1 field, but all rows of data) in my my table to be the citeria of a new query. While keeping the field data in the same order in my new query as it is in the table. Thanks, Stevegr

Basically I need data in a table to be used in a new queries criteria. This is as simple as I can explain it. Thanks, Stevegr

Hi all, I have a make table query that runs to give me data for a specific time period. Now I need to use one the the rows of data and run a second query to give me similar data with the first tables criteria. This is confusing. . . Let me give you an example. I am pulling information on a...

That worked great CPOD, Now one step farther. What if the info I want to get the value from is a combobox? I tried the same methodology with your first answer and it queryed a square box. There are 2 columns in my combo box. How do I define which value to get? Thanks, Stevegr

Hi all, I have a button on my form that runs a macro that runs a make table query. On my form I enter the start date an end date of the range I want to query. I have fields in my query to pull the min date and the max date to get the dates so I can export the dates into an excel spreadsheet...

I have a database that 10 people use round the clock. I have just made a change and would like them to notified when opening the main form. I setup a msgbox macro to do this, but I would like the msgbox to go away after 10 days or so once everyone had a chance to read it. Any thoughts on how to...

Hi all, I have a database that is used by 10 people or so. I have made a change and would like to alert them with a msgbox macro on form load. What I was thinking is to have the msgbox delete after 15 days so everyone had a chance to read it. Any thought on how this can be done? Thanks, Stevegr

Thanks, That was simple

Happy New Year, I have a query that I would like to display by shift. (Ex 3,1,2) in that order because 3rd shift starts a new calender day. I do not calculate time, just date and shift. So in the query to get 3rd shift to show up on a particular date before 1st shift is puzzling me. Any...