Recent content by demopro

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.