fonts in drop down boxesIs it possible to change the font or the colour of a font in a drop down box?
Thanks.
...
Create Combo Box to Find a RecordI would like to create a combo box based on two fields on my form that will
list each [CertificateNo] that is marked [Registered (Yes)]. Registered
column is Yes/No.
I made a query but the wizard will not let me find the record based on the
query. I tried changing the Row Source in Properties to my query named
[Registered Certificates] but, alas no luck.
Is there anyone who can help me with this problem?
Much appreciated.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200911/1
Hi Uschi,
in the header of almost e...
Filtering or Formatting DataValidation ListIn ColumnG I have the following formula array from row2 all the way down to
row100
=IF(ROW(FilteredMonday)-ROW(E2)+1>COUNT(F2:F100),"",
INDEX(E:E,SMALL(F2:F100,ROW(INDIRECT("1:"&ROWS(FilteredMonday))))))
ColE = FilteredMonday (a list of my employees who work on Mondays)
ColF = counter
In ColumnM I have a drop down list with data validation and the source for
it is ColumnG. The problem is I only have 43 names but I wanted it to have
the capacity for 100 names, so rows 44-100 are either a 0 or #NUM!. How can
I have the drop down list show only th...
how to add an outlook email to a text box in an access form?Hi,
I searched everywhere for a similar issue but in vain...
I have a form used to enter computer issues. I would like to add to it a
text box that will store emails. It could be a button that opens a link to
the email. I hope this is clear. thanks.
Ismail
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200803/1
Hello,
Could you save the emails in a folder and place a button on your form that
is hyperlinked to the folder? Might be an easier way but this is pretty
simple.
"ielmrani via AccessMonster.com" wrote:
> ...
Counting 12-28-07I have a data element in a table named Results. This is defined as a number
field. The Values go from 0 to 11.
The problem is I need to count a certain value but sometimes that value has
not been chosen and that, of course, returns nothing. I would like it to
return the result value I am looking for and a '0'. Any ideas?
Post your SQL.
--
KARL DEWEY
Build a little - Test a little
"Bunky" wrote:
> I have a data element in a table named Results. This is defined as a number
> field. The Values go from 0 to 11.
> The problem is I need to count a certai...
VBA: Insert rowsHi,
I am using the following VBA code to insert a number of rows starting from
the value contained in cells(5,3) and ends before or on cells(10,3) the
values are always in ascending order and in series. like 12, 13,1 4 etc. I
am getting a type mismatch error in the last line of code. It will be great
if someone can help me out with this.
Sub main()
Dim i As Integer
Dim value1 As Integer
Dim value2 As Integer
value1 = Cells(5, 3).Value
For i = 1 To 5
If Cells(5 + i, 3) <> "" Then
value2 = Cells(5 + i, 3).Value
'MsgBox v...
Make "Header row" default search mode?I have a very simple worksheet I use as a task manager. One of the
columns contains values from 1 - 5 representing the urgency of the
tasks. I'm constantly adding and deleting tasks, and changing the
urgency values for tasks as my situation changes. Which means that
I'm constantly re-sorting the data so that the most urgent tasks
appear at the top of the sheet.
Somehow I've managed to set the spreadsheet so the Sort command thinks
that I have no header row. So each time I sort I have to manually
check the "Header row" button under "My list has."
Isn't ...
delete rows which have a one in themi've got this code built that will delete a row if there is a one in column h
but it's not working
sub delete()
finalrow = celss(rows.count, 1).end(xlup).row
for i = finalrow to 2 step -1
if cells(i, 8) = 1 then
cells(i, 1).entirerow.delete
endif
next i
end sub
it doesn't work, what do you think is wrong?
Try this.
Sub Macro1()
' count down through the rows(from bottom to the top)
For MyRow = Worksheets("Sheet1").UsedRange.Rows.Count To 2 Step -1
' check column H for a "1"
If Worksheets...
Row height #3Does anyone know why a cell will not increase in height
when it's formatted "autofit", with wrap text?
Connie, does the row have merged cells? I think this is a problem in excel
--
Paul B
Always backup your data before trying something new
Using Excel 97 & 2000
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"Connie" <anonymous@discussions.microsoft.com> wrote in message
news:00fa01c3b447$ff88a9d0$a401280a@phx.gbl...
> Does anyone know why a cell will not increase in heig...
Take Rows from Sheet1 and use as headers on Sheet2I have 10 rows on sheet 1 that users fill in. I'd like those 10 rows to be
the top lines printed on all subsequent sheets. Is this possible? How?
Thanks in advance.
Does "Sheets" mean pieces of paper -- when you print one worksheet, you can have
multiple sheets of paper printed?
If yes, then File|page setup|sheet tab|rows to repeat at top.
If you mean you want worksheet 2 to use worksheet 1's headers, I think you'll
want to put those headers in each worksheet.
Keith Marbach wrote:
>
> I have 10 rows on sheet 1 that users fill in. I'd like those 10 ro...
loading a count of another entity into a field on the primary entityHi
I have a custom entity associated with Opportunities called Required
Conditions. From the Opportunity enity I need to be able to check the count
of the Required Conditions in order to disallow/allow certain actions.
The simplest way of doing this (from what I can see) would be to populate a
field on Opportunity with the count of the Required Conditions when the
Opporutnity is loaded, however I have no idea how to do this. Can anyone
out there assist?
TIA
Saira
You may want to consider a callout (3.0)/plug-in (4.0) instead. Whenever one
of your custom entities is created, updated...
List Price IssueHi All,
I use CreateSalesOrder() of web services to create a Sale Order, however,
when I set a list price = $60.00 of an item A for example, instead of $50.00
of item A that already existed in Inventory last month. The reason I do
because I want to keep 50.00 of Item A and change $60.00 for a perticular
Sales Order but not all.
So, when CreateSalesOrder() is created, the List Price always take $50.00 of
Item A inventory, doesn't matter you change to $60.00. I think the problem
is Create Policy but I don't how to use or set it.
Please advice.
Thanks,
-Toi
Look at how a s...
find rows for unique data in 1 column and different data in other.I have a spreadsheet that contains 1 column that contains cells that may
contain the same information such as A2 and A4 and A6 all contain 4144638872
- in columns B-P there may be information that may be different for each 1234
cell:
A2=4144638872 B2=278954
A4=4144638872 B4=195871
A6=4144638872 B6=238521
I want to return a result of unique rows based on only 1 phone # that exists
in column A. I need the information in column B and other columns and I
don't care which of the 3 remain in the result sheet. Basically I have a
list of file#s with the same phone #s and I only want ...
Handling very large files (too many rows)I'm trying to analyse a set of data. However, the data is a CSV fil
with almost 1.5 million rows, which somewhat excedes the 65 thousand o
so that excel can handle. However, excel is what I'm used to. If ther
any convenient way to import so much data? Alternately, can anyon
recomend a different means to observe and process that amount of data
--
Message posted from http://www.ExcelForum.com
I really think that is way too much for Excel, even if you break it into bits.
What you should use depends on how you want to analyse the data. Access can handle that quantity of data. Maybe, if...
how to count populated rows?How do I find out how many rows have data in them starting with row 4 and
beyond? It's ok if I just know that column A has data in it.
I'm using VBA. I don't know how to use functions very well. But I know
visual basic some. So if you could give me some VBA code to do this, that
would be great. Thanks.
Ryan,
I was doubtful that just knowing there was data would be enough...
So following is some code to cover several possibilities.
(you can understand how some of this works if you look up the terms
used in the help file - just stick the cursor in a word and press F1)
'---...
White ListHow do I create a white list (do not filter) including people who are not in my
global lists?
Even the smallest list in Outlook 2000 doesn't fit on the exchange server if I
try to set it to Stop Processing in the Rules Wizard.
Even if it only happened after it went through the server it would be better
than nothing.
You can whitelist by defining a rule, like:
Apply this rule after a message arrives
sender is in <contacts> Address Book
and on this machine only
stop processing more rules
<duplicate of above rule for each contact-type folder>
Apply...
How to make a chart with selective (discontinuous) data?For example, two colums A and B have 10 rows (2 to 11) with values in each
cell.
How can I make a graph A Vs B which displays data only from rows 2, 5 8 and
10. I mean from discontinuous data and not from a continuous range. If yes
how to do in very large sheet?
Best to use your worksheet to pull the data into a continuous range, and
then plot that.
--
David Biddulph
"Making grapg from discontinuous data" <Making grapg from discontinuous
data@discussions.microsoft.com> wrote in message
news:6E74492E-4B84-41B1-B50A-C322A703370E@microsoft.com...
> For example, two colu...
range select a value in a cell?I have formulas calculating values to produce cell references such as J10, L15 etc
the formulas are similar to ="I"&TEXT(Q4, "d")
I am creating a macro where I want to select the cells calculated from my formulas...
instead of using range("J10:K10").select
i want the range to use the specific cell reference calculated in my formula...
because the range i want to select changes every time a new record is added.
is there a way to do this?
any help is much appreciated. thanks
b2: a2:a4
c2: =SUM(INDIRECT(B2))
---
HTH,
David McRitchie, Microsoft MVP -...
Outlook 2007 Distribution ListI'm trying to print my Distribution List on one page. Outook 2007 prints the
header info on one page and the members on another page. I want to print it
all on one page like I did with Outlook 2003.
You can save it as a .txt file and then print that file.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"MStone" wrote:
> I'm trying to print my Distribution List on one page. Outook 2007 prints the
> header info on on...
Having issues handling combo-boxI have a combo-box. I want to allow folks to enter by typing OR use the
mouse to click on the dropdown. If they type I want it to auto-complete -
that is no problem as the drop list style handles this. Where my problem
arises is that when they pick the one they want I then need to know so I can
do some added processing. I could handle the kill focus for when they type
but that causes confusion when they use the mouse.
What I want to be able to do is recognize when they hit <Enter> and act in a
manner similar to that used when they use the mouse to pick an entry. The
other possibili...
Stopping VBA code when it hits the last rowI have a list of data the is in 4 columns, and the number of rows will vary
from week to week.. Columns A-C are filled with data, and Column D will only
have data in certain cells (ie, row 6 could have a value and then the next
row to have a value could be row 20...and this value may or may not be
different than the value in row 6). I am trying to wrote code that will fill
in the blanks in column D, so it would copy the value in row 6 to all blank
cells below it until is finds another value (7-19 in my example). Then it
will find the next value and copy that to all blank rows below i...
On Send/Receive: Dialog box "The operation failed. Object not foOutlook 2007. When I click on send/receive, I get a dialog box that reads
"The operation failed. An object could not be found". Initial set-up was
successful because Outlook bounced a confirmation message to my ISP and it
came back properly. I can use e-mail through Explorer and my ISP, but not
through Outlook. This is a problem with a new Gateway GM5420 computer, new
Microsoft Vista, and a new installation of Microsoft Office Professional
2007.
See if this helps:
http://support.microsoft.com/kb/312354/en-us
You receive the "The operation failed. An object could no...
Message boxi would like to place a simple yes no msg box, have tried the code i
thought worked, but not having much success,
simply want a yes no button with message,
Yes msg box closes, no file saves and closes.
Any help??????
Hi Kikk ka
Try this:
sub askmsg()
if msgbox("Some message", vbYesNo)=vbNo then
activeworkbook.close true
end if
end sub
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.
"K1KKKA" wrote:
> i would like to place a simple yes no msg box, have tried the code i
> thought worked, but not having much suc...
Edit box, ::TextOutW(), and repaintingI have a dialog-based app with an edit box. I also have a CEdit class used
to manage the edit box. For various reasons I HAVE to use ::TextOutW() to
write information to the edit box because I'm displaying Unicode codes.
Everything works fine except when the app is covered and then brought to the
foreground again the data in the edit box is not repainted. I've tried to
repaint the data in the dialog's OnPaint() message but that didn't work. As
a test, and to get me by, I set a short timer in OnPaint() and then rewrote
the edit box data in the OnTimer() message. I know! I ...
how do I assign a variable to a check box or radio control?I need to assign the value of a radio control or check box when clicked on to
a variable, preferably using the SetTemVar macro.
Use the AfterUpdate of the control (if it's a stand-alone control), or of
the option group (if it's part of an option group) to SetValue (in a macro)
or assign the value (in code.)
Not sure if it's really a good idea though. Considerations such as:
- You can quite easily read the value from the form.
- Doesn't work in versions of Access before 2007.
- If it's a bound form, the tempvar would not be up to date when you move to
a different recor...