Search results

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'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...

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'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...

I'm not sure what is causing this to happen. I have a simple database designed to collect notes pertaining to various issues. In the memo field everytime I input a new entry once I hit save it displays with <div> before the entry and <\div> after the entry. Any ideas as to what is causing...

I need a little help with some list boxes. The VBA I am using is supposed to display information from a query when you double click an entry. A form is supposed to pop up and let you edit the table the data originates in. The code for List20 works but the code for List6 pulls up a blank form...

I need a little help to finish this database off i uploaded. If you click on the reports button then final selection you can see that I have duplicates highlighted. What I need to do is highlight those two entries on other forms. If you hit the back button it takes you to another form (20...

Hello again, I am trying to query a like field on two table and make one table. The field is a simple check box and i need the query to return all values equal to -1 (checked). It is frustrating because I can see what i want for an end product I just can't figure out how to get...

I need a little help with some conditional formating. This may be a case of i've been staring at this database too long. As you can see in the attached files I have 2 reports. They both have conditional formating to show me duplicates on each report (they show in red). There is additional...

I'm having a case of writers block. I have a database that I upload data into and it randomly selects 20 items and 10 items creating a new table for each. So, I end up with two different tables of randomly selected items for a total of 30 items. I have reports for each table that highlight...

Hello All, I have run into hurtle on a project I am working. I am trying to create a query that will make a new table with the next 10 records from another table. let me back up. I have query A that creates table A which is a randomized version of two other combined tables A1 and A2. Then...