Search results

I changed it to Private Sub Command80_Click() n = 1 Do Until n = Me.Text65.Value Me.Controls ("Text") & n.Visible = True n = n + 1 Loop End Sub and that didn't work. I also took out "controls" and that didn't work either. Any other suggestions?

For-Next Loop I have a For-Next loop that I am using to make the correct number of fields to appear. I have a textbox65 and textboxes 1 through 10. Here is my code: for n = 1 to me.text65 me.text(n).visible=true next n Can someone help me fix this code please? I would be eternally greatful!

It makes complete sense. Thank you so much for the help and I will give that a try right now. Thanks again!!!

I have a form setup so that my users can define the filters they want on their report which is just a query. I am having some trouble though because I am not sure how to setup the filter so that the user can choose the order in which they want the query sorted. I was using combo boxes with field...

I don't have a table name to put in there. This filter form is using unbound combo boxes. I have simply typed the values in that match the names of the fields that I would like to sort. Is there a better way I should do this? I am very open to suggestions at this point. I tried putting in the...

I am using a form to allow the user to choose the sort and filter of the query. I have seven different fields that I need to allow them to sort by and I also need to allow them to pick the order in which they sort. This is the "Order By" code I am using but it is not working...can anyone fix...

I feel quite ignorant! Thank you for the help!!

Thank you very much for the reply but I had the combo box column width set at .5";.5" I have tried numerous changes to the combo box wondering if that was the issue, but no matter what I do the 2nd column won't show.

I have a combo box that pulls from a union query that only has 2 columns. I set the bound column as 2 because I want the 2nd column to show in the field. No matter what I do it will only show the first column. Please advise.

I have a table in another db that I have to extract data from and work with it in Access. The issue is that one table is poorly constructed so I need to take 7 fields from that table and make them one field. Such as: field 1=106 field 2=107 field 3=108 I really need this to have all...

Thank you so much for the quick reply. Is there any way to show the actual date of that first day of the week?

I have a report that the user specifies the date, but at the top of the report I would like to display the first day of the week that the user specified. So if the user chose 9/2/03 the label on the top of the report would show 9/1/03 because that was the first day of the week. Is this possible?

Well, I actually had to end up correcting a lot of user errors in order to get the queries to work correctly. Once the data was correct a regular query worked great. Thanks for your reply.

Oops..sorry, I meant on a DB on our Unix server. I realized that and the problem is being researched by the DB company. Thanks for the correction.

I got the same error message when I try to do that union as well. There is something wrong with the table definitions in our Unix database from what I have been told, so the union won't work until it is fixed.

Well, I never could get it to work. Finally called the support staff of the database I am pulling the information out of and they are having trouble with that as well. So they are working on it. Thanks for all your help, Sam

Great idea...I will try that. Thanks!!!

I really appreciate all your suggestions though. Thanks, Sam

Unfortunately putting union and select together didn't work. I am able to run them seperately, but not as a union.

I believe they are just normal queries on the table. Below is the sql that I am using. SELECT PUBLIC_RMF008.RM08CS, PUBLIC_RMF008.RM08LT, PUBLIC_RMF008.RM08TY, PUBLIC_RMF008.RM08DT, PUBLIC_RMF008.RM08RF, Count(PUBLIC_RMF008.RM08SQ) AS CountOfRM08SQ, PUBLIC_RMF008.RM08CM, PUBLIC_RMF008.RM08NC...