Search results for query: *

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

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

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

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

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?

I am fairly new to VBScript and I am trying to write a script that will copy a file (AUTO.MON) to a specified folder and rename it (ASPLAY040317.txt) The 040317 part of the title would be for the file copied over on March 17, 2004. The code that I have is this. Dim FSO Set FSO =...

I am trying to get a report to open with information based on selection on my form, but when I try to set the record source, I get an error that I can't change the recordsource while the report is printing. Can this be done? This is my code that is called in the frmPrintLogs. Private Sub...

I want to take a number, divide it by 60 and save the whole number as one variable and the remainder as another variable...Does anyone know if there is a way to do this? ex. 838 / 60 = 13 with a remainder of 58 var1 = 13 var2 = 58 Can this be done with VB?

I have a question about DAO recordsets that is sort of baffling me. If anyone has run into this or it is a common problem, here is the problem. strSQL = "SELECT * FROM tblLogSongs WHERE LogRef = " & TempRef & _ "AND SongPosition = " & Position Set rst =...

This Code is giving me an error message (Error #91 - Object variable or With block variable not set). I can't find where I have not defined a variable. Can anyone else see offhand what is causing my problem? All the fields that I draw information from are not null but I don't know what is...

I probably have a dumb mistake that I just can't see, but whenever I try to update a date field in my table, it changes it to a time. For example, this code 'If there is an ApprovedDate in txtApprDate1, then insert 'it into the ApprovedDate field in tblLogs If Not...

If Not IsNull(Me.cboAppr) Then Appr = Me.cboAppr Else Appr = Null End If I am basically trying to use this as a backup process that runs on form load to back up the information in the form so that if the user wants to quit without saving the changes that may have been made, he can quit...

I have this Code that is supposed let me enter text into a textbox and it is supposed to search down the listbox (lstSongs) and go to the song I am typng in as I type it. It lets me type things into the textbox(txtSongSearch) but the listbox does not search down to the record I type into the...

I have a main switchboard form with a list box. The user needs to be able to click a command button to create a new record in a table with a new "SongRef" (the autonumber key for the table) Then it should open a "frmSongs" form that has a RecordSource of the...