Search results for query: *

Hello: I have an access 2003 program that reads a sql database, this is accomplished using ODBC connection and produces a very complex report. This report has been running for several years with no problems. Randomly I get an error stating "Network error" or "disk error". I have plently of...

I will try get access 2003 and test it see if I get the same results.

If user 4 adds an entry to the database. User 1-3 cannot see it until they log off access and logs back in again. If User 1-3 make an entry user 4 cannot see their entry until he logs off access and logs back on again. Users 1-3 if they make an entry all three can see their entries without...

Hello: Here is the problem: I have 4 users that use access 97 on an xp system. When the 4th users adds info to their access database the other three do not see the entries. When users 1-3 add info to their database the 4th users does not see the entries. All four are accessing the same...

Question: Is there a way using ms sql server that I can query a sybase database. Are there settings that I need on sql server that I need to set to point to the sybase database??? so I can use ms query analyzer? Thanks for any ideas.

Question: Can a sybase database be queried using ms sql server. Are there settings that I need to enter on the sybase side or ms sql server side??? Thanks for any ideas.

Hello there: How did you get your printer to work. I have a similar situation with my xp host and xp remotes and pcanywhere 10.0.?? The dos application prints to lpt1. Before on win95 and pcanywhere 9.0 no problems printing. Now it's a different story. Thanks for any ideas epnico

Thanks for the information. Your ideas are good ones. Thanks again.

Sorry about that. eemploy table has a status field and the leave of absence field. Also in the eemploy table we have a date beginning and ending date of the status. So we would have for epnico if he came back from loa status two records. example: username status date beginning ending...

Hello everyone: I need to answer this if else question in a sql query: if status has changed from leave of absence (loa) to active what is the enddate of the leave of absence (loa). My MS sql database contains two table ebase and eemploy there is one record for every employee in ebase and...

CASE WHEN EETERMDATE IS NULL THEN ' ' ELSE CONVERT(CHAR(10),EETERMDATE,101) END as TerminationDate, --(28) In the statement above the following if statement is coded if eetermdate is null then blanks else convert eetermdate to a date format What if I wanted to code the...

Thanks for your reply, in looking at the specs for this field I found out that it is monetary field? What is your opinion on this type. Thanks for your ideas

I missed one Paren. you are right I just copied it wrong from the sql query this is it round(((emhoursperpay * 24.00)/52.00),2) as hoursworkedperweek The formula is a payroll formula to calculate hours worked per week given hours per pay. My main goal is to round to two decimal digits. Maybe...

Hello Everyone: Here is my problem I have a field that is numeric and the contents are 86.68000000000000007 field name is emhoursperpay. In order to find hours worked per week my formula is the following round(((emhoursperpay * 24.00/52.00),2) as hoursworkedperweek The formula above...

Thanks for the ideas it pointed me in the right direction the syntax is the following that worked for me on MS SQL 2000. CONVERT(CHAR(10),EEICWDATAADJUSTED,101) I get the proper date in mm/dd/yyyy. Thanks guys.

Thanks for the info. But in my MS SQL 2000 query analyzer I don't find anything in ref. to_char? I'm extracting info for a HR database and creating a delimited output file. So this date field has to have this format mm/dd/yyyy. Thanks. Rick:

Hello Everyone: Is there a way in sql when you have a field that has date time stamp to extract the mmddyyyy and formatted into mm/dd/yyyy and forget about the time area? Any ideas are welcome. Thanks. Rick

Hello Everyone: Short question how do I copy a char array to another char array or swap elements from one array to another. I tried to use pointers but with no success. My array's are defined as alphadata [10] [15]. Any ideas are welcomed. Thanks.

I have a small project and I do not know where to start Here are the specs. A program that will allow the user to enter a shopping list of up to ten items. The user will enter the item name, qty, and aisle # where the item is located. The user will then be able to select either of two options...

Thanks for your ideas grnzbra and nvijayk. Can you expand your idea as to a control box since start date and end date in the query in the control source do they show up?