Search results

I'm appending records from an Access backend to a SQL Server back end. I have a date field in an Access table as a Date (format: mm/dd/yyyy). How do I convert this to a Long Date so I can insert it in the SQL Server database field that has a Long Date (Date/Time) format. As I do the INSERT...

I need a query that will provide the names of two employees from the employee Table where the employee ID's are in another table. I am doing this in code, so the query cannot query another query. EmployeeTable: empID, empFName, empLName TeamTable: empID1, empID2 Thanks

Is there a way to create an XML file based on a stored Access query? I would like to apply a XSL Style sheet to this XML file. I have tried the asPersistXML function and it produces an XML page that is confusing... how do you create an XSL Style sheet from this?? Both the XML and XSL files will...

I have a table with fields: nameID, time, place, division I would like to query and add another field (division place) that will assign a number 1...n according to division and place. Sample rows: nameID | time | place | division | newField 100 | 3:00 | 1 | Male | 1 101...

I have two questions: Immediately after a combo box update I need to requery the combo box, but cannot until the record is saved and the record will not be save until I move to the next record... I do not want to move to the next record, but to the next field. Second question: Also regarding a...

I have a text field containing an elapse time on a report... i.e. 12:30:20 (12 hours 30 minutes and 20 seconds). I want to sort on this field from fastest time to slowest, however, it is a text field and therefore sorts like this... 11:00:00, 12:30:20, 12:00:00, 9:00:00. also, is there a way to...

I'm trying to do an INSERT with the following SQL: strSql = "INSERT INTO tbl_YearSpecific (yYear, yCompetitorID, yBibNum, yTShirtSize, yRaceDayAge, yRelayPartnerID, rBibNum, rTShirtSize, yDivisionID, yPaid, yPlaceOverall, yTotalTime)" strSql = strSql & " VALUES ('" & Me.txtYear & "', " &...

Sorry, I have looked for hours on this forum and cannot figure out what is going on. Why do I get an error of "Too few Parameters, expecting 2" My query "qryRecCt" (saved as an Access query) queries a recordset based on a form that is open and clearly gives the parameters needed >>...

Here is what I'm working with... tbl_YrSpecific: yrSpecID(PK), competitorID, year, time, place tbl_Relay: yrSpecID(FK), competitorID, bibNo I have a database that stores competitors in a race. The race has individual racers and relay racers with two competitors per relay team. I want to get...

I have a query that has provided the lapse time between two time periods... i.e. the time between 5:00:10 AM and 6:00:00 AM is 00:59:50. I have 10 lapse times that I need to add. FOR EXAMPLE: The result of my query is: -----s1------------s2------------s3-------------s4 ..... s10...

I am exporting multiple queries to an Excel workbook (on query on each excel sheet). My queries are based on a 'View' in SQL server2000. I am using a DateDiff in my SQL for my 'view/table' and get a valid number in the view. When I do the export to Excel, the column is showing up as a Date! I...

I have a form that opens another form (frm2)based on three fields from (frm1). frm2 is based on a stored query and produces 1-5 records in a list. I want to add a field where I can input a value for one particular record. When I try to do this I get the same value for every record found on frm2...

I have form2 that I am opening from a mainform. What goes on form2 depends on a query (based on a combobox). I want to open this form with this query. Right now I have a Public Sub to open Form2. I am sending it the query as the critera for opening the Form2. And that is where I am. I tried...

I am trying to match two stock transactions, both transNo's come from tblTransactions. I want to update the tblClosedTrans with the buy trans# and the selltran#. The query I have set up doesn't work (too few parameters) Here is what I have... INSERT INTO tblClosedTrans ( lOpenTransNo...

I open a form that queries a set of records and lists them from the main form From a main form (Form1), I open another form (form2)that queries a set of records, each record has 5 fields. How do I do say "if the check box in the 3rd record on Form2 is check, take a value in another field of the...

I have a subform based on a query. I want to only show the subform on the mainform when there are records that meet the query results. How can I do this. I am working in VBA at a change event for a combo box. I have: Case select cboTrans Case "B" sfrm.requery If (there are...

PLEASE, can anyone help!!! How do you assign a unbound text box on a form to a single value a query provides. I am doing this in the textbox's GotFocus event. THink I need the VBA code. Thanks.

I am trying to set what is in a subform (from a query), to a recordset and am useing the following... Dim cnn As ADODB.Connection Dim rs As ADODB.Recordset Dim qry As String Set cnn = CurrentProject.Connection Set rs = Me.sfrmOpenTransactions.Form.RecordsetClone I'm getting a type mismatch...

First of all, thank for all help regarding my previous posts... they have been very helpful. Here's my next problem... I have a query the involves 3 linked tables so I cannot perform updates on a record in one of the tables. Darn! Is there a way to somehow mark the records I want to change...

On my main form I have three txt/cbo boxes that are used as critera for the subform The subform is toggled to display after I enter the final txt box. How do I get the subform to display this query of records. I have written a query that works great, just need to incorperate it into the subform...