Record Macro Relative does not work?
Can someone help me with this macro. I want to go to any cell of my
choice and press f2 to edit, then go to the fifth character of that cell,
then select the next 6 characters and change them to a smaller font size
(8), then "enter". I tried to make this macro using the record macro
function, but it did not work how I want it to. It ends up pasting the
contents of the cell which I used to record the macro initially. Can
this kind of macro be done?
To get a relative recorded macro, make sure the stopr recording toolbar is
visible, it has 2 icons, one is to s...Error when no records meet criteria
I have the following code and receive error 1004 Application defined or
object defined error on this line
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
Selection.FormatConditions(3).Interior.ColorIndex = 7
because there are no records in this instance of the report for "4" in ColB.
I've searched and applied code all to no avail. Can someone please tell me
how to write code for when this may occur in any of the situations below?
...Auto Filling Fields in Current Record from Previous Record
I have looked through posts related to Auto-Filling a field from a
previous record but am still a little unsure of how to do things.
What I would like to do is auto fill a field in the current record
with one from a different field in a previous record. What I have is
a form that records "engine hours" and "tonnes moved" for a piece of
equipment. The operator will record the staring hours and tonnes (at
the start of a day) and the hours and tonnes at the end of the day.
So in the database, I would like the "Starting Hours" and "Starting
Tonnes"...Bank of America Bill Pay #2
I recently setup MS Money 2006 with my accounts at Bank of America (All
except CA, WA, & ID). I am able to use direct download from within Money and
it downloaded all my Payees from BofA.
However, I have a stupid problem now...
In Money, I have all my Bills set up with their due dates, etc. When I need
to make a payment, I login to BofA on the BofA website, and schedule a bill
payment via Bill Pay. Then in Money, I go to the Bills Summary page and
enter the payment.
When I update my BofA account after that, it automatically downloads the
Bill Pay payment that I schedu...Not saving records till "save" command button clicked
If you are in a form and adding information, then close out or go to a new
for it just saves the record as long as all applicable fields are filled out.
Is there a way to only have a record save if a command button is clicked?
Message posted via http://www.accessmonster.com
If you simply hide the form instead of closing it, I think that will prevent
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"szag via AccessMonster.com" <u2885@uwe> wrote in message
> If you are in a form and adding informat...More than 100 records in Look Up Records dialog window
Does anybody know, how to get more than 100 records in Look Up Records dialog
For example in Opportunities - I want to add an existing contact to the
opportunity, but I can see only 100 records. I dont want to specify any
character, I need to choose from all contacts.
(It is not the same problem as paging, PagingLimit in SQL can not help)
...DAO and Table Locking
I've written some code to create a relationship between table A and table B.
The code looks something like this:
Set rel = db.CreateRelation("A_B")
rel.Table = "A"
rel.ForeignTable = "B"
Set fld = rel.CreateField("AID")
fld.ForeignName = "BID"
This code works just fine except that a few lines later, I use DLookup() to
find a row in table B, but I then get an error that table B is exclusively
locked and cannot be accessed.
Can anyone clarify why table B has been...How to sometimes open form to new record?
I have a parent form which is then linked to a child form. I want to
have two buttons on the parent form, one to open the child form and
display all the records with the corresponding foreign key, and one
button to open the child form to a new record with the corresponding
foreign key already inserted. I have figured out how to open the child
form to a new record, but I cannot figure out how to insert the parent
ID into the child foreign key. Help! Thanks.
You don't have to enter the ParentID in the Child subfrom records...
Establish a one many relationship between the Pa...Count number of records after filtering
Probably a question that's easy to answer but I have been searching for
hours now & it's driving me rather crazy: I have applied a filter to a form
and now I want to know how many records I have got as a result, or better, I
want to know if there are any records left - how do I do that?
Tried so far:
If Form.Recordset.Count = 0 Then ...
If Iserror(Form.RecordSet.Count) Then ...
If EOF(Recordset) Then ...
but that all does not work.
An easy way is to add a hidden text box, txtCount say, to the form, with a
ControlSourc...Select Records that fall in an external set of ranges (subquery)
HiI have not done subqueries before so I am a bit confused. I have twotables1 - Phone Numbers - (converted to be numeric) (with other fields forlater) and2 - Exchange codes - multiple entries for code with 3 fields -Exchange name (duplication) - Start Range and End Range.I want to return a list of phone numbers that fall into the range fora certain exchange.For example - MRSPOO has 4 entries in the Exchange Table with 4distinct ranges. 200-299, 307-788, 997-1102 and 2036-6698. I would like to be able to return all the phone numbers for a singleexchange code that I would select (using a query...copy record between tables
Hi, I have two tables with same structure. I need to copy a record from oneto other using vba codes. I'd like avoid to copy field to field.Thank you. Without knowing anything about your table structures, something similar to the following:Dim strSQL As StringstrSQL = "INSERT INTO tblCopy SELECT tblOriginal.* " _ & "FROM tblOriginal WHERE tblOriginal.KeyValue = 4"CurrentProject.Connection.Execute strSQL"Alberto" <saveas[at]iol.it> wrote in message news:uk2oUMBYHHA.3656@TK2MSFTNGP05.phx.gbl...> Hi,> I have two tables with same structure....how do i semi-lock a group of cells to allow lookups formula...
how do i semi-lock a group of cells to allow lookups formulas without
allowing user changes
Do you mean you want to be able to reference these cells in lookup formulas
contained in other cells?
If so, leaving these cells locked (Format | Cells | Protection), and then
Protecting the Sheet (from teh Tools Menu) should be enough.
You may want to make sure you have Select Locked and Select Unlocked Cells
Checked, if a list of Protection Options pops up (Excel 2002 and later).
> how do i semi-lock a group of cells to allow lookups formulas without
> allo...Highlight a selected record
I am trying to highlight a selected record of a continuous form. Conditional
Formatting is not working because it highlights individual fields. If
Conditional Formatting would highlight the entire row, it would be perfect.
I created a txtBackground text box to size of all my fields, sent it the
back—behind the fields. Use the txtBackground as the control, but when it
has focus it covers the data. Below is the code I used:
Sub HighlightControl(ctl As Control)
On Error Resume Next
ctl.BackColor = 65535
Sub UnhighlightControl(ctl As...Record data on two lines
Sorry about repeating the post but I think I messed up the first one
I am receiving a spreadsheet from an agency with record information on
Record 1: A1, B1, C1, D1, A2, B2, C2
Line 3 blank
Record 2: A4, B4, C4, D4, A5, B5, C5
There are over 100 records like this. They claim they can't fix it...
It originates from a Crystal Report.
How can I change the data so each record is on one line:
Record 1: A1, B1, C1, D1, E1, F1, G1
Record 2: A2, B2, .......................G2
Thanks for any help!
A simple way is to 1) select all of the data fields. 2) Cli...Show related records for custom entity
I have a custom entity. When I go to History I can not see the related
records from contacts, opportunities, etc. They are not rolling up and there
is no pick list to show related records or not. Is there a way to change
On Fri, 23 Feb 2007 10:33:49 -0800, Rick M
>I have a custom entity. When I go to History I can not see the related
>records from contacts, opportunities, etc. They are not rolling up and there
>is no pick list to show related records or not. Is there a way to change
As...Minimizing Windows Locks Manager
I have a weird problem that occurs on all computers and I can't seem to find
any information on it. Can someone please confirm it is an issue? V1.3.0206
running on XP fully patched.
Steps to Reproduce
1. Open Manager
2. Open Suppliers Window
3. Open Customers Window
4. Minimize Suppliers from behind Customers
This causes the entire Manager program to lock up with focus flicking back
and forth between the two windows. This happens for any Windows within
Have I got some weird setting configured or does this happen for everyone?
This is a multi-part message in MIME format....Can MSCRM 4 handle millions of records (Product)?
We are in the middle of evaluating MSCRM 4 for a hypermarket. The objective
is to load all the warehouse inventory into the Product entity, which are
having approximately 6~7 millions of products (including sellable parts and
etc.). This information will be available to the VIP card holders (Contact),
as well as building royalty progammes and campaign management.
Some selected Products will be available for ordering via a Portal (custom
build), and the information will be updated to MSCRM as well.
So, we need to know that whether MSCRM is a feasible solution for this kind
of requi...Summing multi-level bill of material
I have a multi-level bill of material and I want to create a
function that will sum it properly without having to sum up each
manually. Here is an example:
Level Item Quantity Cost
1 Chair 1 $39
2 Seat 1 $15
3 Cushion 1 $10
3 Base 1 $5
2 Leg 4 $1
2 Back 1 $20
3 Leather 1 $12
3 Wood 1 $8
In my example, I have a chair. The chair is composed of a seat ($15),
four legs ($1 each), and a back...ListView insert
I have a ListView that I am using to edit and insert rows into a database
table. I am displaying records for a specific person and existing records
edit and update fine. Also, if a person already has records in that table,
the ListView DropDownList population and insert works fine. The problem is
that when a person has no records in the table (ListView is empty) the
DropDownLists are not getting populated. I assume maybe because the DDL
populating is being done in the ItemDataBound event? If so, where is the
best place to populate the dropdowns for insert? Below is some of ...Not recorded unless tab opened
I created a form with four tabs and (registration, progress,delivery of baby,
and after delivery care. When i creat a new patient record in registration by
putting name some details in the registration tab, if i close it at that
point, the record cannot be recovered back into the form. However its in the
table when i look for it. The surprising issue is if i open the delivery of
baby tab and i only put in one single information, then i can recover that
information on the form . The patient record will only be recovered if i fill
the delivery of baby tab and no other tab allows th...Adding a Record
I have 2 Subforms on my Main form.
Each Subform contains a combo box with drop-down list. Their tables are on
the many side of the one-to-many relationship with the Main form.
When I make a selection on Subform 1, Subform 2 automatically populates with
a correlated item from its drop-down list.
PROBLEM: when I make a SECOND selection on Subform 1, the item that was
listed on Subform 2 gets replaced with the item correlating with the SECOND
How can I adjust my code so that the second item is ADDED to the list on
Subform 2 instead of replacing the first item?
A sample of...Creating a warning prior to deleting a record
I'm creating a membership database for an organisation. A problem I've
encountered is the young lady that will be using the completed database is
occasionally using control/z to undo an input error too frequently and
deletes the record that she is inputting. As the membership number is an
auto-number field this loses that particular membership number which I need
to stop from happening.
Is there anyway I can generate a warning prior to that final deletion to
stop this from occurring?
Autonumber is not recommended for the use you describe, for exactly the
reason you...4.0 Workflow
I am trying to setup a workflow to send an email when an Account record gets
deleted. I want to include the name of the Company in the email and who
The workflow fires, but always has a Status of Waiting because it says "The
requested record was not found or you do not have sufficient permissions to
view it". The reason this happens, I am assuming, is that the record has
already been deleted so data from the record cannot be included in the email.
Is there a way I can accomplish what I want?
Workflow plugins are asynchronous so by the time you get to the databas...Bill Pay and Money
How do I decide to use bill pay or Money's autopay?
Are they separate, i.s., if I set an auto pay in Money and
a like one in Bill Pay, is the payment (and Cash out)
Money's AutoPay just sets up an autopay in Bill Pay. So yes, if you set one
up in each you will end up with 2 autopays for the same vendor and duplicate
payments will be made.
"Children should be educated and instructed in the principles of
freedom." --John Adams
"bwagner" <firstname.lastname@example.org> wrote in message
news:197401c44290$...Need to keep record of telephone conversions as in sales
I work from home and in sales i need to keep a record of my telephone
conversations, i have outlook which i use but want a excell spreadsheet which
i can see all my calls at once.
In Excel, create a list of calls.
In row 1, enter the headings, e.g. Data, Start, End, Name, etc.
To enter the date, type: Ctrl + ;
In another column, enter the Start time, by typing: Ctrl + :
When the call ends, enter the end time in a third column,
by typing: Ctrl + :
In additional columns, enter other data about the call, e.g. Person
called, purpose, outcome.
> I work from home and...