subform processing problem
I have a form bound to my Issues table. The form contains a subform bound to
my client table.
Relationship Issues to Client is many to 1.
The subform retrieves data correctly for existing issues and clients.
However when I am creating a new Issue, I cant figure out how to populate
the client. For a new Issue, the subform appears completely gray. When I
click my button to choose a client the code fails with 'you cannot assign a
value to this object' - when I attempt to populate the subform fields.
When this button is clicked, I first populate the linking field in the main
form, thi...Ranking scores within a subset of records
I need to rank the scores each judge gives a competitor in an event. I will
be using a query based on 4 or 5 tables but have created a table with the
fields Ineed to make the SQL easier to follow.
what I have is
Twirler Entry ID Score Judge Rank
Savannah Miller 8499 96.00 A
Savannah Miller 8499 89.00 B
Savannah Miller 8499 82.00 C
Haley Schlattmann 9039 86.50 B
Haley Schlattmann 9039 78.50 A
Ashley Meyer 9236 86.70 A
Ashley Meyer 9236 85.90 C
Ashley Meyer 9236 80.90 B
Jacy Alexander 9526 87.50 B
Jacy Alexander 9526 85.00 A
This is the SQL I have sta...Lookup & max, or match & offset within an array
I'm trying to construct a formula that does the following:
Finds the maximum value (a date, if that matters) within row 2 of
sheet 1 that corresponds to a cell in row 1 (in the same column as the
max value), which in turn matches a value in column A of sheet 2. See
e.g. below: I'd like a formula which searches for "#" and finds
I am having difficulty combining the hlookup with a max function, and
similar difficulty combining the match and offset functions as an
A B C D
1 * # # @
2 Jan Feb March April
...Remove line break within cell
I have a document that was provided to me which I have to make some changes
to and save as a text file for importing into a database. However, there are
breaks after each line signified by a small square. I want to remove all
those breaks because when saving as a txt file, it thinks it is a real break.
How can I remove those crazy little squares.
You may need the drawing toolbar to select them.
Right click in any toolbar and select Drawing.
Right click in a toolbar and select CUSTOMIZE, Categories DRAWING,
Drag the "Select multiple objects" command to the drawing tool...Posted Dates/User Ids Change when Payment is Applied
The posted date for a transaction was originally 3/11/05 (that was when AP
actually posted the transaction in GP). Once we issued a check for this
invoice, the posted date changed to the date we issued the check (3/15/05).
The same thing happens with users who posted. The person who posts the
payment replaces the person who posts the transaction. Why do you have "user
who posted" for both invoices and payments yet only the person who posts the
payment is the user that is displayed for both once the payment has been
posted? That does not seem logical. Each batch should re...Is it possible to view Excel split screen by tab within same file
I would like to view split screen tabs within the same Excel workbook. Is
Hi SS. Go to Window - Arrange - and select the view you would like. It
shows all tabs. Minimize or close the ones you don't want. I find the
vertical view the easiest to use. HTH
Sincerely, Michael Colvin
> I would like to view split screen tabs within the same Excel workbook. Is
> this possible?
Window|Arrange (horizontal/vertical/whatever you want)
Check windows of activeworkbook (if you only want that one workbook)
You'll see som...User modifying personal info in pab within outlook
I have Windows 2k Ad and exchange 2k enterprise, I want users in my company
to be able to modify only their personal info in personal address book within
outlook, how can i do this?
> I have Windows 2k Ad and exchange 2k enterprise, I want users in my
> company to be able to modify only their personal info in personal
> address book within outlook, how can i do this?
I'm not quite sure what you're asking. Firstly, what version of Outlook are
you using? With OL2000 and up, there is no need to use a .pab - just use the
contacts folder. Speci...Event ID 4000 Disable SMTP Logging under IIS
I have SMTP Logging for some reason on my Mail Gateway which runs IIS SMTP
and then sends the mail to Exchange. Does anyone know how to turn down
logging on IIS SMTP. The option for logging in not checked under
...Subform producing error...?
I am trying to sum a "simple" expression in a text box on a sub form.
It is producing #Error# - any ideas what I am doing wrong, I presume
something simple and obvious, but I can't spot it.
=Sum(IIf([Date Paid]>=[Forms]![01 Anna Start]![2 Months Start],[Amount],0))
[Forms]![01 Anna Start]![2 Months Start] is calculated using this expression
on the main form [01 Anna Start], and is producing the right date:
All responses gratefully received!
Message posted via AccessMonster...SMTPSVC Event ID: 2012 and 2013
I am still getting these errors/warning in my system log after changing the
SMTPSVC to use only TCP. What else can I do to make these warnings or
errors go away. This is on a Windows 2003/Exchange 2003 system.
the command I use to make this change is:
SMTPMD set smtpsvc/useTcpDns 1
Is these correct, I have been able to verify this.
I am getting these errors every hour on the hour. I have tried everything
ppl have posted, nothing works....
"Sabo, Eric" <email@example.com> wrote in message
SBF Uses Vendor ID and Quickbooks does not. Any Idea anyone on how
Vendor ID is generated in SBF after the Import Export Wizard is run. I
know that it takes the First Word in the Vendor Name but it
concatenates it with a number which I am not aware of as to how its
There is a newsgroup specifically for Small Business Financials. Have you
posted this question there?
Charles Allen, MVP
> SBF Uses Vendor ID and Quickbooks does not. Any Idea anyone on how
> Vendor ID is generated in SBF after the Import Export Wizard is run. I
> know that it ta...Product ID look for
We have completed a Scribe integraton and we are working with the product
section of CRM. When we do a search CRM only "looks for" the product name
not the product ID. The product ID is where we keep all of the part numbers
we need to find. Any suggestion of how to set the search to look in the
product ID field rather than Products name?
On Tue, 4 Dec 2007 11:23:02 -0800, Ali 123eDistribution.com
>We have completed a Scribe integraton and we are working with the product
>section of CRM. When we do a sea...Breaking up data within a cell
In Excel 2003 WinXp
I have several thousand lines of data which have imported as - (as an
B2342, 12,32223, JFGK, 1
Please can you advise me how to make the above line become 5 separate cells
(a1:15) rather than one??
Thanks in anticipation.
North Yorkshire UK
Should read a1:a5 not as shown!
"John P" <firstname.lastname@example.org> wrote in message
> Hello everyone,
> In Excel 2003 WinXp
> I have several thousand lines of data which have imported as - (as an
...event id 1202
the following error is appearing on our server:
Security policies are propagated with warning 0x4b8.An
extended error has occurred.
Does anybody know what might have caused this and how it
can be eradicated?
Here is an article that may assist in trouble shooting the issue:
Q324383 Troubleshooting SCECLI 1202 Events
Please do not send email directly to this alias. This alias is for newsgroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick"...what does an "invalid sam id" meen in Outlook 2007?
I'm trying to import a .csv to Outlook. I keep getting "invalid sam id"
message. the error with act3.sam translator message appears also.
SAM = Security Access Manager and is not an Outlook related issue. Invalid
SAM ID indicates a connection failure with your servers - something changed
in your environment which made the SAM ID for the machine you are using
invalid between the server and workstation.
Are you using BCM?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.c...Continuous subform behavior
I have a continuous subform on an unbound form that I want to be able to
edit records. When I click into to a text box on the subform and begin to
edit the text, I can edit, but the original text gets deleted as soon as I
start typing. The record is not deleted, just the data in the field linked to
the text box. The form's data entry and allows additions are set to "no" and
allow edits and deletions are set to "yes".
I would like to be able to click into the textbox and freely edit without
the original data being deleted. Any ideas what...MTS-ID
I have a user that is trying to send an email with three
small Excel spreadsheets. An undeliverable email is
returned with the following message.
"The recipient name is not recognized
The MTS-ID of the original message is: c=US;a= ; p=
Organization name; l=server name - 031212195939A-11183"
I am unclear as to what this message means and how I can
resolve the issue so that the email is delivered to the
intended recipient. I am on Exchange 5.5, SP4.
"Emily Blum" <email@example.com> wrote:
>I have a user that is trying to...Reports Recordsource from subform datasheet (filtered)
I have a form with a datasheet (as subform). Of course the user can
sort/filter the datasheet. I also have a button to run a report on the form.
What I would like to do is have the report print with the same data as the
subform datasheet. I need to pass the filter and sort information to the
report from the form. Somebody jog me please.
Thanks in advance,
...Show Record In Subform If Either Of Two Fields Match frmComboBox S
I am having trouble figuring out how to accomplish the following in Access
I have two queries as the basis for my form.
1. One with a set of baseball teams in a league. Each record is one team,
and the key is TeamID.
2. One with the league's schedule. Each record is one scheduled game. Each
record has a TeamID in the VisTeam field, and another TeamID in the HomeTeam
I want to set up a form and subform where:
A. The main form has a combo box to select one of the teams.
B. The subform shows all the games and only the games where that team is
scheduled as either VisTeam or...Password Protect Word from within Access 2003
I have inherited an Access application that uses Word templates for
letters/invoices. My client now wants the resulting documents password
protected so they cannot be altered once generated. Any help would be
Are you wanting to password protect the templates or the documents generated
from them? If its the later, I would go to a process where once the document
is created in Word you convert the document to a pdf as doing so will lock
down changes to it by default. The other alternative is to snoop around the
Word newsgroup about automatically saving a doc...ID no: c1036e71
Has anyone seen this error in Exchange 2000?
Exchange System Manager:
The Queue Viewer Snapin is unable to retrieve an interfact to the queues.
The queue Viewer Snapin will be disabled until you refresh it. Check the
event log and verify that the approporiate services are running
ID no: c1036e71
Exchange System Manager
I have searched MS and found nothing, searched google and found some MSDN
class test questions and it states to restart the MTA Stacks, which i have
done with no luck in changing the outcome. This server has gotten currupt
and i am trying to limp it along for a few ...Message Id and Message Journaling
We have outsourced message archiving. As part of this process we point all
of our inbound and outbound traffic to this firm. To capture internal mails
we have to turn on message journaling. This then creates an issue because
all external mails will show up at the archiver twice. Once because they are
our "Bridge Head Server" and once by the journaling mechanism. Since you are
charged by space used this isn't necessarily a good thing.
They have a process in place to remove the duplicates by removing all
message ids that are the same. (has solved thi...Event ID :7024
Who can help me to solve this error?
When I want to strat The Information Store service of
Exchange 5.5 server on a windows2k server machine,it
couldn't start and in the eventlog there is this event id
7024 and this description:"The Microsoft Exchange
Information Store service terminated with service-specific
Could you please help me?
It's so important for me my Echange server was down.
Thank you for the help.
Take a look at the following article, it may help to shed a little light on
246272 XADM: Se...Event ID 509??
Anyone know what this means??
Event Id: 509
Information Store (1234) First Storage Group: A request to
read from the file C:\Progfile\exchsrvr\mdbdata\priv1.edb
at offset 3687149568 (0x00000000dbc57000) for 32768
(0x00008000) bytes succeeded, but took an abnormally long
time (102 seconds) to be serviced by the OS. In addition,
20 other I/O requests to this file have also taken an
abnormally long time to be serviced since the last message
regarding this problem was posted 107 seconds ago. This
problem is likely due to faulty hardware. Please contact
your hardare vend...Buyer ID and Buyer Description
I would like to add the Buyer Description field to our POP Blank Form. The
ID is the person's name, but the Buyer Description is used to sort items when
Yes. Unfortunately, the developers did not create a relationship between the
POP HDR table and the Buyer table. You will need to add a relationship within
Report Writer by clicking the Tables button. You will find the POP_PO table.
Click the ellipsis button to the right of Secondary Table.
Select Buyer Master.
Select POP_Buyer_IDxID as the table key.