Search results

I have a table that has the possiblilty of zero as the answers. As it is now the default value is zero. Some of the fields have calculations. How can I accomplish this? Thanks

I have a form with a subform. The subform is shown in datasheet view. I want to be able to doubleclick a record in the subform to fill in data on the form. I know that I can go to the properties of the subform and choose double click, but I have no idea what to do after that. Thanks a million!

I have added a subform to a form in an attempt to show data from a table so that the user can input data into the form. That is working ok, but I want to make the subform field sizes smaller and change the text above the fields. I have done it in design mode, but when I look at it in form view...

I put a subreport in a report so that I could show some data from another query. If I open the report that has the subreport, one of the rows of data is missing. If I open the subreport by itself, the row is there. I tried adjusting the space between the detail and Page footer, but that wasn't...

Can anyone see a problem with this criteria in my query? SELECT Orders.[Date requested], Orders.[Item ordered], Orders.[Quantity ordered] FROM Orders WHERE (((Orders.[Date requested])>Date()-10)) ORDER BY Orders.[Date requested] DESC; I get and "Undefined function 'Date' in expression." message...

Can someone help me do this in a better way? I have built the two queries below to give me a montly sum of some church contributions. On the "Reportsfrm" form I have two combo boxes to choose the month. One of the combo boxes is setup to choose the months of the year names. This is used merely...

I am not good with code, so could someone please help me with some "If" and "Then" code to avoid and error? The bit of code that I am going to post works fine unless the escape button is pressed or the enter button is pressed without and entry. I know the path that I would like it to take, I...

I am trying to perform a simple calculation in a text box on a form. I want to use a variable in the calculation from a table. The table name is Iodine and the field name is Normality. I have the variable in the table because it changes frequently. I am trying to do this from the "On Enter"...

The database that I currently work with has the option chosen to compact and repair on close so that if I am not present when there is trouble the users can close the db and the problem is usually corrected. I currently have a close button on the Main switchboard that closes the db. Is there a...

Below is the beginning of some code in a database that I need help with. I do not know Visual Basic. The form works great unless someone forgets to enter a lot number. If that happens an error is generated. I would like to put an IF statement in here (I have no idea how or where to put it) that...

This is code in a command button on a form to preview a report. DoCmd.OpenReport stDocName, acViewPreview, "Control Room Query", "[Lot #] = Forms![Hydro COA]![LotNumber]" What could I change in this code to use in a different command button to have the report sent as an attachment in snapshot...

I have this select query. SELECT DISTINCTROW L160.Date, Avg(L160.Zinc) AS [Avg Of Zinc], Min(L160.Zinc) AS [Min Of Zinc], Max(L160.Zinc) AS [Max Of Zinc], Count(L160.Zinc) AS [Count of Zinc] FROM L160 GROUP BY L160.Date HAVING (((L160.Date)=[Forms]![L-160quarterfrm].[Date])); How do I build a...

I have a form that I am trying to show in a text box the results of a count query. The query has two fields in which one is a check box. The criteria for the text box field is set to true to list all that are checked. I want the query to show all the records that are true. This works if I run...

I have a form that I am trying to show in a text box the results of a count query. The query has two fields in which one is a check box. The criteria for the text box field is set to true to list all that are checked. I want the query to show all the records that are true. This works if I run...

I have a query that querys another query for check boxes that are checked. I would like to display in a text box on a form the # of records that the query found to be checked. I have looked all day and have found nothing that I have enough knowledge to use. I need to know how and how to apply...

I have a form with 4 text boxes that are populated from a query with an unbound cbo box to make the choice from. There are two fields that show on the dropdown, "Customer" and "New Product Name". I created it all with wizards. Most of the Customers have only one product name but some have...

I have a form with 4 text boxes that are populated from a query with an unbound cbo box to make the choice from. There are two fields that show on the dropdown, "Customer" and "New Product Name". I created it all with wizards. Most of the Customers have only one product name but some have...