Search results for query: *

Does anybody know where I might get some information on exporting a multi page report to Excel? A link or thread that can give me some idea's. I have a report of clients and a list of contacts for each client etc. Each client starts on a new page of the report. I want to export this report to...

I am trying to use the following with a Command Button to send a report via email. I want to use a where condition to open/send the report so that only the current record is on the report. Where can I insert the Criteria filter I wrote in the Send Object string? Private Sub cmdemail_Click() On...

The data come from a many part of a table. It is route stop times. Most have 1 AM Stop time and 1 PM Stop Time. Some have only 1 stop Time in the AM or PM. I am making labels and want both times in the same row. Right now I do the following, but I don't know how to add the WHERE part to this to...

I have a table that has Law Firm names in it like the following: Jones Jackson & Johnson etc... How can I have a text box on a report only show the first name (Jones). I would assume there is a way of identifying the space between and stopping it there, but I just don't have the experience to...

I have a report that prints route stops. I have it sorted by routes so that each route starts on a new page. What I would like to do is also have my page # start from "1" again on that new Route page. I use the following: ="Page " & [Page] & " of " & [Pages] to display page 1 of 8 etc... If...

I have a form that has a subform in datasheet view. There are times on each record in the subform. I would like to have a toggle button on the main form, or something better if suggested, that would filter the subform by am or pm. Basically it is mail runs, and I would like to be able to...

I have a form that has a separate Date and Time field. Under the date field's Before_Update event I wrote some simple code to not allow a future date. My question is how can I make sure the Date and Time fields together are not in the future? Say the date is today, but it's not 1:00 PM yet...

I have a main form that is the Date, Employee initials, dept., etc... A sub form that has the daily activities for them. How can I make sure there is at least one record in the sub form before saving the data in the main form?

How can I over ride the "Duplicate value in the primary key or index etc..." error, and add a custom error explaining in detail. I have a form that has a date that can never be duplicated. I want to tell users the following: "There is already an Activity Sheet for this date, please search by...

I'm sure this is simple, but I just can't figure it out... I have a sub form that is a Datasheet view. The caption for each field is the name of the text box. How do I change the caption without changing the name of the text box? By the way...the record source is from a Query.

I have a combo box that displays a lot of data to search when I am entering characters in it. I need a way to enter a few characters, then the combo drops down and displays only the items that begin with those characters. I'm hoping to speed things up a bit. For example...I have a Zip Code table...

Can somebody please tell me where I went wrong with this function. I feel like I am so close. Thanks in advance for any help you can provide. ="Phone: " & Format(DLookUp("[CustomersPhoneNumber]","tblCustomers","(&&&) &&&-&&&&"),"AccountNumber =...

I am trying to add my company name, address etc... to the top of a report. My company information isn't related to anything so I am trying to use the DLookUp function. However, I have never done DLookUp without criteria and I keep getting a syntex error. I have no problem when I use...

I use the following code to automatically number entities in a subForm. I keep getting the error "you can't assign a value to this object". It works great in an old Access '97 database I made 2 years ago and converted to Access 2000, but I am making another database with the same form...

I use the following code to create a unique ID on one of my databases. It currently works great. I have started a new database and want to use the same Module to create Unique ID numbers. I exported the Module, Table, Query, and Form that I use in my older database to my new database to create...

I have a form that has a Command Button to refresh the forms data. What I would like it to do is refresh each time I add a record to the subform. I thought maybe on the subforms After_Update event. What would be the best way to approach this? I thank you in advance for any input.

I have a form that uses DMax in the Before_Insert event of my form. The table is a network, but users all have their own copy of the front on their PC's. How can I requery the table right after the Order Number is generated. right now, If two users are trying to enter data at the same time they...

I have an Order form that has a subform of addresses. Each order has several addresses. I use the below code to send the order via email. I want the email text to display all the addresses in the subform, but so far I have only been able to get it to display the first address. Any help on this...

I have a situation where I would like to assign a tag to many text boxes and labels, but I also have tags assigned to some of the same text boxes already for other things. Is there a way to separate the tags in the tag property to create multiple tags. I have tried...

I have a public Function I use for Capitalizing the first Character in each work in a text box: Function CapitalizeFirst(Str) Dim Counter, StrLen As Integer Counter = 1 StrLen = Len(Trim(Str)) CapitalizeFirst = UCase(Mid(Str, 1, 1)) Do While Counter < StrLen Counter...