Search results for query: *

FancyPrairie I'm stepping through the code and am getting the results I am looking for using the example, varRecords = rs.GetRows(rs.RecordCount) I think I had a watch on the wrong variable ... I can't imagine that this wasn't working before. Thanks Blair

Specifying the amount of rows that you want will bring the specified amount ... pasing no argument, (), will return all rows, which is what I am using. I've looped through the record set to ensure that all of the records are there ... they are. I also tried: varRecords =...

I am using the following syntax to populate the array. varRecords = rs.GetRows() GetRows does not appear to return more than 1 record ... just a 1 dimensional array. I've looped through the recordset to check that there is data there. Maybe I am not referncing my array correctly. Should...

Nope ... not related to leap year ... I am just trying to caputre financial information, year by year. I think I am goin to use a number field ... let me know if you guys think I should do different. Thanks Blair

Ok, I understand ... using formatting, we can manipulate what we show and only show YYYY. Conversely, what mask would I use that would only permit the user to enter YYYY? I understand that I will store all aspects of the date YYYYMMDDSS, but I am only intereted in the YYYY. The conext is...

Is it possible to only store the year in a date field YYYY? If this is not possible I will us a number field and allow the user ot select from pulldowns on the form. Thanks in advance Blair ps I think I remember doing thiw with oracle using to_char function from sysdate into a char field...

When a user is at a given form, is it possible to disable scrolling through records with the trackwheel? Thanks Blair

When a user is at a given form, is it possible to disable scrolling through records with the trackwheel? Thanks Blair

Stephen Both of your examples highlight / select the first item in the list box. I tried them both. I found a simple explanation that works: Me.lstKeyProcess1.RowSource = Me.lstKeyProcess1.RowSource It also clears the list box ... I was doing the following (which I thought was efficient...

Tried a bunch of things and this was it!!! Thanks

That will select (highlight) the 0th entry in the listbox, but it does not bring focus to the top. I am guessing this will have something to do with referencing the (0) location as you suggested. I'll mess with .setfocus but I think that is in regards to the control from the perspective Let...

I have form with many unbound controls; they are used to generate a filter for the subform when a "Search" cmd button is pressed. I also have a "Clear" cmd button that will reset all of the unbound controls and refresh the subform. Everything is working fine. However, I have a couple of...

I have form with many unbound controls; they are used to generate a filter for the subform when a "Search" cmd button is pressed. I also have a "Clear" cmd button that will reset all of the unbound controls and refresh the subform. Everything is working fine. However, I have a couple of...

I am creating an Excel report via VBA in Access. Then, to remove the new line characters in the Excel file, I run: Cells.Replace What:=vbCr, Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False from Excel. Is it possible to run...

Better yet, is ther a way to run Cells.Replace What:=vbCr, Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False in the VBA in my Access database? I should be able to reference the excel file and do from there. Let me know what...

If I do it in a script, it will happen in the background without the user knowing. If I do it in VBA, the user has to engage and actively run the code. I am generating the excel spreadsheet through VBA in access ... in that same procedure, I would like to run a script that will do the same...

Is it possible to inisiate a bat file or wsh script in VBA? Thanks Blair

It was the Nulls - thanks

To remove funky newline characters after exporting data from Access, I have the following line of VBA. Cells.Replace What:=vbCr, Replacement:="", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False I am creating a command button and placing the...

In the select statment, I am trying to add up multiple fields and alias their sum as a new field. Here is a shorter simple example of my ugly fields names: Select (projects.[field1]+projects.[field2]+projects.[field3]) AS [A Sum] From projects The field "A Sum" is coming back blank. Any...