Create A Search Field on a Form
I have a form that allows the user to add a new record. Now I want to allow
the user the capability to change a record in the database, when necessary.
I want to create a search (or filter) on my date field. Do I need to create
a new form or can I use the same form for adding? Also how do I create the
Summing multiple fields on a form wrote:
> I have a form that allows the user to add a new record. Now I want to
> allow the user the capability to change a record in the database,
> when necessary. I want to create a search (or filter) on my date
> field. ...field chooser: deleting fields
I created new fields in several non-user-field columns (such as Contact
fields). But now I can't delete them and I have too many with the same name
that don't work. The "delete" button for fields in the Field Chooser is only
working with the User Fields. I have scoured the web and Help resources.
Nothing. Does anyone know how to delete fields from Field Chooser? Do the
fields actually "live" somewhere on the computer?
Did you create them in a view or on a custom form?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlo...When concatenating concatenates don't concatenate... #2
Thanks for your reply:
I'm using (a French version of) Windows XP Professional 5.1, with Exce
2003 for students and teachers.
The following formula in cell I1
derived from the formul
should produce the following content:
</title><style type="text/css" media="screen">@impor
"Basic.css";</style><style type="text/css" media="print">@impor
"Print.css";</style><meta http-equiv=&q...Count with two Conditions
Good Day to All
I got a colum with values like 2 , 3 , 4 , 5 , 9 , 7 , 8 , etc.
I would like to count how many values i got higer then 5 and smalle
Can anyone help me plse.
Thanks in advance.
Message posted from http://www.ExcelForum.com
> Good Day to All
> I got a colum with values like 2 , 3 , 4 , 5 , 9 , 7 , 8 , etc.
> I would like to count how many values i g...Syntax Error
For some background - I am usingExcel 2000, SP-3A.
1) I am going into DATA/GET EXTERNAL DATA/NEW DATABASE QUERY.
2) Selecting my ODBC source and connecting to the source with no issues.
3) Selecting a SINGLE table from the ODBC soucred database and then VIEWING
THE DATA OR EDIT THE DATA IN MICROSOFT QUERY.
4) Selecting the fields that I want to show in my query results (dropping
5) Choosing VIEW/CRITERIA and then dropping the DATE field in the criteria
section and enter in a date of the 01/05/2005.
6) When I then go RECORDS/QUERY NOW I received an error "SYNTAX ERR...When concatenating concatenates don't concatenate...
Can anyone help? When concatenating already-concatenated cells, th
result displays perfectly well in the Excel spreadsheet, but truncate
when the cell is pasted into a .txt file. It doesn't seem to be due t
Data Validation limits (having said that, selecting the entir
worksheet and doing Alt > Data > Validation > Validation criteria
Allow = Any value" did seem to solve the problem once, but only to com
back next time round). The truncation occurs sometimes after 8 or 1
chars, and sometimes after 20 or so, always at the same spot. If I cop
the cell into a fresh Excel...Notifying one form that another has closed
I have two forms in Access 2002: frmParent and frmChild. frmParent opens
Is it possible to notify frmParent that frmChild closed without frmChild
knowing about frmParent?
Seems like something that can be done with events (and implements?), but
I’ve never successfully used those statements or seen an example similar to
what I’m trying to do.
I would appreciate any insights and if this is possible a simple example
would be great!
No, frmChild would have to notify frmParent by populating a control on
frmParent in it close event.
Dave Hargis, Microsoft Access...Two years of Errors and Omissions...
I just saw as I added some new material this evening, that in two years, I and several
contributors have identifed <<<470>>> errors in the Microsoft documentation.
I expect to actually add a few more this evening, because I'm reading the Assembler, well,
it is hard to dignify the piece of trash that has been foisted off on us as
"Documentation", but, perhaps I might say, I'm reading the Assembler Imitation Reduced-Fat
Documentation Product*. Catch this:
OPATTR expres...Format of tick/checl box Word 2003 form field
Currently the format of tick boxes in my forms have a cross instead of a tick
- is there anyway to alter this?
Not using check box form fields, no. But see
http://gregmaxey.mvps.org/Add_Toggle_Objects.htm for an alternative that
doesn't require forms protection.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Louverril" <Louverril@discussions.microsoft.com> wrote in message
> Currently the format of tick boxes in my fo...Access Database with 3 users acts differently for one of us
Three of our employees have access to one database....no problems prior to
this. One of us got a new computer (same version of Access, tho). Since
then, the database appears differently for her. The database has a form with
two subforms....the first sub calls up the second, the second calls up the
third. On her computer, the first and second subs show up, but the third sub
is always blank. If she tries to enter info into the third sub, the record
disappears as soon as she makes entry into one field. Since it works fine
for the other two, we assume it has to do with her computer, no...Concatenate Expression with text string in Report?
I would like to concatenate the text string..."Birthdays in " with the
expression =MonthName(Month(Now())). Can someone provide the correct
On Tue, 18 May 2010 13:04:01 -0700, Steve Stad wrote:
> I would like to concatenate the text string..."Birthdays in " with the
> expression =MonthName(Month(Now())). Can someone provide the correct
="Birthdays in " & Format(Date(),"mmmm")
Please respond only to this newsgroup.
I do not reply to personal e-mail
="Birthdays in " & Month...sychronizing data between two servers
We just moved GP and its SQL data from one server to another. The old
server will be used as a backup server, should the new server ever go
offline. In the event that the new server does go offline, IT will take
backups of the SQL databases and restore into the old server.
The head of IT is wondering if there is some sort of automated means of
synchronizing the data between the two servers. Ideally, he'd like to press
a button on Friday or Saturday and have the new GP transactions and changes
transferred to the old server.
Is there a such way of accomplishing this?
chil...May I link two workbooks together.
I'd like to share a copy to others, but I'm afraid others
modify or delete my shared files. and I do not like to
backup files to shared folder once I update my files times
and times. So will I have a good method to link two
workbooks so that I can update workbooks on my local disk
and the linked shared files can be automatically updated.
I don't think xl was made for this kind of thing.
I'd reconsider making regular backups to make sure you backup the most current
> I'd like to share a copy to others, but I'm afraid ot...How to manage the From field with multiple accounts?
I have two email accounts in Outlook 2003, and as I understand it, they
have to share one inbox and I can have rules that forward them to a
sub-box. No problem.
BUT, when I send email which account shows up in the FROM field? When
they reply, which account address will it grab? I want to control which
is used as I compose emails. This is important so replies go to the
correct box. Make sense? Anyone know how I am to do this?
OK, I just found the Accounts drop list in new emails and that will
work, but is there a way to make it less goof proof and automatic -
like a two buttons for ...concatenate
I'm having real trouble with this and hope someone can help!
SELECT IngredientMaster.IMNumber, Trim(Concatenate("SELECT
WHERE IMNumber ="""" & [IMNumber] & """" ORDER BY
INGsAllergens")) AS Allergens
WHERE (((IngredientMaster.IMNumber) In (SELECT IMNumber FROM
IMNumber is a numeric field set as Long Integer.
When I run the query it returns fine EXCEPT that it's concatenating
ALL records per each IMNumber. For example t...calculate # of days from two different times
If A1=Date Reported, B2=Date Resolved, B3=Resolution Period
What formular should I use to:
1) calculate the resolution period in days, excluding weekends and public
2) display "pending" in the Resolution Period cell if the Date Resolved cell
does not have a time value
3) display "impossible" in the Resolution Period cell if the value in the
Date Resolved Cell is less than the value in the Date reported cell
4) display "invalid" in the Resolution Period cell if either the Date
Resolved Cell or the Date Reported cell has no values.
-...Report field size
I have added 2 fields to my invoice form (single invoice). How do I
force these fields to display the same text size as the rest of the
report? I'm using Report Writer.
Thanks in advance.
if you are working on a graphical report, you can click on the field and
press CTRL + D or go to Tools >> Drawing Options. select the appropriate font
size and click ok.
You may have to check the default font size of other fields so you'd know
what size to use.
Hope this helps.
"Billie Dee" wrote:
> I have added 2 fields to my invoice form (single...Formatting fields
I have a question on form with 5 possible selections. I have set each field
to a red background until a selection is made using conditional formatting.
I want to 5 fields to revert to a white background if a selection is made in
any of the five fields. Any suggestions.
Maybe this will help:
Arvin Meyer, MCP, MVP
"Anne" <Anne@discussions.microsoft.com> wrote in message
news:AAFA5762-58B5-4A32-9DD3-1DAE084570DA@microsoft.com....Tool bar in Table format
Iam using vc++,mfc and sdi and i want a Tool bar with Table format (Rows
and Columns ) and not in Row Format which is of Default and please let me
know how to do that
Thanks and Regards
Look at style TBBS_WRAPPED. Example DOCKTOOL in MSDN shows how to use it.
Ajay Kalra [MVP - VC++]
"Suresh" <email@example.com> wrote in message
> Iam using vc++,mfc and sdi and i wa...CONCATENATE #5
We have this section of code that works it joins the text in the
ActiveCell.FormulaR1C1 = _
The result is "four five six seven"
What we are trying to do is split the result using the code below to
the following result
ActiveCell.FormulaR1C1 = _
"=CONCATENATE(R[-25]C,"" "",R[-25]C, & Chr(10) &
,R[-24]C,"" "",R...Table field length limit alternative
I need a table which will hold a user's answers to about 27 survey
questions. Multiple users will use the database to enter responses for
each question. My problem is that some questions are more than 255
characters long and it isn't practical to use such long field names to
hold the actual question in. Most of the questions require responses
that are either memos, dates, numbers and yes/no fields. What would be
the best way to design a table that can hold 27 questions and the
multiple responses for each? I'd like the possibily to easily make
changes to the questions...Duplicate charts from 4 worksheets on to one
Is there a way to duplicate 4 different charts, shown separately on different worksheets, on to one worksheet showing all 4 charts, without having to recreate each one of the charts?
That's easy, simply copy the chart (click the chart and press the Ctrl and C
keys) and paste it (Ctrl and V keys) into the common sheet.
"N~" <firstname.lastname@example.org> wrote in message
> Is there a way to duplicate 4 different charts, shown separately on
different worksheets, on to one...Adding time to date field
On the quote/order form, I want to have a custom made date field to be filled
automatically with the date "createdon" + 1 day.
If this is possible in an easy way, eg. by using workflow, could someone
please explain exactly how I should do it?
Workflow can help you on this.
In a new workflow rule on create event;
Insert Action -> Call Assembly -> Date and time functions -> Add date and
Set parameter for this workflow accordingly.
Than update the custom field with the value returned from workflow assembly.
for your information, this can also be...viewing formulas/concatenate
I'm attempting to use the concatenate formula (something that I've
After I enter the formula and press enter, the formula, and not the
result populates the cell. I know that the formula worked because when
I press the = sign, I can see that formula result. I just cannot see
it in the cell. Any thoughts?
Excel likes to help.
Try this on a test worksheet.
Select A1 and hit ctrl-; (to put the date in the cell)
now select B1 and type: =a1
Notice that excel changed the format of B1 to match the format in A1.
Now format D1 as Text.
put ASDF in D1
put =D1 in E1
You see ...concatenate two columns
I would like to concatenate the text in Column B with the text in
Column A and place the results in Column K. Keep in mind that Column
B and Column A may vary in length - meaning that
Column B may have 37 rows of text and and Column A may have 23 rows of
In C1 enter:
=A1 & B1
and copy down as far as you like.
> I would like to concatenate the text in Column B with the text in
> Column A and place the results in Column K. Keep in mind that Column
> B and Column A may vary in length - m...