Search results

How would one go about comparing 2 tables and finding those records that are not common to both tables? For instance, I have a table that I suspect some records have been accidently deleted by the user. I would like to compare that table to an older version of the table, and list only those...

Sorry, I'm using Access 2000.

Wayne: I tried both of your suggestions in the default value of the text box on the form, and when I enter a time it still defaults to AM. Obviously I'm doing something wrong. Thanks.

Wayne: I tried that in both the table and the form (set default value to what you said) and it gave me an error message in both places. Said the function 'Replace' was invalid.

Wayne, Sorry if my original post was not clear. I do not want to change any of the existing data. For all future entries, I want the default to be "PM" instead of "AM". Thanks.

I have a field in a table set to Date/Time. Is it possible to set the properties so that it always defaults to "PM"? In other words, if I enter "5:30" and then TAB, I always want it to be entered as "5:30 PM". Right now it appears to default to "AM". For this particular application, 90% of the...

Thanks to all who responded, Enabling the toolbar and changing the form to a query resolved the problem.

That's the problem. I can't get those buttons to appear in datasheet view.

I have developed an application that involves opening a form in datasheet view from a main menu. The form shows all the records from a table. I would like to be able to sort the records from this datasheet view. The option to "apply filter/sort" is available from the Records pulldown menu, but...

Thanks Chris. I realized that the memo field on the form had a "Can Grow" property but didn't remember seeing it in the properties of text box on the report. Seems to work fine.

I have a form with a memo field which is used to generate a report. The text that I have to enter into the memo field can be anywhere from 2 lines to five pages long. When it prints out on the report, I would like to have it appear as an expanding text box. For example if it was only a couple...

Bob: Sorry I didn't get back sooner. I was able to get it to work properly by summing the fields in the query. Thanks a bunch for all your help.

It's about a 4 meg file. Is it possible to attach that large of a file to a post in this forum? The problem I'm experiencing in the report is that previously, the sums of all the rows and columns worked correctly. Once I applied the Nz function to some fields in the query, the sums on the report...

Bob: When I set up the fields in the Query with the Nz function, then bring them into the report I can't sum them. For instance 5 + 1 sums to 51, rather than 6. I've tried changing all the fields to numeric but it didn't seem to make a difference.

Thanks Bob, That's what i was afraid of. would've been much simpler to do it in the report.

I'm trying to use the Nz function in a report to return in zero when a null value is encountered, like so, where I have a field in a tex box named SumofChildPhone: =Nz(SumofChildPhone,0) but it retruns an error. I have tried various combinations using brackets and qotations, but no luck. I have...

I'm designing a form based on a database of client callins. Whenever a client calls in, a new record is added to the database. There is a field (Client ID#) that up to this point has been manually entered. I cannot use autonumber for this field as one client may very well call in more than...

I have a list of clients in a query field and I want get a count of the number of unique clients. Some records have duplicate clients. Lets say there are a hundred records but only 50 unique clients. When I apply "unique values" in the query's properties, and then enter "Count" in the Sum field...

Thanks John, it worked like a charm.

Is it possible to print a report from a form so that it prints the current record only? In other words I have a form with a "print" command button, when I click on it I need it to print a report of the current record only. I've set up a print button on the form but it prints all records. Thanks.