Looking for a Breezecom/Alvarion BU DS.11d outdoor unit or someone that has used or knows these units. I have several RB DS.11d outdoor units and would like to know if I could just write BU DS.11d firmware to this unit? I know that sort of works on the pro.11 line but these units do not seem to...
TheAceMan1, thanks for the reply. I got a syntax error when I replaced CHAPPX with the code that you gave me. This is the end of the SQL for the query where CHAPPX is used. Also what do I put in for the row source for the text box I am using on the form? I just need the user to input a variable...
Well here is an update to the earlier post. I figured out a few things I was doing wrong and here is the updated code:
Private Sub Command0_Click()
Dim strReport As String 'Name of report to open.
Dim strField1 As String 'Name of your Harvest field.
Dim strField As String 'Name of your date...
I posted this over in reports but I really needed to post it here.
What I am trying to accomplish is this: I need the user to input a date range, then pick a harvester from a list [HARV], and finally enter a decimal number which will be stored in [CHAPPXX] and used in a formula from the...
Well I will provide more code, but it is just not working. Maybe I should do this another way, but I do not know what that would be. Again I will try and explain a little better. First of all I will need the user to input a date range. Next the report will need to be sorted by Harvester [HARV]...
Yeah I do need a date range and it is working. I need to incorporate HARV into this code somehow. I need to select a value for HARV so the report will be sorted by DATE first then HARV. Then finally I want the user to input a CHARRX variable. Do I just create a new strWhere value or what is the...
I need to do a weekly report that need to include date ranges, make user select a piece of data from a field or basically sort the report by HARV, and do a calculation using a variable. I have done the date ranges before so they work, I chose a combo box to ask the user for certian data from a...
SELECT [Fruit Table].BLOCK FROM [Fruit Table] ORDER BY [BLOCK];
That is my row source propery. I was reading about DISTINCT statement, but really did not know if that would help or hurt in the future.
Thanks
Very nice, thank you. It would be nice if only one instance of each block showed up in the combo box. The table might have 200 A1's and 300 B1's etc... Is there a way just to show A1, B1, C1, and so forth so there will not be such a long list?
Thank You
Pretty new to Access so bare with me. Have a table of fields and I need the form to ask the user to print a report based on the "BLOCK" field. I would like a pull down type box that makes the user select from all the different blocks. I have created what I thought would work but it does not :(...
Just getting back to this project.
Should I use my current code in an after update event of the combo box and add the code you listed? Or where should I use the code you list?
Private Sub cboBLOCK_Click()
Dim strReport As String 'Name of report to open.
Dim strField As String 'Name of your date field.
Dim strWhere As String 'Where condition for OpenReport.
strReport = "Block Summary Report"
strField = "BLOCK"
strWhere = "1=1 "...
Ah ok , yes I did try it and I get no errors yet I get no results either. I setup a combo box that relies on the table with the BLOCK field. The combo box has all the blocks on the selector that currently in the table. I created a command button with the code you provided and when I select a...
dhookom, if you could tell me that once more .. I can only see "You must set the strWhere value prior to using it in the OpenReport line. Also, if there are no other" that much.
Thanks
Well first of all this block form does not need to rely on date ranges it depends on block only. The control names or different blocks will be A1,A2,A3,A4,A5,A6, B1-B6, etc on through to the letter P. So there will be quite a few to choose from. So instead of dates to be entered I would like the...
Ok, so keep the same form just add this data to the already existing code? I need to report everything in Ax,Bx,Cx etc individually. It works, but it gives me all the blocks in the table instead of all the A's, B's, C's etc individually.
Well using http://members.iinet.net.au/~allenbrowne/casu-08.html is how I was using the date ranges. I would like to do the same with block. Just ask the user what block they want a report on.
Thanks
Hello again, another quick question that has come about. I have a field that is called "Block". The data is A1,A2,B1,B2,C1,C2 etc...on down the line. I really like the code earlier mentioned that enabled us to put in date ranges and was trying to figure out a way to do the same type of search...
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.