Search results for query: *

I am a little confused. when you speak of table, which table are you refering to. the main collection of data table or the table used for the combo box information? sorry, i am new at this!

Yeah! I want to choose "all" and have an if...then statement say if combo box = all then have criteria = true. I am just not sure how to write it in Access97 code.

Here is what I have. In a work order system, we indentify types of work to be done by different types of tags. I have my associates select one of the three types of tags: Maintenance, Operator, or Safety and it creates a report. They want an option to choose "all" so that they can...

Hi Robert, Thanks for getting back to me. Currently I have not created a query for the report to be based on. I suppose it would be qryTradeReport. It will have several different field which will be reflected in the report. The report will be displaying several peices of data(mostly text)...

I am trying to get information selected from a form to create a report(from a template) Here is what I have: form name is: frmTradeTemp they select a trade: cboTrade they select a department: cboTradeDepartment they select a line: cboTradeLine report template is: rptTradeTemp then hit submit...

For the SQL statement should there be a comma after "update tablename"? Also, what is "field2" refering to?

I am using Access 97 and am having a problem having the check boxes return a text value to my table. the users should be able to choose one or many different boxes and I want the checked ones to report text to one field(have that one feild accept one or many peices of text(?)). Also, After...

I am new at this. will this report to my table "one". Assuming I link the textbox to the correct field, of course. Thank you, Hobbes' Dad

Does anyone know how to have a frame with six options report the actually text, not a number 0-5?? Either code or an explanantion would help me. Thank you, Murphy's dad!

Thanks!! Murphsdad

How would you be able to get this to report as a bar graph showing monthly comparisons between two sets of data? I have a similar issue where i am trying to graph incomplete work orders vs complete work orders(per month). -lost and confused :(

Me.calendar1.Value = Date worked. Thank you! Jeremy Link

Thank you but it is not working. Perhaps I should have told you two things: 1. I am using access 97 2. the name of my calendar is frmCalendar J

I use a calender that comes up as a form. How do I get this calender to be up to date as it opens. It is still reporting from the orignal date I started it. Thanks, J

One more quick thing...This file should be able to be used by more than one person at a time. What can I do to make it avaiable??

I can ensure that no one is in the file. The only problem is that this .ldb is still open. Is there any way to get rid of this and make sure that it doesn't hover around again after someone has exited the program??? Thanks for the help!!

I am getting this error message. The thing is, I am sure that there is only one user trying to open the program. "The Microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time." It comes up whenever I try...

From a combo box (ReportType)on the form(frmCreateReport), I want people to choose what type of report they would like(incomplete or complete). When they select incomplete, I am trying to get a value of "is Null" to report in the field(CompletionDate) of the query(qryReportBuilder)...

This is what I have for a code: Private Sub CmdDone_Click() Forms!frmMainFtag!text1.valueCalendar1.value DoCmd.Close acForm, “frmcalendar” End Sub Private Sub cmdCancel_Click() On Error GoTo Err_cmdCancel_Click DoCmd.Close Exit_cmdCancel_Click: Exit Sub I keep getting a run-time error. All I...

THAT WORKS INCREDIBLY!!! Thank you so much! Jeremy