Search results

I am having a little problem explaining my problem. The sample db you posted still shows the same problem mine does. I ony want the each client to show once regardless of how many telephone numbers they have. The only number I want to show is their first one if they have more than one

I have a report that is based on Two tables. One is the Client table and another is a Telphone Table. The tables have a one to many relationship via the ClientID Field. I have built a small report that shows all of the clients and their telephone numbers. I have have the report so that it only...

Sorry forgot to mention I am using Access 2003

If I load the first bit of code in my splash screen for and then place the docmd.showtoolbar line in the onload event in my report should that not turn on my toolbar. My toolbar is called Print and the line i use is ... DoCmd.ShowToolbar "Print", acToolbarYes It did not turn on the toolbar

Ok this one is way beyond my skill set. In Form1 I have a Save button In Form Two there is a subform I need the value of a control on Form 2 to be set to the value of a field in the LAST record in the subform. If there are no records in the subform then the value needs to be null. I know this...

I have a control on report that gets it's data from a lookup table. There does not seem to be a Can Grow property on a combo box (Access 2003). I need this to be able to grow. Is there any way to do this.

Here is my senario I have a fairly large 2003 db with about 35 tables Every table has a numeric feild call ChnageID It is used to identify who was the last person to change that record I discovered that there were duplicate users in the user end of the db and thus there were different values...

Thankyou That worked perfectly

They are not related, however they do need to be deleted at the same time as it affects a number of reports. I am working with an existing db that was created by someone else and have to work within those parameters.

I need to delete the current records on two different forms. I need to be able to do that from only one of the forms because the second is hidden. I am drawing a blank

Oh my god That was so incredibly simple. I should have thought about that one myself. I teach people how to do a drag and drop copy using the control key. Thank you so very much. Here I am looking for a solution in code and it is a simple as copy and paste. Thanks again

Actually I am looking for just the opposite. I need the print dialogue box to appear

Ok I am uploading a sample db. Please check the report that has a custom toolbar called Print

It is a split db do you need both halves

II have no clue how to do that.

I have created a custom toolbar that will be displayed on all of my reports. I want to have a button that displays the print dialog box rather than simply sending the report to the default printer. I remember seeing a button that had the word print followed by three ... but it does not seem to...

Close. I finally figured it out. In my combo box's source I had included two fields. The bound column was not a date field hence the error. I reduced it to a single column, the one that is a date field and all works perfectly now. Many thanks for everyones help.

I have tried both of these methods. I keep getting the error message "The value you entered is not valid for this field. It is a date/Time field but I still keep getting this error. I am at a bit of a loss as to why.

Actually I did that. When I tried to use the lookup wizard in the table design, access would not allow a lookup on a date/time field. So then onmy form i created a combo box and then in the after update event set the value of the time field (EventStartTime) to the value of the Combo Box...

Actually I only need it from 9:00 Am to 4:00 PM. I do not know how to do this at all.