Recent content by nelslynn

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

Thanks, but I get a error message "Join is not supported". I'm using VB.NET

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

Can anyone elaborate on this problem? I am having a similar problem with Access 2000 on XP OS. The problems include: - "#name?" in fields where the data source includes the Trim function. - "#Name?" when using the Date() function. When I take out the Trim and change Date() to Now()...

Any clues as to what that function would look like? Sorry, not up to snuff on my VBA. Any help would be appreciated!

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 want to requery only the combobox after changing the value in the combo box. In order to requery the combo box to reflect the correct values, I need to save the record that I am currently on. cboBox afterUpdate >> save the record, then requery the combobox, then move to the next field of the...

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

Thanks for the suggestion, but 13 hours converts to 1:00PM... I need it to stay in the format of 13:00:22. Anyone else? Also, any suggestions on the second part of my first post? Thanks.

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

Could you please elaborate? Why would it work when all fields are entered but not when one field is missing? Wouldn't that indicate that my quotes are correct?

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 & "', " &...

Another problem First of all thanks for the reply, but I discovered I need to go about this in a different way. First of all, I have a combo box of names at the top of the main form that is linked to the subform. The subForm_Load event will trigger on the first record, but when I change the...

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