Search results for query: *

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...

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?

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"))

I have created a query that contains the data that I need for a report. I would just like to use certain fields from the query. Would I need to create VBA coding to do this. Query Sales_D Sales_I Comm_D Comm_I When I place Sales_D on the report it reports two lines. The total for Sales_D and...

I have Credit Card Numbers in my database. When I am sending out a report I would like to mask the numbers, picking up the first two letters (VI/MC/DC/TP) and the last 4 digits and putting XXXXXXX in the middle. The length varies between 12 & 18 characters. Example: VIXXXXXXXXXX1111 Does...

I am looking into taking a class for Introduction to Visual Basic 6.0 or Introduction to VBA. I am proficient in Word/Excel/Access. I would like to advance to the next step in creating macros and programming skills. Which class would you recommend?

I have an Excel workbook that contains Macro's(Macro Workbook). I would like to run these macro's from a button in another workbook (DataWorkbook). Is it possible to create a button in the DataWorkbook that would call the Macro's in the Macro Workbook? (I do have both workbooks open) Thank...

I have a spreadsheet that I would like to place a value of XX into the fields that are null. The update would take place in A Column. Example If cells in column A are null then insert XX How do I do about this in VB. The macro would have to know the last row. Thank you.

I need help with a macro in Excel. I have a column with string of text Thu 4/1/04 2:48 PM and I need to delete the first 4 positions in each row in the column. End result: 4/1/04 2:48 PM Do I use LTrim?

I need to create a VBA code that would Insert column before column A Tnen name column "Club" Insert the club name based on info in column E if last 8 digits (this is in a string)= Michigan then assign MI Nebraska then assign NE Any suggestions.......I am not very strong in VBA...

Don't know if this is possible. If I wanted to create a form that contains this information how would I do this. I have a table that contains this information Week1 Apr 04/01/04 04/06/04 Week2 Apr 04/07/04 04/10/04 Week3 Apr 04/11/04 04/15/04 Week4 Apr...

I have been given a project to email Access reports on a weekly bases to managers at their locations. I am currently running the report selecting each office location and emailing the report from Access. This is very time consuming running each location (50) and then entering the email address...

I would like to have 4 different date criteria'a set up on a form. For example: Jan(Month) Week1, Week2, Week3 and Week4. I can get the first results Jan, Week1 with the following code. PrivateSub cmbChoose_AfterUpdate() Me!Week=Format(cmb.choose.column(1)...