Search results for query: *

Ok now this is bugging me, I can't access the references section in the VB window :(

OK this was working fine, I go on vacation and come back and it's now disfunctional. Along with a few other things, they had some "TEMP" programmer in here :( Anyways I have a ton of messes to redo and need help with this one. Function SEmail() On Error Resume Next Dim rs As...

Thanks Dougp, this much I know. I have 25 fields though. 25 answers / to check against 25 questions. So each table has 25 fields . Plus the identifier. what I need to know id the best way to determine the correct ones :(

Scenario: 25 Multiple Choice Questions. Stored in a table each question has it's on cell. 25 Answers stored in another table I need to determine who got over 80% right

Sometimes the answer is too simple to see :) Thanks a ton for your help 14 hour days make me slugish.

Ok I have a faxing form that mass faxes from access. Next to the button to send the fax is a drop down list allowing selection of project number. Problem: I need this button to verify that the ProjectID box has been filled before it's event is allowed to continue.

Thanks a ton for the quick response, worked like a charm.

I am creating mailing labels and need some assistance. If there is a company name in the company field I want this to be added to the report, but not name. Name only if the company field is not populated. So this one cell should be one or the other , but not both? Make any sense?

thanks again Doug

in the thread I started thread181-141407 suggested an answer that seemed as though it would function great. Unfortunately it seems to be beyond me to get it going. Would example code be possible?

Nope that is exactly what i am trying to do, I don't actually have it looked up on button I double click the field. The non local data is accessed by many others so they can't update that. They can however alter the local data. As I am still confused on the how tos of what you suggest could, you...

http://msdn.microsoft.com/library/ Seems the actual reference page is down right now. Once they have this fixed I believe you'll find your answers here.

OK I'm back and this time I actually have a question I believe may prove tricky. My application has 2 different datasources. One of these is locked so no edits can be made. The other is freely editable. I have a tool that allows the user to decide what records they wish to include in the...

thanks a ton for your help , that worked perfect.

Ok I have quite a few procedures that use the SendObject command. Heres the problem and should be quite easy for most of you. If I cancell out the Outlook window after it is opened. I get a sendobject error window popup. Is there a simple way to eliminate this?

Ok simple scenario here, mind is just not on it with all the other issues with the US. I have a combo box. After selecting a criteria from thsi box, I would like to use a button to check,uncheck all records that fit the criteria.

Ok Seems I got the code to work. I only have one problem left here. If the filter only returns one record. The email is Address dor that record is doubled up :( so it shows in outlook as test@test.com;test@test.com Private Sub EmailResults_Click() Set db = CurrentDb myString =...

I have a combo box that applies a filter to a form. Private Sub Combo62_AfterUpdate() myString = Me.Combo62 Me.RecordSource = "SELECT BMembers.*, [BQualify].[Category] FROM (BQualifyList INNER JOIN BQualify ON [BQualifyList].[BQualify]=[BQualify].[Category]) INNER JOIN BMembers ON...

thank you very much, your second suggestion works perfect :)

I have the following code in the on update event of the combo box. Me.RecordSource = "SELECT BMembers.*, [BQualify].[Category] FROM (BQualifyList INNER JOIN BQualify ON [BQualifyList].[BQualify]=[BQualify].[Category]) INNER JOIN BMembers ON [BQualify].[MemberID]=[BMembers].[CustomerID]...