Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. demopro

    Datetime field

    ...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 me the total hours between created and modified, but the problem I am having is when the Time Taken...
  2. demopro

    Need advice onImport and Full Text Index

    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...
  3. demopro

    Report issue

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

    I have a general database design question.

    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.
  5. demopro

    I have a general database design question.

    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...
  6. demopro

    Help with code

    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?
  7. demopro

    Help with code

    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'
  8. demopro

    Rounding issue.

    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...
  9. demopro

    Rounding issue.

    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
  10. demopro

    Primary Key

    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.
  11. demopro

    Click event.

    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...
  12. demopro

    Click event.

    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...
  13. demopro

    Click event.

    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...
  14. demopro

    Click event.

    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...
  15. demopro

    Need some advice on Pivot.

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

    Need some advice on Pivot.

    ...next ActID could have 19 records to it and so on. This table will contain 100,000 to 150,000 records. Here is the code from the pivot: SELECT * FROM (SELECT ActID, DisplayField, ValueField FROM TableNAME) AS D PIVOT (MAX([ValueField]) FOR DisplayField IN ([Closed TCP Ports]...
  17. demopro

    Subtract two fields

    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...
  18. demopro

    Connection issue

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

    Connection issue

    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.
  20. demopro

    How to update Datagrid on Enter

    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...

Part and Inventory Search

Back
Top