Recent content by Adams

Yes, I have a questions. When you click on a link to go to the source page what is missing from the link to populate that data at the top of the page?

I am using Excel 2003, I have linked 2 worksheets using the hyerlink. The link indicates where to do to on the source page. This works but I would like when going to the source page the information to populate A1 cell. (The source page contains weekly information. The link is linked to the week)

Hi, I am using Access 2000. I tried to use "UpdateBatch" method on ADODB recordsets. I set cursor type to adOpenKeyset and LockType to adLockBatchOptimistic. However, the method will only updated one record. If more that one record is entered I receive the following error message with error...

Run-Time Error Multiple-step operation errors. Check each status value. It is stopping on this line: rsCustomer!TktCnt = Me.TktCnt In the table the Data Type is Number and Field Size is Double.

I have created an unbound form that is erroring out when I try to save the current record. Do I need to define the type of data? Sub SaveCurrentRecord() 'save the values in the controls on the form to the current record in the local disconnected recordset If Not rsCustomer.BOF And Not...

I am trying to connect to a back end database. This is the code I am using: strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Work\ContactManagement_BE.mdb" This is all one one line. The error that I am receiving is that it can not find the file(ContactManagement_BE.mdb) I am...

I have a combo box on a form(Form1). The drop down contains company names. When a company name is selected their information is filled in on Form1.This works great as long as I stay in this form. I also have a button on the Form1 that opens up Form2. On Form2 I have a button that goes back...

I have two forms, the first form has a drop down list and updates customer names on the form when a different customer is selected. I have a button that switchs to the second form, this form has contact information. On the second form I also have a button that switches back to the first form...

I have created a form and would like to filter some data. I have use the Toolbox to create a Command Button Apply Form Filter. How do I link the button to the field I would like to filter?

I have a subform that I would like to input new client notes. The two fields in the subform are date & notes. When I pull up the subform the previous notes are in the record. I would like to pull up blank record to input notes into. How do I go about doing this?

This is the error that I am receiving when I try to add data to the second tab. Cannot add record(s); join key of table <name> not in result set. (Error 3348)

It is also a table.

Thanks that worked. With a subform I can not update the records if there is a new contact. Is there another way I can join these tabs?

I have created a form that contains a Tab Control. The 1st Tab contains Company Info, I would like the second tab to contains Contact Info from the Company. I have completed the first tab, my problem is the second tab. The contact data is house in another table. How do I bring the data from...

Would you look at this IIF statement and tell me what I am doing wrong. ServiceFee: IIf([Intkt] Like " 952*","SERVICE FEE/NON-ARC AIR" Or IIf([Intkt] Is Null And [tblNebExt].[invaln] Is Null,"NON-ARC AIR"))