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 derfloh 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: *

  • Users: ckeener
  • Order by date
  1. ckeener

    Seperate Groups in a Listbox

    Thanks John and PH, Excellent ideas and help. This is a lot easier to read. Star each. Thanks again for your help.
  2. ckeener

    Seperate Groups in a Listbox

    ...[Clock In], tblTimeSheet.EndTime AS [Clock Out], tblTimeSheet.Hours FROM tblTimeSheet WHERE (((tblTimeSheet.Employee) Like [cmbEmployee].[value] & "*")) UNION SELECT DISTINCT "", tblTimeSheet.Date AS [Date],"","","","","" FROM tblTimeSheet ORDER BY tblTimeSheet.Date DESC; but I get an error...
  3. ckeener

    Seperate Groups in a Listbox

    Thanks spizofl, I actually already have the dates ordered the way that I want. My problem is figuring how to change the colors within the listbox based on date. It doesn't even have to be a color thing. Any way to be able to easily tell the dates apart. I really am not sure where to look up the...
  4. ckeener

    Seperate Groups in a Listbox

    Hello, I have a listbox with entries that include the date. I would like to be able to seperate the all the entries by date (ie. line, different font color, or something so that is is easy to tell when information chnages to another day) example: 4/25/06 John Brown Maintenance 5 hrs 4/25/06...
  5. ckeener

    Rounding numbers when I import

    Hi glickster, It is now working and I think I was mistaken in saying that the double did not work. When you say that you are importing to a new table do you mean that the table does not exist until you import? Or does the table already exist for you to be able to edit the field properties for...
  6. ckeener

    Search for records where there is only one

    Thank you PH, I was sure that it could not be too complicated and you showed the easiest way of getting what I needed. It makes perfect sense now. Thanks again, ckeener
  7. ckeener

    Search for records where there is only one

    Hello, I am trying to figure out how to write a query that would show me where there is only one record that matches a certain criteria. The records are session information and there should be a 'Begin' and an 'End' record. There is an ID that consists of a begintime and a connectionID but it...
  8. ckeener

    Calculating time problem

    ...Public Function CheckTime(Begin As Date, Duration As Long) As Date CheckTime = TimeSerial(Hour(Begin - Int(Duration \ 3600)), Minute(Begin), _ (Second(Begin) - (Duration - (Int(Duration \ 3600) * 3600)))) End Function Is there anything I can do to remedy this problem? Thanks
  9. ckeener

    Rounding numbers when I import

    Hi Roy, They are the default Long Integer. I changed it to a Double but there was no difference in the results. I guess I misunderstood the input mask reason. Thanks
  10. ckeener

    Rounding numbers when I import

    Yes Skip, The numbers are weather related and several of them do have decimals. for example: Text Doc Input Mask Table Value Temperature 88.3 ###.0 88.0 BarometerInchs 30.39 ###.00 30.00 I set the Input Mask in the tblWeather's design view...
  11. ckeener

    Rounding numbers when I import

    Thanks for your reply Leslie Right, that is what is confusing me. I have a pre-defined table in which each of the fields are configured. I have set the fields to be number data-types, set the decimal manually to whatever would be correct based on the text file, and set an input mask to force...
  12. ckeener

    Rounding numbers when I import

    I am trying to import a comma delimited text file, ex. 101,2005,194,1626,1029,0,0,88.3,64.28,97.8,88.3,74.7,14.22,18.54,216.3,14.22,230.1,30.39 but when I import it, the decimals are all removed. I tried setting the decimal places manually and setting an input mask but it still does not give...
  13. ckeener

    Year() problem

    Roy-Vidar, The first problem that you found was what was wrong with my code. Sometimes its hard to see the forest for the trees. Thanks here is the code listing corrected. Public Function IsDST(DateIn As String) As Boolean IsDST = False 'If (Year < 1950) Then Exit Function...
  14. ckeener

    Year() problem

    ...As Integer Dim CheckDay As Integer DateToView = StartDate MonthToView = 4 YearToView = Year(DateToView) DayToView = 1 * * * * If (DateToView > EndDate) Or (DateToView < BeginDate) Then IsDST = True End Function the line - YearToView = Year(DateToView) seems to...
  15. ckeener

    Library not registered??

    I am trying to run a vbs script on a Windows NT machine and it tells me that "The library is not registered". I have installed the latest version of the WSH 5.6 for NT. Has anyone run into something like this? (The same script runs on a Windows XP machine) Line 18 Char 3 This is the code...
  16. ckeener

    Conditional Changes in a report ?

    ...Song Artist CopyrightYear Comments A Tender Heart PCC 1987 SongLength CutNum Rating Album 03:14 44954 ** Wings As Eagles The way that I am trying to get it to print out is: 2 MS MS.PCC1.0C A Tender Heart PCC-Wings As Eagles 1987 03:14...
  17. ckeener

    Conditional Changes in a report ?

    Well, I can't change the current table setup and I really only need the album included on a few artists, Maybe 5 of the 500 or so that I have in my database. For the rest of the Songs on the list, having the Control Source of the textbox set to the artist really works just fine. It is just being...
  18. ckeener

    Conditional Changes in a report ?

    OK, I guess I could have given a little more info. The report has several pieces of information about each song on a playlist, such as the position of the song on the list, the tempo of the song, the title, rating, and the artist. However, if the artist is, say "PCC" or the "Joy Singers", then...
  19. ckeener

    Conditional Changes in a report ?

    I am trying to get a textbox to show something if the information in the box equals something. Specifically, if the artist is one of several, then show the artist name followed by the album name, else show only the artist name. Is there a way to do this?
  20. ckeener

    Importing a FoxPro Database Table into Access 2000

    I am trying to input a FoxPro Table into an Access 2000 database and I can't seem to be able to do this. Is there a reason why this will not work and a way to make it work properly?

Part and Inventory Search

Back
Top