Recent content by hollarindy

Alright My post-Stroke brain is letting me down. I figured out how to display the data I want with a cross-tab query however, there is soooo much data I need a way to prompt the user for what they want. I tried using the =Like [enter criteria] & "*", but cross-tab queries don't like that. Any...

I have exported the data from a table in my database into excel and created several pivot tables with the data. Is there a way to either incorporate the pivot tables into my database or recreate them in the database itself?

I have to admit thats not exactly what I had in mind, but I think it might work. I'll have to see if the users can find anything to complain about. My original intent was to have one form to input records (you might have seen it) and this form was intended to search for and view records edit...

Billmeye Ok, so I'm kind of back to the same problem I had before. I could get the form to display the information I wanted. I was using a query that required user input and you are using a drop down box. Thats all well and good. The problem I have is there isn't enough space to disply all...

I finally got a chance to see what you sent me. Thats not exactly what I had in mind but thats gets me a step closer to where I want to be. Thank you.

It should be bound. It's kind of a mess because I usually clean up my databases when I'm done. I configured it to open to the form I'm having issues with. Everything I'm working on with this form is from tblLateral. When the form opens it will prompt you twice for a label #. Another issue I'm...

You'll have to forgive me I'm not sure I understand. I've been having some memory issues lately so you may need to use crayons to explain it to me.

My control Source is =[tblLateral]![Procedure] My Row Source is SELECT [qryLateral_by Label].[Procedure] FROM [qryLateral_by Label]; I have tried several combinations of the two and nothing seems to work.

I mean I am using either a list or a text box. I have been playing with both and can't get either one to do what I want.

I am referencing it via the properties list under data and control source.

I'm using a sub form to display data form a table. The users wanted it display like a spread sheet. In order to get all the data to display on the same page I am trying to break some of the longer feilds out (i.e. comment field) and display them in a list/text box and not in the table with the...

What I meant by that bit is that I had an idea of creating a data input module for my Access databasethat would essentially accomplish the same thing as the spread sheet one of my counter parts already created. Yes, I am trying to launch a spacific Excel file from my Access database. I want...

Hopefully this is quick and easy. I cannot find code that will let me open an exsisting excel workbook. Instead of recreating the wheel for this project it is just easier if I can tie an exsisting excel product to my data base. I want the button to function like a hyper link to open the file...

I realized it might help more if you could see the how the formating is used. from the Main Menu click Reports. The problem lies in the conditional formating behind the Selected and Over Draw buttons. After further review it appears as though it is just the one entry (33K6-4-3176-1) that is...

I'm having an issue getting all of my conditional formating rules to run on my forms. For some reason it is only running the rule in the top position. I'm running different versions of this rule. Changing the field or table as needed to highlight duplicates in different colors. As you can see...