Search results

I have a query with a number of fields. One of those is a memo field and some contain quite a bit of text. Every time I try to export the data to Excel, the longer entries get truncated. I am then forced to manually copy/paste information from Access to Excel from the affected cells. Is...

I have a report with the following code (which works fine): Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Select Case Color Case "In-Progress (WHITE)" Me!Counter.BackColor = 16777215 Me!CC.BackColor = 16777215 Me!Number.ForeColor = 0 Me!CC.ForeColor = 0 Case "Non-FIR...

I would like to automatically import a table from database1 to database2 whenever someone opens database2. I want people to have the most current information but I do not want the databases linked for security reasons. I had created a macro to import the data, but database1 is password...

I would like to create a macro to import a table from database1 to database2. I would like this to occur each time someone opens database2. I created a transferdatabase macro in database2, however I get the error message "The database engine can't find <name>. Make sure it is a valid parameter...

Here is my problem. I have two tables. 1 has all my general information including a "QSE Number" (text field). Another table has the "QSE Number" (text) and "QSE Name" (text). I have "QSE Number" related in both tables. I have no problem creating a query that outputs all records who's due...

Every time I try to export or copy/paste records to excel or word, long memo fields get truncated. I can manually copy/paste the field without trouble. However, manually copying and pasting hundreds of records is not feasable. Does anyone know what is going on? As always, your help is...

I have a drop-down menu on a form. When an item is selected on the menu, I have code that automatically changes a value in another field. This works great, until I try to manually enter the item into the field without using the drop-down arrow. When this is done, the other field is not...

I have a crosstab query which counts when items are due by quarter/year. However, it lists the dates ascending by quarter, regardless of the year. Example: Q1 2001, Q1 2002, Q2 2001, etc. How do I make it sort the due dates properly? Here's what I have: Expr1: "Qtr " & Format([Due Date],"q...

I have a form in which depending on the status of and item I want the background and font color to change. I've entered the following code into the field and it works. However, it changes the color in that field for all the records not just the current one. How do I make the code update the...

I would like to create a report based on criteria selected on an unbound form. I have never tried this before. Can this be done and if so.... How do you link the report and the form together? Do you need to make a query based on the form first and then run a report off the query? As always...

I have a "Color" table with a field for color and a field for a number value. For example: Red 3 Yellow 4 White 6 etc.... When working on my form, which is associated with my main "Data" table, I have a combo box in which I select the color from this "Color" Table. How do I make Access...

Is it possible to choose a specific sort order, rather than simply ascending/descending?

I have a report that I would like to print on our color plotter. However, when I try to print it, Access tells me it cannot preview or print because the page size is greater than 22.75 inches. Is there a way around this?

I have two questions regarding charts in reports. 1. I have a chart with 5 different status categories. In the legend for the chart, items with zero values are not displayed. Is there a way to overide this and display the complete legend even if no value exist? 2. The categories for my...

I utlized the example code (see below)and it works great. One problem though, how would you make the colored field "grow" as necessary with the rest of the information in each record. For example, I have fields with one line of comments and some that take a quarter of the page on the report...