Search results for query: *

Greetings to all: Here is what we are wanting to do. When a specific mailbox user receives a message we would like the single attachment to automatically print to the default printer. Perhaps some code to notice a new message is in that user's folder then to automatically launch the...

Greetings to all, here is the scenario: We have efax's coming in to a specified user mailbox that all have attachments. THere is one attachment per email that is an image file. Here is what I was hoping for: When an email comes into this users mailbox I was wanting, through code or such to...

I have a table that stores date/time as:(example): 7/13/2004 2:06:04 AM This is how the date/time is stored. Im trying to build a query and want to pull only certain parts of that field. What I need is the date and the hour only...so I need: 7/13/2004 2AM Do I need to do a left or right of...

Anyone have any good scripts/.bat files to use to setup an unattended install of office 2000? Thank you.

I'm running queries in code using the DoCmd.openquery command(s) some are delete queries and some are appends. Basically everytime a query runs the dialog box pops up asking whether to run this query or not. My question is...in code is there any way I can autoselect 'yes' every time a message...

Easy question, what is the row limit for a table in access? Say I was running a make table query, what is the maximum number of rows a table in access supports.

Greetings everyone, I'm wanting to authenticate users via a form. I will have a form with a username and password fields for the user to enter their info. Then a command button to send the info. Anyone have experience doing this? I would think my first step would be to set up my 'users'...

I have to do this for 256 rows of numbers with similar formatting. I should probably use the LEFT or RIGHT function.

I have this number: 00034-1019-01 I want to remove the dashes. Do I use TRIM function, and if so could you supply the verbage? Thank you

Here is an example of the code I'm running: Dim stDocName As String 'run make table query stDocName = "qry_DeleteFrom_OH" DoCmd.OpenQuery stDocName, acNormal, acEdit stDocName = "qry_Append_Data" DoCmd.OpenQuery stDocName, acNormal, acEdit 'run make table...

How can i set up my access application so the user does NOT have to click yes/no for each step the code is trying to execute? For example, in code I have a table having a delete query run agaisnt it, then an append query adding to it. I want it so the yes button is automatically selected and...

Greetings, I ran a query on a table to check for duplicates as follows: SELECT tbl_Final.phone_num, Count(tbl_Final.phone_num) AS CountOfphone_num FROM tbl_Final GROUP BY tbl_Final.phone_num HAVING (((Count(tbl_Final.phone_num))>1)); The query will return two rows, phone_num and count of the...

Ok here, is a better example. Lets say I'm researching a duplicate phone number of:1111111111 Upon seaching my main query for the above phone number I find there are two numbers of 1111111111 with the rest of the fields as follows: phone_num customer_id last_name first_name 1111111111...

Ok here, is a better example. Lets say I'm researching a duplicate phone number of:1111111111 Upon seaching my main query for the above phone number I find there are two numbers of 4078913807 with the rest of the fields as follows: phone_num customer_id last_name first_name 1111111111...

Thank you. A example would be phone number: 9135772110. I will do a query on my main query to check for dupes and will find the above phone number as one of the dupes. If I copy that phone number and paste it in a search(Find) in my main query I will find the phone number and its dupe but if...

My question is this: Is there any way you use DISTINCT in a select query involving multiple fields and not get dupes? For example Im trying to run the following: SELECT DISTINCT tbl_OH.phone_num, tbl_OH.customer_id, tbl_OH.last_name, tbl_OH.first_name, tbl_OH.zip5, tbl_OH.Current...

Greetings, how can I have the results of a pass through query returned to ..say a local access query. SUch as: strSQL = "select * from customercaster where state = 'MA'" The above is passed to informix to run and how are the results returned to access? Can I store them in a query...

Im having a problem when working with linked tables in Informix. An exmaple would be trying to append data to a local access table from an linked informix table. If a user is in the particular table im trying to use I will get an ODBC error. Is there any way I can set access to 'dirty read'...

Im having a problem when working with linked tables in Informix. An exmaple would be trying to append data to a local access table from an linked informix table. If a user is in the particular table im trying to use I will get an ODBC error. Is there any way I can set access to 'dirty read'...

Thank you John, it all comes back now! That was it, setting the totals so I can do a count on the field. Thank you again!