Search results

Thanks for the help Sorry for the delay, other projects, But this did the trick,I really appreciate it Thx again

First, let me thank everybody out there for all the help I have received. I know your time is valuable Second, I am trying to get my hands around “objects” better. So I don’t have to bother everyone with my rookie questions. As much as I benefit from the experience, I hate wasting everybody’s...

I would like to create a form (frmBuildQuery) which lists the fields in a query (qryWildcard). I would to like to put a Text Box and Option Button on the form for some of the fields in the Query. On selection of each Option Button the value in the Text box would be written into the criteria for...

This has to be a pretty common need. I have a query that prompts the user for a start & stop date: Example: (query Criteria) "Between [Start Date] and [Stop Date]" I would like to be able to display these two input values in the header of the report so the title can reflect the date choices...

I want to program a command button that allows the user to preview a report. Right now the command opens the report / prints it. What command(s) would I use rather than OpenReport...to preview a report rather than open/print the report [example: DoCmd.OpenReport "rptWeeklyTime",... ] I am...

More Info I have tried the query as a select query and as a make table query. The problem isn't making the query run. I just want to close it once it has run. There is a "Close Form" command and a "Close" command, but no "CloseQuery" Command. When I tried to accomplish this with an"On Open"...

DCX693- Thanks and a brief follow up Thanks, I finally got that to work, and I REALLY appreciate it. One final question. If I wanted to fill in a field in a subform with the updated value of txtName I assume I could add another line to the on Afterdate event. Insted of ...

I want to run a query to update a combo box prior to loading a form. I am using the following code in the on click command to do this: Private Sub cmdRunQuery_Click() DoCmd.OpenQuery "qryActive", acViewNormal, acEdit End Sub I have examples for opening and closing forms, and opening the query...

I am trying to look up an employees name based on their ID #. I have a combo box that has the employees Names and ID #s and stores the ID #. I need the ID # because it is a primary key, but I want to display the name of the person selected in the combo box for verification. What made a query...

I am using 2000

Could somebody give me a simple example of the script to copy a value from a query (qryA)onto a text box in a form(frmB)?

Is it fundamentally poor practice to solicit input from a query user by adding a prompt in the "Criteria" field? Below is an example: [Enter Invoice #] This seems like a pretty straight foreword way to solicit user input but I have problems with the results. Is there a better way to be...

Is there an advantage to developing this list in a subform rather than using a query?

The Zipped file had no query. There are 2 tables (Mainform & Subform) The re are 3 tables(tbDummy, tbName and tbTimeCharges. Your building the report from a script in a form and not a Query?

I'm Getting confused, do I put that statement in the "Criteria" in my Query? I had been using something like: [Enter Contractors ID #] in the Criteria for the Employee ID # field and [Enter Week Ending Date] in the Criteria for the week ending field. bth The employee ID # filed is text data...

Thanks for your reply, OK, It's pretty obvious I am a rookie, could you explain opening in the Add Mode in a bit more detail?

Is there a way to configure a form where it defaults to a “new record” when the form is opened? Would this be a major design mistake?

I have a select query that creates a list of time charges for each project the employee worked on in a given week. This is used to generate a weekly time sheet. The query asks the user for the employees ID # and the week ending dateand returns a list of time charges that meet the criteria. I...

Stuck …again. I have a time sheet report with a sub report showing what projects were worked on in the reporting period. The sub-report is generated from a table which is generated from a query. The table could have from 1 to 25 records returned. Other derivations of this table and report could...

Multiple Reports Generated My dilemma involves a single page report with a sub-report. This sub-report is based on a table generated by a query using an employee ID # and date. When I run the sub-report alone it creates a report that looks and acts (ie. summary fields, etc.) just like I want it...