Search results

Thanks Pat. I'll have to keep that in mind so I don't cause more work for myself......

No problem. Hopefully that works out for you. Much better than doing the "button" thing.

Me.NameUnbound1 = Forms!FormName!ComboBoxHeading.column(2) Me.NameUnbound2= Forms!FormName!ComboBoxHeading.column(3) Me.NameUnbound3 = Forms!FormName!ComboBoxHeading.column(4) This is what is going in the AfterUpdate of the combo box field.

Yes, with me.txtname being the name of the unbound textboxes and the column corresponding the the position of the field in the combo box query grid. I start with column 2 because in my example, the autoID is column(0), and the Product Number or whatever is column(1). So you would end up with...

I'm assuming that you just want the infomation from the combo box viewed on the form and that you aren't needing to save it to any table.... I am going to post a db, I hope you can open it up. Basically, you have the combo box with all the fields you want to view, you have the column count...

What exactly is the button supposed to do?

Okay, I've attached a database. I tried it both with the field as a text field and also as a date/time field and it didn't seem to make any difference. That bit of code should work for you..... Compare with your database and see what's different. Make sure the name of the field you are...

Oooops. Sorry Chris. Guess I should have double checked that before posting. I'll try to look at that here in a little bit.... If anyone else has any ideas in the meantime.....

On the OnClick event of the button you could have something like Me.txtdate = Date() I think that should do it....

Pat, Thanks for your response. I think he's got it under control now.......

Pat, It's actually a little more complicated than that I think. He sent me the database yesterday right before I had to leave work, so I haven't really had any time to look at it. I took a brief peek this morning and there is a problem with structure/relationships. He's got primary keys set...

Hello. You can make a copy of your backend, and put it on your desktop and name it so that you know it's the testing copy. Then open up the copy of the front end where it shows the database window. Go to tools and select Linked Table Manager. Check the box for prompt for new location and check...

Yes, you can email it to me.....but I warn you, no garuntees that I can fix your problem..... :) That's why I was hoping you would be able to post it so that everyone would have a chance to look at it. Better chance of you getting your problem solved... You might make a copy and then delete...

Can you zip your database and post it here?

Create a query with your fields from you table. Under the field for the checkbox where is says "Criteria" type True to show items checked or False to show items not checked. Use this query as the source for your report. There is alot of information on setting criteria for queries in the MS Help...

Hello. Do you have any criteria in your query? It sounds like the records you entered in may be missing something which is why they aren't showing up. Can you post a db with the table and query so we can see exactly what's going on?

Hello. Do you just have Access tables created? You will probably want to create some forms for data entry and you can definately change colors, fonts, etc. on the form.

I don't know the answer, but I did a search on this forum for overflow and came up with a lot of threads. You will probably be able to find some help that way.....

Hello. I'm not sure that I completely understand what you mean by "Building a Lookup Table for the title of the Report...." Here is what we do when we need another report: If we have one that is already similar, we simply copy and paste the report, rename it, and then change the record...

Hello. Go to your form in design view and look at the Data tab on the Properties window. Look at your record source and add that field to the query you have running your form.....