Search results for query: *

Thanks, Dreamboat, but they didn't work....re-install?? jgarnick jgarnick@aol.com

Thanks VMan, but what I was trying to say in my posting is that the Bitmap with Popup List choice is not listed, nor the Text with Popup list, TEXT is the ONLY choice. So my question is how do I get the Bitmap with Popup List choice back in the list (it was there before and something (?)...

Does anyone know why Follow up flags in Outlook would change from a picture of a flag to the words "Follow up"? If I go under "Format columns" the only option is text. How can I get the picture back?? Thanks! jgarnick jgarnick@aol.com

Glad I made you chuckle...... jgarnick jgarnick@aol.com

Thanks for your help---this didn't happen to me, someone else had the problem and asked me about it. They gave me a sample of what printed out. I was not in front of their computer or I might have noticed the problem-- I had never had it happen to me! jgarnick jgarnick@aol.com

Does anyone know why Word would add some file properties (?) to the end of every file saved? It allows you to delete this stuff but it adds it back every time you save a file. Below is an example of what it adds to the end of the file: Normal Normal Default Paragraph Font Default Paragraph...

Thanks Terry, I'll try that--I'm basically just trying to do what you can do in the database window when you click on the name or date modified (etc) bar. I'll give it a whirl-- jgarnick jgarnick@aol.com

I have a subform on a tab control. The subform has 6 or 7 fields. I'd like to be able to have the user click on the column heading bar in the subform and have the data sorted by that column. It's the equivalent of having the user highlight the column and then press the A-Z or Z-A icon in the...

I have a form with a field on it that has a field type of hyperlink. When you click on this field it brings you to a particular Excel file. That works fine, but I want to know if there is a way to keep Access maximized in the background instead of having minimized in the task bar, while the...

In the crosstab query's properties, list all the column headings that you want which will force a column even if there is no data. Then use the NZ function in your expressions. jgarnick jgarnick@aol.com

Thanks Omega--that worked changing the data type to Hyperlink--it's not terribly pretty clicking on a textbox, but it will do for now. But one more question--when you click on the link, it minimizes Access when it opens Word. Is there a way to leave Access maximized, so when user closes Word...

Thanks Omega, but I had already done everything you said. Each building does have a unique number. I right-clicked on the inventory OLE field in datasheet view and inserted the correct inventory file for each of the buildings that have one. But I guess my problem is getting the inventory...

I am new to OLE--I have a table of buildings and one of the fields is called inventory. I have made this field type OLE object. Only a couple of the buildings have inventory and the inventory lists are Word files. I would like to LINK these Word files to Access. I have a form that displays...

Ok, so I have figured out why it is displaying the last detail line. I have fields on the main report in the detail section and I have the subreport placed on top of the fields also in the detail section of the main report. I strategically lined up the fields on the subreport so that they...

Thanks Doug--all that makes sense, but when I do exactly what you said above, the sum works fine on the subreport, but it does not display correctly on the report. It displays the number from the last line of the detail ??? I definitely have the correct field name in my expression--it's...

I have a report with a subreport. I need to sum the data on the subreport and put the total on the report. Is there a way to reference the fields on the subreport in an expression? I haven't been successful using the expression builder. Thanks- jgarnick jgarnick@aol.com

I have a form with a combo box that is used to lookup names. After looking up several names in a row and sometimes editing their other fields on the form, I get a run-time error 2105 error saying I can't go to the specified record, I may be at the end of a recordset. I have the code below on...

I ended up using a subreport and having the report based on one crosstab and the subreport the other. I laid the subreport over the fields in the report because I needed the data to be side by side. A little bit of clean up, but it works except for one small problem...... Is there a way to...

I have a make table query that creates table A. I then have two different crosstab queries based table A. I need to create a report based on the data in both of these crosstab queries. Is this possible and how? I get an error message using the wizard because both crosstabs are based on the...

Thanks Mike, I will keep that in mind for the next time! However, the machine that it said had the database still open, did not shut the database down improperly ?? jgarnick jgarnick@aol.com