Help

Looking for Mismatched Addresses
I've figured out a convoluted solution to this problem, but I'm hoping for something a bit more elegant. I have a table of orders as they're received from customers (the BillCust and Orders tables, related on BillCustID), and a query of how those orders ultimately appear in our accounting software (qrySummit_SBC... 8 Jul 2008 23:22

Lebans calendar
Hi Dear Friends Is it possible to integrate Lebans calendar on a form in lieu and place of the Microsoft MonthView ? Many TKS in advance. José ... 10 Jul 2008 14:26

Seeking 'top values' equivalent in a report
I have a UNION SELECT query that lists names of people pulled from several different tables. I have a report that prints the first 3 names in a subreport area on main report page 1 and the rest of the names in another subreport area on the back side (page 2). I'm trying to figure out how to limit the output of t... 8 Jul 2008 23:22

Trapping an Error for a required field?
Using a continuous form I would like to require 1-field in each record to have data before the record is saved. In the table I set a single date field as required = yes, and this works for me. How do I display a custom message that makes sense, other than the one I am assuming is coming from jet (DAO). I tried t... 7 Jul 2008 22:47

Referential Integrity problem. Related record is required in table Employee?
Thanks Tom That was the problem. I would have gone nuts wasting time on that one. On Jul 6, 8:51 pm, Tom van Stiphout <no.spam.tom7...(a)cox.net> wrote: On Sun, 6 Jul 2008 15:49:08 -0700 (PDT), "ApexD...(a)gmail.com" <ApexD...(a)gmail.com> wrote: Perhaps you set a default value in the fiel... 6 Jul 2008 23:12

A New Article Site Invites You to become a Member Writer!
<ADV> Hey Aspiring Writer! I am John Reed and I am writing on behalf of Gabriel, the webmaster of the Internet's No.1 Love & Dating Articles Site - http://www.OnlineDatingCode.com. I am inviting you to join us as a member writer on our Article Website which is exclusively for Love,Dating,Sexual, Flirting, Relati... 7 Jul 2008 15:35

Referential Integrity problem. Related record is required in table Employee?
On Sun, 6 Jul 2008 15:49:08 -0700 (PDT), "ApexData(a)gmail.com" <ApexData(a)gmail.com> wrote: Perhaps you set a default value in the field's table design? Sometimes Access sets a default value of 0 for an ID field and the related table may not have such an entry. Take out those defaults. -Tom. Access2000, us... 6 Jul 2008 21:10

Probs w/ A97 example code using Application.FileSearch
With Application.FileSearch .NewSearch .LookIn = "C:\My Documents" .SearchSubFolders = True .FileName = "Run" .MatchTextExactly = True .FileType = msoFileTypeAllFiles End With My code pukes complaining that msoFileTypeAllFiles is an undefined var type. Isn't it s'posed to be some kin... 7 Jul 2008 12:29

Referential Integrity problem. Related record is required in table Employee?
Access2000, using a continuous form. I’m getting a message that say “you cannot add or change a record because a related record is required in table Employee”. This occurs in all my combobox fields that have referential integrity linked to another table. I do not have the field in the table set as required, a... 6 Jul 2008 19:07

Maximise Access window
I know this sounds involved, but it works ... almost I am using a Hyperlink to run an Excel application which generates a chart based on a query in the current database. This chart is saved a a GIF file is linked to an Image control on my form. ( Programming the chart object has proved far too slow) The rel... 6 Jul 2008 20:08