Search results for query: *

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

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

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

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

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

In oracle you can do an outer join by adding a (+) to the field that is not required to have a value. How do you do the same in MS SQL. Here is an example where clause in oracle that would work: Where table1.record_id = table2.record_id and table1.foriegn_key = table3.record_id (+) Thanks...

I have created an automated process to export Access queries into .xls files. The problem I am running into is the fields that have character returns come over with an extraneous character in Excel. The unfavorable ASCI (13) shows up like a small box and I can correct it by using the ASCI (10)...

When exporting a table to an Excel file, there are problems with certain characters. When there is a newline in an Access field, a character that looks like some sort of wingding comes over in its place. Does anyone know of any ways to avoid this or correct it once in Excel? FYI: In Excel...

Is it possible to use VBA to export a query to an Excel file? Is it possible to use VBA to update and existing Excel file? Thanks Blair

How Do Set The Page Layout For "Legal Paper" This has to be simple, but I can't figure it out. Thanks Blair

When I convert an Access report to Word (rtf), I lose the picture that I put in the report. Is it possible to have pictures make the conversion over to Word (rtf)? Thanks in advance Blair

Is it possible to display a checkbox as "Yes" or "No" on a report? Null (if applicable) would also display "No" Thanks in advance Blair

I am creating a report based on a dynamic query. I get a recordset of all records on my main table and loop through it to create 1 report.rtf file for each record. With each iteration I set the qryDef.Sql. This works, but I think it is cumbersome to have this large sql string. It would be...

Quite often in in my reports (usually when showing lists), a field will begin on a page and run to another. Is it possible to force a page break when the field is going to be displayed on > than 1 page? Thanks in advance Blair

When a boolean field is declared, is there a benefit to one Display Control option over the others (check box, text box or combo box)? I am not a fan of controls on tables and it seems like Acess is in favor of it when it comes to booleans. I understand that regardless of which option, it is...