Search results for query: *

Hi there: Using Microsoft Access 2007, I have a form that has both a personal data (child) table/form component and a sub-form component that tracks a personal device (PD) that is being loaned to the child. I have 4 tables: 1. Family for the Child 2. Children (linked to Family using Family...

Hi: I need to write a formula that looks up multiple (ie: more than two) columns in a named data range. The trick is, I need to select specific rows where I know the fixed values of three to five of the columns. I know INDEX/MATCH can handle two column values when trying to locate specific...

Hello: This is a repost of my previous code. My apologies if things were unclear. I have used the indenting tool as well as cleaned things up and commented more extensively as to what I am trying to accomplish. I am running into the occasional sub-scripting error with this. I am not sure if...

Hello: I'm currently working on an Excel 2003 Spreadsheet with VBA. I'd like to do the following: 1. I have an array of data values for a range of cells. 2. I have a range of cell locations I'd like to copy the values to. 3. I'd like to check the array of data values so I can make sure that...

Hello: I'm experimenting with some Excel 2003 automation using variable ranges and selections from two different workbooks. One is a data file with about 25,000 rows, the other is a basic output file that is acting as a reporting template. Here's what I'd like it to do: I'm currently...

Hello: I'm really scratching my head on this one. I've been rewriting some code for my database but something that seemed to work fine before now apparently doesn't, or at least, not as I'd expect. Here's what I have: I have a form that populates certain fields in a query that is used as the...

Hello: Just a quickie this time :-) Was wondering if it is possible to manipulate the main Access database window. In particular, I'd like to be able to do the following: 1. Move the position of the Database Window to any coordinate. Not really important, but it would be a "nice to be able...

Hello again: Have a bit of a strange request, more for interest than anything else. I want to know if it is possible in any way to insert a piece of code into the VBA editor that will essentially instruct Access to do things if the user clicks on the Close button of the Database Window. I...

Hello: I have a bit of a tricky dilemma, and I'm not sure how easy this is to solve... Here's what I am working with: I have a form that executes a search of Client Names and File Numbers. The form record source is based on two tables that are linked in a 1-1 relationship based on a simple...

Hello: Been playing around for a bit using MS Access and Word 2000. I have a nice nifty form that is designed to help my office staff open and make simple changes to a Word document that acts as a template. The template is connected to a series of Access fields that are used as mail merge...

Hello: I've been using an Access form with a textbox to open a Word template. The idea was to have the user type in a value into the text box and then have that value replace the text at a pre-existing bookmark already set in the template file ahead of time... Here is a code sample. At the...

Hello all: I've been experimenting a bit with pseale's Mail Merge code (posted in FAQ #181-5088), and was wondering if: a) if anyone has tried pseale's solution, b) what references/libraries are needed to make it work, if necessary, c) if the directory/path functions are absolutely necessary...

Hello: Was wondering if anyone has attempted to override, bypass or replace the "inappropriate Input mask" error message that pops up in tables and forms when a user mis-enters information when using a strict input mask (ie: particularly when using "L" characters or "0" numbers, which MUST be...

Hello: I have a form that is designed to add new records to a table in my Access 2003/2000 data compatible database. My problem is that my OnCurrent event is triggering an Error #3021, "No Current Record" and while my error trap is catching it, I'd like to be able to handle it. The problem...

I would like a build a multi-level (more than 2) system of menus for Access 2003's switchboard for a database I am working on. I am using an existing switchboard setup with 4 items on the main switchboard and 7-8 items on the second level. However, I'd like to be able to add more layers...

Hello: Here's my problem: I have a form/sub-form with two table links, one to Names (the master form) and one to Addresses (sub-form). I have an "editing mode" button which allows edits and additions to the field data in the sub form, like so: in On_Click event code for EDIT MODE button...

Have a rather unusual problem: I need to programatically "trick" Crystal Reports 10 into thinking that individual field components are not present on the report (the equivalent would be "hiding" them in VB/Access) or to trick an entire section into thinking it is empty come processing time. Is...

Hello: I'm having some difficulties with handling a NoData event from a report, and I'm not entirely sure why I'm having them. 1. I have a form that grabs some info from a user, sets a query, and then opens my report. 2. I have some OnActivate code in the report which formats the report. 3...

Couple of hopefully quick form/DLookup questions: On a form, I'm attempting to handle user input for an ID table value using Access 2000. Here's the thing: I have a query that goes and looks up a valid ID number that can be input from the form. I've bound this query to a combo box, and...

Hello: I'm busy revamping a set of CF files I've inherited from another user. I'm using CF MX 6.1 as my server. It's in standalone mode, which might explain some things, don't know for sure. The files have a couple of datebases, some basic templates, output pages, and a login. Maybe no more...