Search results for query: *

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

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

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

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

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

Does anyone know why the Access .ldb file does not go away when an Access database is closed? Because of this, I am not able to repair and/or compact the database because it thinks a user has it open. I'm pretty sure that the user that it says has it open did not shut Access down improperly...

I need to pull the most recent data from a table based on one field. There can be many records for the same id, but each record has a date type field. I need to pull the most recent record out of this table per id. How can I do this? Thanks! jgarnick jgarnick@aol.com

I have a crosstab query that is based on a select query that combines two tables. I also have an append query that appends the results from the crosstab query to a table. The problem I am having is if a particular item that is being counted equals 0 (ie no records with that descrip)in the...

Is there a way to create an "autonumber" type field or expression but the catch is I need the field to remain the same three records in a row and then change on the 4th record and so on. Any ideas? Thanks! jgarnick jgarnick@aol.com

Does anyone know the easiest way to convert an adobe font(pdf) to a Word readable font (ttf)? I've searched the web for font converters and it's all too confusing to me! Thanks! jgarnick jgarnick@aol.com

I have a report that has two levels of grouping. I need each record to be on a separate page. The report sorts fine and prints each record on separate pages, but the first page is always blank. I have tried changing the "keep together" and "force new page" settings around...

I have a command button that selects all the data from a form, copies it to the clipboard and pastes it to the table (This is done to copy a record already in the table). The process works fine except when I close the form, I get the Access message about copying a large amount of data to the...

Is there a way to allow an Access database to only be opened once on a user's desktop? In other words, if they have a copy open, but minimized, I don't want them to open the database a second time. When they click on the shortcut to the database on their desktop, I would like their minimized...

I have a form that has a combo box that is based on a query with only one table. I have the following code behind the on-click, double-click and on change properties. I have not knowingly changed anything on this form, nor to the query/table that the combo box is based on. The query shows...

I have a form that has next and previous record command buttons on it so the user may scroll through a person's records. I also have 2 fields on the form that track who edits a record and when. In the after update property of the form, I set the fields to be equal to the user who is logged in...

I have a data entry form with an Add Record command button. There are certain instances when the new record's data should be the same as the previous record's data, with the exception of two or three fields. I tried adding a command button that would duplicate the record, but I got a pasting...

Why won't the dlookup statement below work? I keep getting an invalid use of null, yet the value is in the table. Is my syntax wrong? I tried troubleshooting using other fields in the table and they worked. App_period is a text box. Any ideas? Thanks- Dim rs As Recordset Dim strinput As...