Search results

I have a reference to the external application's dll. How do I write an event handler in Access VBA to be fired when that external application generates an event?

Given a table with 3 fields for people, where each person can be either Curly, Lary or Moe, and 3 fields for chairs, where each chair can be either Blue, Red or Green. Here are two such records: Per1 Per2 Per3 Per1_Chair Per2_Chair Per3_Chair Curly Lary Moe Blue Green Red Lary Curly Moe Red...

I have a list of resistors which I want to ensure that each unique value has only one corresponding part number. Here, for example: Reference Value PartNumber R1 100 Z1 R10 800 Z5 R2 120 Z2 R3 100 Z11 R4 300 Z3 R5 150 Z4 R6 800 Z5 R7 600 Z6 R8 100 Z1 R9 100 Z1 we see that the value...

It seems to me that one join-related failure in an Access 2003 query is when one of the fields involved in the join has null values. One way this happens is if an outer join is followed by an inner join. For example "F LEFT JOIN G" will produce full field values for both F and G fields, only in...

The # character in a hyperlink is used to separate hyperlink parts. Here is a case when I do NOT want this character to do the separation: a network file where the # character is part of the filename: k:\data\someFile#ref02.doc. How can I put this URL into a hyperlink field in a table and NOT...

The above great article on the Allen Browne site has one problem. I don't know if someone has posted it before but if the lookup is text rather than numeric then search is not found. Here is a modified version: Sub Form_Load() Dim varID As Variant Dim searchString As String varID =...

I have a table with hyperlinks, vewed as a pivot table. According to Microsoft: http://office.microsoft.com/en-us/access/HP030841011033.aspx., I should be able to jump to the link. But it doesn't work. Any ideas? Thanks

Given a table field that is a hyperlink type. I need an Update Query to set all records of that table so that the Displayed Value part of the hyperlink field (not the Address part) is set to a particular value. Any ideas how? Thanks.

I have a simple Family table: PersonID Name ParentID where, in the case of a child, its ParentID contains the PersonID of its parent. In the Relataionships window I put two such tables, Family and Family_1 and I joined Family.ParentID to Family_1.PersonID. I set referential integrity...

Does anyone have a function that, when called from a query, will return the name of that query? I need this for the following reason: I have about 20 queries that I run sequentially, each one adding its own records to a single common target table. If I have one column that shows the name of the...

When I run this query I want a new column to show the name of this query. Any idea how I can do this?

Is there a way, similar to Excel's "personal.xls", to put all my reuseable Access code into one central module? Thanks in advance.

I am a beginner with aggregate functions. I have two tables, one describing parts, and one describing assemblies that use those parts: tblParts show all the part descriptions, including fldPartNumber. tlbWhereUsed shows zero or more fldAssemblyNumber records for each fldPartNumber. I want a...

When I export my report to rtf format Access crashes with the familiar "Microsoft Access has encounterd a problem and needs to close" message. Any ideas? Thanks in advance

How do I determine which forms, reports or other queries use a specific query in my entire database? Thanks in advance.

I want to copy the entire window of the currently-displayed form to the clipboard as a picture. Then I can paste it into my Word document. When I press <Alt><Print Scrn> I get the entire Access application rather than just the form window that I want. Any suggestions? Thanks in advance.

I have a table, called TableData with several records. The form to view this table is called FormData which is formatted to show only one record of TableData. Another table, TableConfig, has only one record and is used to shows my current configuration. One field, FieldDataCurrent, is the ID of...

I can't put a hyperlink field into a crosstab query. The Crosstab row is set to Row Heading. If I set the Total row to Group By, then I get nonsense. If I set the Total row to First then I get a text version of the address, with the character # at the beginning and end. Any ideas?

I want a column in the query to be used for sorting but it depends on the type of data. In preparing to use my tables, I used a simple conditional formula: sortField: IIf(IsNumeric("123"),CDbl("123"),"123") Given that the test condition discovered that the data is numeric, the result is the...

Background to question: Here are 4 Tables: 1) ITEMS IID (PK, autonum) 2) COMPONENTS CID (PK, number) CName 3) Assemblies AID (PK, number) AName 4) XREF CID AID ITEMS is the only place where the unique IDs are generated. (This is done to allow any new table (e.g. PDF_SPEC) to be joined to...