Search results for query: *

Hello, I have two datetime fields (created, modified) and a calculated field (Time Taken). The Time Taken field is the difference between the Modified and Created fields. The code I am using is below. =IF(NOT(ISBLANK([Modified])),([Modified]-[Created])*24,0) This works fine for me in giving...

I am using SQL 2005 and need advice on how best to implement a requirement that was dropped on my desk today. Issue #1. I have to import a flat file (4 GB to 5 GB) 10 million records. I run into issues with the database timing out. I was able to import 500,000 rec at a time. Issue #2. This...

I created a few simple reports from Access 2007 and for some reason it will not export into Excel. What am I doing wrong?

Thanks for your help. I was looking to deep at this and had the correct answer all along. I was looking at this as a roll up on time for the day when by using the typhr column it is a detail view. Thanks again.

I am trying to create a time keeping system and need to ask how to design a table. I created a table called timecard with these fields: Day1 = firstday of the two week pay period, pped = pay period, typhr = type of hour (sick, vacation...) Auto_id (PK) int Emp_id (FK) int Pped...

I read somewhere that I could put in sql commands into a file of its own under the file extension of .prs Is there any performance difference between these options?

I have some SQL code that I need to put into a dBase IV code and dont know how. Here is the SQl code: SELECT jono, SUBSTRING(MRRN, 3,6) as MRRN, MRRN, COST FROM Comled WHERE(JONO NOT LIKE SUBSTRING(MRRN, 3,6) and jono <> 'YY1122' and Jono <> 'PPq211'

Thanks for the quick response. Your suggestions work well but if the dollar amount is greater than the 16,683.43 that I gave in my example it does not work. My fault. I found another solution to this. I went to format cells and then to numbers, custom and typed this in...

I have a column that is in this format: 16,683.43 I need to put this in a Thousand format such as, 16.7 in place of 16,683.43 Any thought on how I can do this. Thanks, Demopro

Can dBase have a PK? I need to have just one column set as a PK to ensure that duplicate data does not happen. I am using dBase4.

Man, I forgot about checking the EULA. I should take a look at it before I begin this process. I will use a timer to launch this process every eight hours and will be only active for about a minute each time. This should not be to complicated. Now, I am all fired up and ready to start...

Thank God I am not the only one that has run into this problem. Ha, ha, ha. I have not played Horizons but will take a look at it. I am playing BiteFight.org it is a fun little game that I am hooked on. I don’t know why, but I am. Thanks for the tip on sendKeys I will definitely use this...

Qik3Coder, Thanks for the response. I know this may look like I am trying to do something on the evil side but I’m not. I didn’t mention what I was really trying to do because it is real geeky, to say the least. I play on online game where I need to put my online character to work every eight...

Hello, I need to write an app that can automate a task of clicking on a few buttons on several web pages from someone else’s website. This is not malicious in any way. It will help me update some information on a timely manner. An example would be the same as clicking on a button in a menu...

AlexCuse, thanks for the advice but I need to put this into a table. Sorry, I didn’t mention it before.

Hello, I am stuck on trying to figure out the best solution to the issue below. Any thoughts on this would be greatly appreciated. I have solved this by using a pivot (code at bottom) but want to see if there is another way to do it that is more efficient. This data resides in MSSQL 2005...

Hello, I am running an update command on two columns in a table and have stumbled onto a problem. How can I subtract two fields from each other when the first field is a negative and the second a positive. EX: -1200.02 – (+2200.02) = (-3400.04) I cannot change the position of these fields...

The user will always be asked for the password and Userid? Is there a way I can automate this process using code?

Does Crystal Reports 10 store the password field of the database connection string? I cannot find it and when I try and use a report it asks me for the password. Once, I enter the password I can view the report.

Hello, I have a datagrid and need to know how to update the data in it that the user changes. I can do it with the code below on close of the form, but need to know how to do it lets say, after they hit the Enter key or as the data changes. Here is my code for on close. Private Sub...