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)
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"))
The credit card mask works great. The one I am using is
FOP: Left([mpfop],2) & Left("XXXXXXXXXXXX",Len([MPFOP])-6) & Right([MPFOP],4)
but there is one problem, sometime the client pays by Check and this is coded in the Credit Card Field. When this happens the code will error out. I have...
What I am pulling into my query is Total sales for Domestic and International travel. The query is being grouped by Domestic/International. I have included if statements in the query If field name = D then Sales else 0 (Name Sales_D) and I have done the same thing for International Sales. In my...
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 am having problems with this code. The format of the Credit Card number is DC11111111111111. Does the code pull the two letter Credit Card and counts the Credit Card number?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.