Unbound form/Add rows
Hello. I have an unbound form. I want to know if there is a way I can
add rows to the form in the same way a bound form works. So, when I
start a new record in the last open row, I want a new row to add to
the end of the form, so I can always add a new record. I have the
form unbound because I do not have the data enter into the table until
after I finish working on all the information in the form.
You can't have a new "record" on an unbound form because, in fact, you don't
have any "record," just a bunch of textboxes you've filled in! When people
First thank you in advance for any help. I want to put a search box on the
first sheet of my program to enter data, either a name or an assigned number,
and have it search for and go to that line of information on another sheet.
Can I do this or do you have another suggestion?
This should do it. Change sheet name and column numbers to suit
mv = InputBox("Enter name or number")
If IsNumeric(mv) Then
mc = 4
mc = 1
Set mf = .Columns(mc).fi...sent mail appears in my in-box
How can I change settings to prevent e-mail that I send
also going to my in-box?
Thank you in advance
Under Tools->Options->Preferences->Email Options->Advanced Email Options, do
you have the box checked to save mail in the same folder? Do you have any
rules that affect mail after it is sent?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
TopCat <email@example.com> asked:
| How can I change settings to prevent e-mail that I send
| also going to my in-box?
| Tha...Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an
Access Database. The count of the records is then stored in a
For most of the queries, the figure stored in the Worksheet matches
the number of records if you run the query in Access. But for certain
queries, the count of the records does not match the number of records
when the query is run in Access.
If I change the query to a make table query and then base another
query on that table, the results are correct.
Can anybody suggest running the query from Excel would results in a
different number of records bein...CPropertySheet create failing when adding to dialog box
I am having problems with a class that I made that inherits from
CPropertySheet. I need to add this class to a dialog box with the
m_appPropSheet.Create(this, WS_CHILD | WS_VISIBLE, 0);
m_appPropSheet.ModifyStyleEx (0, WS_EX_CONTROLPARENT);
m_appPropSheet.SetWindowPos(NULL, 0, 25, 0, 0,
SWP_NOZORDER | SWP_NOSIZE | SWP_NOACTIVATE);
...Managing Data Table
I need help to wrap the tex in Data Table. If any one knows how to do it,
please let me know. Thanks for your help in advance.
What version of PowerPoint are you using? What kind of table is it and how
did it get there (e.g. insert -> table, or a table connected with a graph)?
If it's a graph, is it an Excel graph or an MSGraph graph?
MOS Master Instructor
"Yogesh" <Yogesh@discussions.microsoft.com> wrote in message
news:F68FDA89-6289-4341-8886-54C580...Bank Rec Record Type Code?
We're trying to set up Bank Rec and can't figure out how to identify
the record type code that is required by GP 8.0. Our bank doesn't
provide us with a record type code so how can we set up bank rec
correctly? The fields we get are:
Any help would be greatly appreciated.
If you're attempting to set up "Electronic Reconcile" I believe that the
record type code relates to the records coming from your bank. You need to
specify which records are headers, detail, footers. There ha...OWA session Timeout (Form Based Auth )
Wondering if it is possible in Exchange 2003 SP2 to have different OWA
timeout for different users using the same OWA HTTP VS to connect...
If not, can a second HTTP VS on the same server as the first have different
timeout, or is it a server setting ( I think it is done trough OWA web admin
tool ) !!!
...Export Access Record to Specific Cells in Excel
I'm looking for suggestions on how to export data from an Access table or
Query into specific cells of a Worksheet. The table I'm importing will
always contain a single record only. For example, I'd like to export data
from Field1, field2...etc in an access table to Sheet2!A3, Sheet2!B3...etc.
Any sugestions would be most appreciative.
...How to add time in mini second
i don't know how to add time in mini second
eg. 1min 20 sec 09 mini sec plus 30sec 04mini sec.
First format A1 thru A3 as:
Custom > hh:mm:ss.000
in A1 enter:
in A2 enter:
in A3 enter:
and you will see:
just remember to enter the leading hours and minutes, even if they are zero!!
Gary''s Student - gsnu200838
> i don't know how to add time in mini second
> eg. 1min 20 sec 09 mini sec plus 30sec 04mini sec.
...Getting Combo boxes to change options based on other Combo boxes.
Using Excel 2007. I am trying to create either Form Control Combo Boxes or
ActiveX Combo Boxes that will change the selectable options based on
selections made in previous combo boxes. I am having a hard time finding any
information that will work for me. Can someone tell me how to make 5 combo
boxes change available listed options when specific options are selected in
another combo box? Please? I've been working on this for a very long time
without success. I've tried using Data Validation, but my formulas are too
long for all the different possible combinations.
I am working on a browser based application, currently using ShAutoComplete
in order to provide Auto complete facility for combo box used to enter the
address of page that you want to browser. Used ShAutoComplete with
SHACF_URLALL to show list of recently browsed web pages and webpage in
Now how can I add address of web page browsed through my application into
that list ? Means If I browser http://msn.com in my application, then it
should go in the recently browsed page list that ShAutoComplete uses.
Awaiting for your comments.
The interface you are looking for ...Add lines to a renewed contract
Whenever I try to add a new contract line while renewing a contract (ie the
customer has purchased an item during the year and the contract template is
coverage dates), the system rejects the new line with "invalid coverage
dates". Doesnt seem to matter what dates are entered.
Please advise how to add new lines while renewing a contract.
...add external application icon on toolbarr in R8
Kindly have a external application icon (like Frx) on the toolbar available
that when you click on the icon it opens up the external application
automatically. Having the Shortcut menu added to the toolbar is close, but
not exactly what we are looking for. If there is a way to add the actual
shortcut, such as a Smartlist, or an external application as an icon to just
click on to open it would be great.
I think that capability went away with Release 8.0. 3rd parties who have
full blown Dexterity apps can still do it, but I think when pallets went
away, so did this.
"mult...Check query shows voided checks too!
I am running this query but its also showing voided checks! How can I make it
now show voided checks?
SELECT VCHRNMBR AS PaymentNumber, VENDORID, DOCDATE AS CheckDate,
DOCNUMBR AS CheckNumber, DOCAMNT AS CheckAmount
WHERE (DOCTYPE = 6) AND (DOCAMNT > 25000)
Add this to the end of the WHERE clause
AND (VOIDED = 0)
Microsoft GP/SBF Specialist
"Michael@nyresume.com" <Michaelnyresumecom@discussions.microsoft.com> wrote
in message news:7163A485-9E90-48C7-B931-C989827039D6@micros...Invalid Add-in error message
When I open Outlook 2003, I keep getting the following error message:
C:\Documents and Settings\Amanda\Application
Data\Microsoft\AddIns\outlvba.dll is not a valid Office Add-in. Then I am
booted from Outlook. How can I fix this?
Try renaming outlvba.dll to outlvba.bak. Go to the add/remove applet in the
control panel and perform a detect and repair on Office/Outlook 2003.
ps - outlvba.dll normally exists at \Program Files\Microsoft
Office\OFFICE11\ADDINS. I've never seen it under a user profile.
"urbangirl" <firstname.lastname@example.org> wrote in me...German Spell Check
We are a German based Company in the US.
To make life easier for our German Colleagues, we would like to implement
the German spell check option.
Du we have to purchase the program, and if so, how do can we purchase the
Thanks a lot,
> Hello there,
> We are a German based Company in the US.
> To make life easier for our German Colleagues, we would like to
> implement the German spell check option.
> Du we have to purchase the program, and if so, how do can we purchase
> the mentioned.
> Thanks a lot,
&g...WMP 11 will not "add to library"
I was out one day when the power went out. My computer obviously shut down,
and as a result WMP shut down improperly. This hasn't been the first time,
and whenever it does, I just start up my computer again, log in, and WMP 11
is working just fine. There has also been some instances when the library has
been corrupted, and I've just re-added my files to the library again.
However, this time it's different apparently; WMP 11 refuses to add ANYTHING
to it's library, and whenever I choose a folder for it to monitor, it does
absolutely nothing, as opposed to adding ...Increase data type size in GP table?
I don't know whether this is supported or not, but we're planning to roll out
the HR module on GP9, and one of the fields that is missing for job
applicants is an email address. We'd like to use an extra field to hold this
data, but the field length is too short to adequately contain that
I'm wondering if I can change the length defined in the SQL table structure
for that particular column, or, if doing so will likely mess up something
else (stored procedures, mappings, etc.).
Thanks in advance!
Technically, yes. However, if you do that, you...alter the content of the from box in a message
in outlook my "from" box automatically defaults to the email from me and that
is the email address issued to me by my ISP that I entered at inception.
I want my default email to read a different email which corresponds not to
my ISP but to my web site and email service by my web hosters?
for example my outlook says that my emails are from email@example.com
in my signature block i type my small company details and include my company
website and my email which is firstname.lastname@example.org etc how do i get this
email to appear as a default in the "from" box?
Enter i...Vlookup from Combo Box
I am trying to use the Vlookup function from a Combo Box.
The combo box will contain currencies (USD, JPY, EUR). Once a user selects
a currency, the lookup will use that currency to find the exchange rate from
Something like this
Any help would be much appreciated.
If it's a Combo Box from the Control Toolbox toolbar, you
can set the "LinkedCell" property (right-click on the
combo box and go into "Properties") to a worksheet cell.
When the user makes a select...how can we transfer data from child dialog box to parent Dialog Box. #2
hi guys, i have created modalless child dialog box by parent dialogbox
using UI Thread . now i want to do 2 things first i want to transfer
CPoint variable from child to parent and second i want to call
OnLButtonDown() function of parent DialogBox. i have hint but not
proper please help me to complete this one.
SendMessage(m_pParent, WM_LBUTTONDOWN, x,y); // from child side
void CHRS_MoleDlg::OnLButtonDown(UINT nFlags, CPoint point) //on
parent dialog box
first of all tell me is it possible if yes then what will be "x" and
"y" so that they can convert into CPoint v...Using Drop Down box that can be edited
I have created a form in Word 2007, but would like to have the drop down box
I created to also be overwritten by the user if the items in the drop box
doesn't include their choice. Thanks
One possibility would be to replace one of the items in the list with a user
input item. You could do this with a macro run on exit from the dropdown
Assuming the dropdown field Dropdown1, put an item at the end of the
dropdown list "Enter your own value" then run the following macro on exit
from that field
Dim sChoice As String
Dim fDD As FormFie...Help with complex table lookup
I have a ranged defined in a spreadsheet that consists of a bunch of
values. Some of the cells in the range may be empty.
I also have 4 hidden lookup tables at the bottom of my spreadsheet.
Using these 4 lookup tables, I know how to use the vector form of the
LOOKUP function to determine the following individually:
- Given the value in one cell, what is the corresponding
"route" (lookup from table 1)
- Given the value in one cell, what is the corresponding "set" (lookup
from table 2)
- Given the value in one cell, what is the corresponding
"slot" (lookup from t...Google Search Add-in update
If you use this add-in then update it to version 6.01
The product specific Knowledge Base search is not working in version 6.0 anymore because
Microsoft changed there Knowledge Base search. I update the Excel add-in to version 6.01 to fix this.
Regards Ron de Bruin
Thanks Ron. Will go get and implement.
"Ron de Bruin" <email@example.com> wrote in message
> Hi all
> If you use t...