Problem adding new record in form view
I have inherited an acccess database and have had to do some troubleshooting
on an error message which is now sorted out.
I now am unable to add a new record in form view, however if I enter the
information directly into the table there is no problem.
Please could you help with what might be going wrong?
Open the form in design view. Open the properties window for the form. Is
the Allow Additions property set to yes?
Microsoft Office/Access MVP
"SnooziSuzi" <SnooziSuzi@discussions.microsoft.com> wrote in message
The "Order" entity in CRM has a number of status's (Active, Fulfilled,
Cancelled, Submitted and Invoiced).
From the Actions menu on the Order form it's possible to Cancel and Fulfill
an Active order - and doing so changes the Order status as you would expect.
1) Invoicing the order (which creates an Invoice record) doesn't change the
status of the order to Invoiced
2) I can't see how to change the status to Submitted.
I expect it's possible to do both of the above programatically. However is
it possible to do it through the CRM UI?
On Jun 14, 9:10=A...Make sure no running instances of MS Word
I need do some work which do not want any instances of MS Word existed.
How to make sure no running instances of MS Word?
and see if the PROCESSENTRY32 's szExeFile has winword.exe substring.
"lotus" <email@example.com> wrote in message
>I need do some work which do not want any instances of MS Word existed.
> How to make sure no running instances of MS Word?
...putting date and time together in 1 cell
Hi I need to convert New Zealand time to UK time, the time
is displayed in two parts
How do i get cell A and cell B into one cell with the
format dd/mm/yy hh:mm:ss and then I can just minus 13
any ideas please.
and format the cell as dd/mm/yy hh:mm:ss.
>Hi I need to convert New Zealand time to UK time, the
>is displayed in two parts
>How do i get cell A and c...Office 2003 Opening a new Excel Doc.
I just updated to Office 2003 and everytime I open up a new workbook a blank
workbook name PERSONAL opens as well. How do I change that from happeneing??
Window>Hide and save the personal.xls
When you record a macro you have the option to save the macro
in this hidden workbook so you can use the macro in all your workbooks.
You can find the file in your Xlstart folder
Regards Ron de Bruin
"Jesse" <Jesse@discussions.microsoft.com> wrote in message news:65505D55-31EB-4BAA-A32D-B052F70E03AD@microsoft.com...
>I just...Sum based on range values
I need to sum a column A, but only if values in an adjacent column B>0.
Therefore the example below should sum to 10 (only including the first 3
Ideally this should be a formula in a cell, not a macro.
Any ideas? It doesn't sound complicated, but I can't get my head round it.
Thanks Julie. I knew it had to be straightforward. Just a case of knowing
which function to use.
"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> us...Formatting 0 values to show blank cells
I am using the =IF(ISNA(VLOOKUP(...)),0,VLOOKUP(...)) to return a zero value.
For printing purposes I need the 0 to not show in the cell (blank cell). I
can do this by using the accounting format, but a dash (-) still shows in the
cell. The sheet is protected to protect the formula. How can I protect AND
not show anything in the cell WHILE keeping the value at "0"?
You can use set the custom format to
See Worksheet and Excel table basics > Formatting numbers in Excel help file
> I am using the =...What happened to the New Form Dialog box; are there still autoform
...database query select the "top record" only
good afternoon All,
I would like to know the SQL to select only the "top" record of a query
sorted by date/number or operation of numbers e.g. max of date, min of
stock, etc so I only retrieve the first and most important value instead of
a set of several values.
here below an EG from a query I use every day:
SELECT pordtl.pdtiid, pordtl.pdtvds, pordtl.pdtluc, pordtl.pdtvum,
pordtl.pdtwhs, pordtl.pdtode, pordtl.pdtvdr
FROM beth.pordtl pordtl
GROUP BY pordtl.pdtiid, pordtl.pdtvds, pordtl.pdtluc, pordtl.pdtvum,
pordtl.pdtwhs, pordtl.pdtode, pordtl.pdtvdr
HAVING (pordtl.pdtiid I...insert new row doesn't add formula
I have a table A2->M100
In the M Column I have a sum to calculate the total of that row
=SUM(A34:N34) for example
Now if I want to add a row into that table, I click on the number o
the left, that highlights the row then I go insert>>row and that keep
the formatting of the cells.
BUT it doesn't add the =SUM(A54:N54) in the M column, and so I have ha
to edit each cell by hand to get the correct formula.
Is there an easier way to add a row and keep fomulas within that row
but obviously automatically change the numbers to suit the row
Message posted from http://www.ExcelForu...no text on subform when there are no child records
Your help is appreciated. I'm relatively new to Access with no VBA
My form calls GrantID and Grant# from tblGrant. The subform shows
current records from a query of tblQuestion and tblQuestionDescription
(tblGrant has a 1-to-many relationship with tblQuestion). When I
created the subform, I chose to have the subform fields related to
The challenge...if a Grant# doesn't currently have any related records
on tblQuestion, the labels and fields on the subform do not show - the
subform is blank. I want the user to be able to add records to the
subform that populate tblQ...Reset Tab Order on Template Contact Detail Form
I have edited the design of the Contacts Detail Template form. How do I reset
tab order to start with the new text boxes I have entered? In Design View I
selected all of the text boxes, selected Tab Order, and for the template only
"tabContacts appears for the Tab Order rather than the list of text boxes in
the tab order. The new items I added are on the list, but in order to make
the form work, I had to move them to the top of the form. When I return to
form view, select Save and New, the tab goes to my new tab "Category1" then
"Category2", then it goes to...Make combobox blank in macro
I use a wizard to create a combo box to find the record in my form. It
creates macro automatcially. Works fine. After finding the record, I
want to set the combo box to null or "" but need help add that line in
Sorry but not many people use macros (me too) so can’t really be help there.
But try this.
I assume your macro is search on a name ?
You have the ID field in the combo and the name and the ID field is the
bound column of the combo ???
1st MAKE A BACKUP OF YOUR DATABASE
Then – open you form in design view
Right click the combo an...Formula Error
I have a list of codes in F$19:F$1500.
I was attempting to use the following code to assign a number to each
unique value in the list and repeat the previously assigned number if
it is duplicated.
This works for the first 15-20 numbers, but returns an error (#n/a)
afterwards as if the code stopped working.
I have tried EVERYTHING... Same result each time.
=countif() treats everything as text.
So the text string ="1" (or '1) will be counted as a match as well as the num...VALUE error message
I would like I5 to equal F5+G5-h5. I get a value error message.
one or more of the cells F5,G5 or H5 probably have text in them, either
a number entered/pasted as text, or a "blank" made by pressing the space
bar (and inserting a space character).
For the first problem, copy an empty cell, select F5:H5 and choose
Edit/Paste Special, selecting the Values and Add radio buttons, then
click OK. This will coerce any "text" numbers to real numbers.
For the latter, use the del key or Edit/Clear/Contents rather than the
spacebar to clear the cell.
Note that SUM(F5:G5,-H5...Maximum value to use autofiler feature in excel
Hi, does anybody know the maximum value to use autofilter
in ms excel? I heard my friend told me that excel could
filter only select data is less than 1000. He told me that
he has 4000 row and use autofilter, an expected record is
more than a thousand but the record display only 1000
maximum. I want to test like him too but I don't have any
file that contain alot many thousand of record.
Does anybody have any idea?
"Roath Kanel" <firstname.lastname@example.org> schrie...if the cell value exceeds the limit to have a dialog box appear
Is there a way that, if the cell value exceeds a certain limit, a dialog box
Thanks for any assistance.
Check Data Validation:
Select the cells
Allow: (check out the number options: whole number, decimal, etc)
Does that help?
> Is there a way that, if the cell value exceeds a certain limit, a dialog box
> would appear?
> Thanks for any assistance.
Here's the scenario -- on an Expense Report:
If an employee was to fill in any amount in the &...how make outlook 2003 default and keep NG reader?
I have a perplexing problem concerning outlook express 6.0 and outlook 2003,
both of which I have installed on a new laptop running xp home.
I set up express first, and so it was the default email and newsgroup
client. Subsequently Outlook 2003 was similarly configured. Here's the
interesting part: If I set outlook 2003 as the default, the ability to go
to the news reader goes away. If I set Express as the default, it comes
back and I can get to the newsreader from either one.
Any idea on how this can be resolved so the option to use outlook 2003 as
the default newsgroup r...using find and replace it's making me look in another file to upd
I have used the find and replace function several times in the spreadsheet to
update the fromulas monthly. For some reason when I use it this month it
wants me to look in another file to "update values"? There is not another
file and there is no way for me to use the find and replace.
...Sumproduct but only first time corresponding value is seen e.g. un
Name Race Speed Avg Speed Track Month
Joe 2:12 2:15 OFCF Jan
Joe 2:28 2:15 ADL Feb
Mary 2:14 2:07 ADL Jan
Joe 2:15 2:15 ADL Feb
I already have sumproducts in place to count how many participants raced in
each month, how many at each track, etc.
The last piece I need to add is the number of people for a given track on a
given month, who had an /average/ time of over 2 minutes. But, I have
repeat...can i not allow duplicate values in the same column?
is there a way to set columns to not accept duplicate information?
Take a look at
In article <4765FB37-8F89-4220-A901-B289FDCDE23F@microsoft.com>,
excel newbie <excel email@example.com> wrote:
> is there a way to set columns to not accept duplicate information?
If the values are typed in you can use this:
"excel newbie" wrote:
> is there a way to set columns to not accept duplicate information?
...Adding a New Account when Regarding from Outlook
When I Regard an e-mail from Outlook and it prompts for an Account, I select
"New" to add an Account, it only allows me to enter one word for example XYZ.
If I enter two words for example XYZ Company it prompts up an error message
"name is null or not an object". Does anyone have any insight to this?
That error originates from the Name attribute of the account entity
not being filled (It is a mandatory field).
make sure that the seasrch result doesn't return faulty data.
My suggestion would be to go through SQL server directly by querying
the view "filteredA...Creating a new excel template like SFO quote mailmerge template
I want to create an excel template for calculation purposes on quote
Print Quote for customer on SFO lets you create a word mailmerge
template. Just like that I want to create a custom menu item which
will let me bring up an excel template, on which I can do calculations
and pass that calculation back to quote. Any pointers on how do do
Thanks in advance for the help.
...How to put tic marks in brochure for folding accurately?
I want to fold the brochure perfectly but I can't figure out how to put the
marks in to show you where to line the paper up for folding. This is in
ChristineC <ChristineC@discussions.microsoft.com> was very recently
heard to utter:
> I want to fold the brochure perfectly but I can't figure out how to
> put the marks in to show you where to line the paper up for folding.
What kind of folding is this brochure? A single centrefold (booklet fold),
or a tri-fold or four-panel brochure?
Ed Bennett - MVP Microsoft Publisher
A tri...excel open in new window
How do I get excel 2003 to open new windows(instances) when launching xls
files - like in excel 2000?
Separate windows--but the same instance:
Tools|Options|View|check windows in taskbar
> How do I get excel 2003 to open new windows(instances) when launching xls
> files - like in excel 2000?
Yes, but if I close one file with the button in the top right hand corner it
closes all windows. I can close one at the time on the task bar by expanding
and then closing one file but trying to close just one at the top right
closes all. Is there a way...