Recent content by ckeener

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

Good Idea John! Thanks. I am still having a little trouble with it because is does not want to sort like you example. Here is the SQL: SELECT tblTimeSheet.AutoID, tblTimeSheet.Date AS [Date], tblTimeSheet.Employee AS Employee, tblTimeSheet.WorkArea AS [Work Area], tblTimeSheet.StartTime AS...

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

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

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

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

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

I am trying to calculate a time and this does not seem to calculate the hour. The table that I get the information from has an end time (ex. 7:10:31 AM) and a duration (in seconds - ex. 48610). I am attempting to calculate the start-time by subtracting the duration from the end time. The...

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

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

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

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

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

I have a piece of code that is giving me problems using the Year() function. I get an error telling me that an array was expected. I have looked at several examples and it appears I am using it correctly. This is a condensation of the code I am having problems with. Public Function IsDST(Year...

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