Search results for query: *

I am trying to write a query (TSQL) in sql server to derive an imageurl for each employee using their empId. The images are saved as empId.gif (e.g. 0001.jpg) in this location /images/employeephotos/ How do i write the t-sql return a concantenated url of the location if the employee has an...

I have a value list combobox (cboShift) on my form with selections as "1st Shift";"2nd Shift";"3rd Shift" and a subform that should filter my records based on the shift selected on the mainform. My data fields in my query are [TimeStart], [Time Stop], [other fields]. I would like that e.g. when...

Hello friends, It is my first time programming in cgi/perl, and i need to do a quick task. I have 5 checkboxes for answer5. I want to receive the checked values in my checkboxes (into an array) and concatenante them so that $answer5 will be received as e.g. "Trades Date / Pre-settlement /...

Does anyone have any idea what i am doing wrong here? I am getting error 3078, Input or query not found. But my table exists in tht location. SQLstr12 = ("SET IDENTITY_INSERT statusCodes ON " & _ "INSERT INTO statusCodes (statusCode, statusDescription, statusSortOrder, shortStat) " & _ "SELECT...

My tables are sybase linked tables to my Access front end. I get this error whenever i click away from my mainform while my not-null fields (textboxes) have not been entered. So, i would like to put an error message "somewhere" that tells the user to fill in the necessary fields and highlight...

I am attaching this code to the onload event of a form bound to a table. And i want it to check a chkbox on this form if some data on this form (Text18, txtResource) exits in "another" tiny table ([Weekending], [sID]). Here is what i have at the onload event: On Error GoTo Err_ChkBox_Click...

I get this error when i check and uncheck my checkbox. The checkbox is located on a form and when it's checked it's supposed to feed data into a small table. When i click on it. I get this "Error 3061. Too few parameters expected 1" What could be wrong here? Private Sub...

I get this error when i check and uncheck my checkbox. The checkbox is located on a form and when it's checked it's supposed to feed data into a small table. When i click on it. I get this "Error 3061. Too few parameters expected 1" What could be wrong here? Private Sub...

I am using this code to import text file into excel. Can someone tell me what's wrong with my code? Why do i keep getting my customized msgbox error. Private Sub wkscmd_ImportData_Click() ' Local Variables Dim strPath As String, strFile As String Dim rngRaw As Range ' Get Data...

I've been struggling with this all day, and im at my fustration limit now. I am trying to pick up specific data from the following spreadsheet, I have imported from a text file. What's wrong with my vba? And why does my result sheet, come out blank? :( Please see code i got from 1wek4dep for a...

I am trying to retrieve records and populate the other fields in a form. I'd type in the requestnumber (pk) in a text field on a form bound to a table tblRequestTable, and it should populate the rest of the fields. But what this is doing is, it retrieves the record, and when i close it, it...

I have a form used for dataentry. A user places their request using this form (reservation form). I also want "a certain user" [i enable certain fields for this user cboApprove(yes/no)] to retrieve records and update using this same form. This user changes the Approve(yes/no) combo box to Yes...

TRANSFORM Max(" " & (Format([Start_Time] & [StartAM],"Medium Time") & " - " & Format([End_Time] & [EndAM],"Medium Time") & " " & [Program])) AS StartEndProgram SELECT RequestTable.RoomReserved FROM RequestTable GROUP BY RequestTable.RoomReserved, RequestTable.StartDate, RequestTable.EndDate...

i have database that allows a user to reserve a room for certain days throughout the week. The table RoomRequest contains the following data: DateReserved RoomReserved TimeStart TimeEnd Program The form for entering data works correctly, I cannot seem to figure out how to create a report to...

Conditional report-dependant on Day of week.... I am creating a calendar of events. the fields in my table includes Date TimeStart TimeEnd EventDescription etc Now I formatted the report with columsn as follows: Monday, Tuesday, Wednesday.. etc. I want Events for Monday to print under a...