Search results for query: *

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

Duanne, This is a Sample Record from the qryLogSongPrint that is the recordsource of the rptPrintLog LogRef SongRef SongPosition Tempo NewStationCode 211 21434 2 MS MS PCC1.0C Song Artist CopyrightYear Comments A Tender Heart PCC...

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

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

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?

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?