Recent content by bigmerf

Thanks for you reply. Basically I just had to add a couple lines of code to move the value of the PC user to the field: Dim User as String User = Environ("UserName") me.FieldA = User Thanks again!

I created a database using Access 2003 and created a field called "UserName" where I read the user's login name to their PC and default this for new orders. I used the following to do this: =Environ("username") Now, when accessing this database using Access 2007 or later, I get #NAME in the...

I have a query of data for which contains an InvoiceID field. There are several instances where the InvoiceID field will be duplicated. In these instances, I want to create a custom column that will increment starting with 1 then 2 then 3 ans so on. Is there a function or anything that I...

Excellent! I appreciate the help. I was able to figure out a little on my own by just playing around and dabbling. Here is what I came up with (with real field names): Dim db As Database Dim rst As Recordset Dim EmailAdd As String Set db = CurrentDb() Set rst = db.OpenRecordset("Vendor...

Well, eventually I want to pass the value of this field to another table or perhaps to the To: section in an email that I will be sending out. I guess I want to start with the basics to be able to just capture the value of a field in a table by starting with the first record, displaying the...

I'm trying to use a Do...While loop (or possibly FOR loop) to loop through a table in my Access Database that will display a value of a specific field as it loops through the table. I have a table (TableA) with 3 fields: (Field1, Field2, Field3). When pressing a button, I want to loop through...

Well, I want to automate the process so that the user just clicks the button and an email is created AND sent automatically for each record in a table. It should pull the person's name and email address from the table specifically, but I need an email for each record.

Hello! I have an Access Database for which I have a table including names and email addresses. What I want to be able to do have the user click a button and generate an email for each record in the table and pull the email address from the appropriate field. Has anyone out there created any...

VERY NICE!!! That works great. Thanks for the link I appreciate it!

Could you give me an example? When using the following: Split ({?Description}) I get an error message stating "This array must be subscripted". Do I need to declare an array first then reference the parameter specifically? I'm not sure I understand the reference. Please advise. Thanks...

Hello! I have a report created in Crystal 9.0 and on this report, I have a parameter for which the user can enter in multiple values. If the user does in fact select more than one string value for the parameter, I would like to display all of the values accordingly. Is there a way to do this...

Great, that helps a great deal. Thanks for the help!

I have a Crystal Report (version 11), where I have the main report then a subreport embedded. I want to create a formula field that references data from the subreport directly. For instance, if the value in {FieldA} is empty or NULL on the subreport, then display the value in {FieldB} from the...

Yeah, just as I received your email response I was changing the data type of the parameter fields. You were correct in that they were setup as DateTime rather than just Date. I changed them to be just Date and it worked just fine. Sorry for the trouble but that you for your prompt response!

I'm writing a report that has date criteria and two parameters that the user enters in a begin and end date. I want the results on the report to display all records that fall within that date range, INCLUDING the dates that are entered. When selecting the "Between" option in the select expert...