Search results

Well, I'm using code in the VB editor in Access and it doesn't use "Me.email." This is what I am using that Mile sent me: Option Compare Database Option Explicit Private Sub cmdEmailSelected_Click() Dim var As Variant Dim strEmail As String For Each var In...

One more question... Thanks Mile!!!!!!! This is already up and working great here! One more question: Is there any way to change the "return" email address of the emails? For example, the user may choose and send the emails, however the office would like the reply address to be a certain...

We have a database where records are imported (via parsing from a text file) into a table and identified by customer. For example, we may receive information in for company X and then they are notified to send us some supporting documentation. This notification is completed manually by the user...

My boss brought me this problem: (this could have been avoided from the beginning but he didn't think it important, so here I am stuck with the issue) Anyway, there are 4 tables. Some field names are the same, some slightly different. I have to assemble all of the data into one table. I plan on...

I searched the archive but could not find this specific topic... There is a table and data entry is done straight into the table. (No form is used or wanted.) Date is automatically filled in with current date, operator types in an amount field and then there is a "batch" field. There may be...

I have a query that converts everything to strings in order to run a TransferText macro. Everything works great, and the data is exported into a comma delimited text file as it should. Here is the problem that's driving me crazy: The data base is on a network drive. When other users open the...

My VB skills are basic...I don't think I can handle the info on that link. I guess there's no other way? But thanks for replying.

Hey, I finally got the TransferText macro up and running with a button on the form. It pulls text fields from a query into a comma delimited file and saves as 'myfile.txt' which leads me to another question... The query is set to automatically pull records from the currrent data so all the user...

Hey I figured out that I was using an old specification name. Looks like it works now!!! THANKS...I'm sure you'll see more ?'s from me in the days to come!

OK this helps...I put the expressions in the select field and built the expressions. For example, I used: Cstr(Format(MyNumField, "########.00)) to convert the currency to text, is this correct? Anyway, then when I tried to run TransfrerText, I get the message "the MS jet database could not find...

Thanks for the comments but here's what's happening now: crosmil-As for the *.csv file, this is exporting it to an Excel spreadsheet. Pat-Concerning converting the numeric data to strings, I understand and that makes sense to get the quotes, but bear with me here, I am not an expert at this. I...

I am having problems exporting a query to a text file. I am not using any code or macros so far: Users enter info on a form (combination of text, numbers and date) Then there is a query that I need exported to a comma delimited text file. There are problems: 1)The Short Date is showing up in...