Search results

Is it possible to get the last edited date for a specific field, not the whole record?

I have a multi-value field in a simple data entry form. There's a combo box with dropdown for entering and then I have the value field next to it to show all the current entries. It works fine until I filter on any field, then I get the #Name? error in the value field. Can I fix this?

I have a date field I'm using conditional formatting in. Some of the conditions depend on whether there's any data in another field. It was working fine using ISBlank, until I deleted data from that field in one of the records. Now the formatting doesn't work for that record. What's the "status"...

I need to add an autonumber to existing data in a particular order in Access 2007. I've set the autonumber field to long integer, increment, no duplicates. Before adding the autonumber field my table is sorted in the order I need the autonumbers to be assigned, starting with 1. However, the...

I'm trying to use a subform to enter records,and I have my relationships or something messed up. I have 3 tables: Orders with fields Order # and other details, Products,with item # and description, and sales, with order#, Item# and description. The subform works fine as long as the item number...

Is there any way to get the image of a report to another application? I can't use Print Screen because the page size is too big to get a readable copy. The exports to Word and Excel don't keep the formatting. I need an exact image of the report. The application I'm putting it in can use...

I have three ODBC tables linked to my database. When I use them in a query, the datasheet shows all the fields in the table, not just the ones I selected. None of my other linked tables (dbf and Excel do this).I'm now getting the error " Too many fields defined" when I run the query,and wonder...

I have a text box which is large enough to accomodate 3 lines of text if necessary. However,the word wrap doesn't always work right. On some records it cuts off (doesn't print)part of a word that should have been wrapped to the next line. On other records it works fine. Any ideas why this happens?

I have a combo box on a form that I use to filter the records. It's set up using ApplyFilter in a macro in the AfterUpdate property of the box, and the Filter property of the form itself is set to match what's in the box. My problem is that it works fine until the filter is removed to see all...

My form with a header and a tab control always opens slightly down from the top so that the tabs don't show. You have to use the scroll bar to see them. What's causing this? If I can get it to open right, I can get rid of the vertical scroll bar and have a little more room on the screen.

I have two subforms on separate pages of a tab control. They both contain information about the same records, there were just too many to put on one page. I'm linked OK to the main form, but what I need is for the two tabbed pages to show the same records. If I've had to scroll down the page on...

The postings I've tried to follow haven't worked, here's my scenario. I'm using Access 2000, if that makes a difference. I have a bound list box with job numbers in it. It's set to limit to list. I need to be able to add a new job number to the list AND the underlying table, and have it show up...

I have two tables. One has Job Number, County, Route. The other has Job Number, Cost. They are linked on the Job Number. On my form, I want to enter a Job number and have the County, Route display automatically from the table. Currently, the County,Rte data isn't displaying until after I close...

I have a combo box which is used to enter new data. However, sometimes the user accidentally changes data, when what they meant to do is filter by form. What's the best way avoid this and still be able to enter new data in the combo box? I've tried using a separate unbound combo, but it doesn't...

How can I make a report fill all of the available screen area? Maximizing doesn't work, there's always a gray border to the left and top. The report is on ledger paper, so I need to use every bit of screen space I can.

I have a report based on a table, not a query.I need a dialog box to filter it from. I found an example in the Developer's handbook, but can't get it to work for more than the first selection. Could someone check this to see what's wrong? I'm using 2000. Private Sub cmdPreview_Click() Dim...

I need a data entry combo box that pulls it's selections from the existing data (Appraiser) in the table and also allows the entry of a new name if necessary. I can't get it to work. I added DISTINCT to the select statement, but it makes the distinction on the Key field (Parcel #) instead of my...

I'm getting #Error on a subform total, and can't figure out the problem. I've checked everything listed in the Help topic, and it all seems OK. The field I'm totalling is a calculated field in the subform's query. If the record is marked as "Void" I don't want the amount included in the total...

I have a table with a Parcel # field which is set up as a text field because some numbers have a letter after them. (10A) In order for these to sort numerically in my form I created a field in my query using the Val Function. This makes it sort right in the query (1 is before 10). However, when...

I have a report that I originally set up with a particular sort order. I have since redesigned it to use with several different filters and sorts. I removed the sort from the underlying query, which looks fine when I look at it directly in datasheet view. It's unsorted. I set the report's Order...