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.

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

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

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

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

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

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

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

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?