I am attempting to format a text box (continuous) based on an option box. The problem that I keep running into is that there are 90 records. When running the form and making a selection for one record, the color changes for every record. I have the following Case statement.
Select Case...
Table name is ComputerInformation
serialNumber - Number
CLN - Number
StockNumber - Number
Item - Text
Type - Text (row source is pc;notebook;blackberry;copier)
Weight - Number
DVD - Text (row source is reader;writer)
Thank you so much for your help. My control is called txtBlackberry. The control source is =sum(abs([type] = "Blackberry"))
In order to add a field, you would have to go to computersInformation table go to design mode, in the type field text and add "PDA" as a rowsource.
I have a frm called frmReports. frmReports has the following types of reports: blackberry, router, cell phone, pc, notebook, router, hub. When the user clicks blackberry, I have the following code on the on click:
Private Sub cmdBlackberry_Click()
'Filter database for all Blackberries
'Provide...
I tried it and it still did not work. The zero does show. However, when I created 1 blackberry type in the table, the number did not change (it remained at 0). Thank you again for your assistance.
I still continue to have problems. Let me see if I can explain and maybe you can give me possibly a better way to go.
I have a report that has as a footer. All, PC's, Notebooks, blackberry, cell phone, copier, router, (these are just summing the amount of records of a particular type)(the code...
I continue to experience this problem and can't find a work around my solution. I have a text box "txtBlackberry". I run a report to print the total number of blackberries, everything works fine until there are no blackberries. I then encounter "#error" on my report. Any help would be greatly...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.