Autonumber in a formI have a form that allows data entry and additions only. What I would
like to do is have the record number pop up in a field on the form.
Im not sure how to write the code for the event procedure to be able
to do this. What would be convienient is that the number would pop up
as soon as the form is opened.
any suggestions?
Tyler
Perhaps you and I have a different understanding of "Autonumber"...
The Access Autonumber is a system-generated unique key value, whose only
(OK, whose primary) use is as a unique row identifier. Since you have no
control over the value Access come...
Problems filling data into custom field on Account formI'm having some problems appending a value to a field by using Javascript in
ONLOAD on the Account form.
In a custom form I've created, however, I don't have that problem. In that
form I use this simple code in ONLOAD, and it works fine:
crmForm.all.fieldname.DataValue = 'TEXT';
In the Account form however, in ONLOAD I try to fill a custom field with some
text using exactly the same code, but it doesn't work - the field remains
empty.
I have admin rights, so I guess that's not the problems. Both fields are
"nvarchar>text".
I hope there's a...
Some forms and swithboards in design view show up blank in form viI'm a financial analyst, expert excel user, and began using Access 3 months
ago to solve a specific problem. Following along with Jeff Conrad's book, I
wrestled with the concepts until I had a fairly servicable application
designed to replace a couple of hundred spreadsheets and versions thereof. I
also built considerable strength hauling the book to and from the office, in
its own briefcase, everyday. The result is better than I expected and
especially efficient in consolidating calculations that, until now, could
only be done across a tedious network of linked worksheet...
Updating New Record formHi,
I have two tables set up: tblDeals and tblEquip, they have one field in
common called: DealCode.
I have a query qryEquip that links the two tables based on the DealCode
field and adds other tblDeals fields like Customer, Description, etc, to help
identify the deal but only the DealCode is stored in the Equip table.
Form frmEquip is based on query qryEquip and it is working fine.
Here’s what I’m trying to do: When I add a new Equip record I want to be
able to look into the tblDeals for the right deal and then pass the DealCode
to the frmEquip, then have the frmEquip pull the rest o...
Bind a Form to a RecordsetI am trying to bind a form to a record set using access 2003. However, I can
not edit the data in the form. I made sure that the record locks are set
correctly. Does anyone know how to bind a recordset to a form and allow the
records to be edited (i.e. not read only)? I used the following code:
Note: the "frm" and "rst" ojects are defined as public variables in a module.
Private Sub btn_Click()
Set frm = New Form_TestForm
Set rst = New ADODB.Recordset
rst.Open "testTable", CurrentProject.Connection, adOpenKeyset,
adLockOptimistic
Set frm.Recordse...
Creating a transparent background for a radio button on my formI am using Word to create a form. I used the Legacy Controls to add radio
buttons to the form.
The radio buttons are in a table with a colored background. While in Design
Mode, I went into the radio button properties and set the BackStyle to '0 -
fmBackStyleTransparent' and the background seemed to become transparent.
However, as soon as I leave Design Mode the radio button's default to a
white background on top of my colored table cells.
And at this point, the white background seems to write over the table
borders making for a very messy appearance.
Does a...
Form locking upI've completed my own Linked Table Manager wizard, so that the connections I
create to SQL Server and Oracle database on my network don't require a DSN
(DSN-less connections). This wizard exists in its own mda file, which I have
added as a reference in several of my databases.
In my test database, this wizard runs great. I've got a command button that
calls a function (fnRefreshLinks) that exists in the wizard. It opens a
form, refreshes a list of the linked tables, tests the link, and provides me
with some options.
When I run this same function from another database, it...
THIS_FILE' : redefinition; different storage class while changing setting from /MD to /MDDHi,
I working in finding out the memory leak in the application which was
developed in vc++2005. I am using _CrtMemCheckpoint function to find
out the memory leak these function will be working only when the
application is in debug mode and the project setting should in /MDD
or /MTD .
When ever I change my setting from /MD to /MDD I get a compiler error
Error 251 error C2370: 'THIS_FILE' : redefinition;
different storage class
i.e error is at
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
#pragma once
static char THIS_FILE[] = __FILE__;
#endif
...
Publishing forms to Organizational FormsWhen publishing a form to organizational forms I get the
following error message. There are no articles in the KB.
"an error occurred while going to this folder"
Exchange 2000
Outlook 2002
All permissions have been checked and are okay.
If there are any REAL ideas about what is going on in
Exchange, please post a reply.
Thanks to all!
...
refreshing formI have a form with a combo box field that references a table so we can keep
information in the field uniform (i.e. "Place",not "Pl."). At times when
filling out the form there is a new word not in the table being refereced to
by the combo box.
From the main input form, I select a button named "DB Admin"; it opens a form
with buttons to all the different tables containing information that we want
to keep uniform. I open the form for the referenced table, add the new word,
close the form, and close the "DB Admin form". I am now back to the main
input ...
Form warningHello,
I have Office XP with SP-2.
When I try to open a contact which has a special form that I designed, it
gives this message first :
This form contains an activex control which may be harm to open on this
computer ...... and then askes yes or no, is there any way to disable this
warning assuming it is always yes?
thanx for any help
I am having the same problem for a modified Calendar form. Did you get any replies on how to fix the problem?
"M K W" wrote:
> Hello,
> I have Office XP with SP-2.
> When I try to open a contact which has a special form that I designed, i...
Bind a Textbox in a FormI have a table containing several Projects and its Phases.
Now I need to create TextBoxes in a Form to return the totals for each
phase. This means I need 3 TextBoxes:
I made a query that Counts the total of projects in each phase:
Query_Projects_Phases
Phase CountOfPhase
Pre-project 1
Portfolio 45
Execution 7
One TextBox would be bound to the "Pre Project" CountOfPhase field from the
query (in this case the TextBox would show1);
the other TextBox would be bound to "Portfolio" CountOfPhase field from the
query
(in this case the TextBox would ...
MFC Appwizard not allowing CHtmlView base classI have Visual C++ 6.0 with Service Pack 5 installed.
I have been trying to create a browser-like application as described in the MSDN Library by using the MFC Appwizard (exe version). The instructions indicate that in the last step of the Appwizard, select CHtmlView as the View base class from the dropdown list, but when I use reach this point, CHtmlView is never in the list of available base classes, no matter what settings I try. I am creating a SDI with Document/View Architecture support, as per the instructions in the MSDN Library. I have also performed a full reinstall of Visual C++an...
Word Content Controls Restricted Document Fill in formsI have a word (2007) document that i need to restrict to fill in forms due to
the need of Checkboxes.
When i do restrict the document and try to edit the text in my Content
Controls (Plain Text) i cannot start writing or editing it at all unless i
step into it with my arrowkeys. If i do this once in any content control the
rest starts working and i can start clicking on them and it allows me to edit
it.
My dropdownlist(wordname?) works fine though.
Anyone have a clue bout how to solve this? or whats the problem?
/Thanks in regards
/Eric
Hi Plaskdex
I have the same ...
Selecting a Specific Record Form from a subformI have a form with a subform that I want to select a field from and have it
open another form with the data selected from the
sub form.
I was able to get the operation to work in the subform using the following:
Under Parameters of the first field of the subform -- Open4Edit_StationInfo
Open4Edit_StationInfo used the following command:
FindRecord
Find What: =[Forms]![Station Info Subform]![Call Sign]
Match: Whole Field
Match Case: No
Search: All
Search As Formatted: Yes
Only Current Field: No
Find First: Yes
The above works when I run the form "Station Info...
OWA 2003 form-based authenticationHi all,
Can we undo the OWA 2003 form-based authentication? Even I unchecked the
OWA 2003 form-based authentication in http vitual protocol, but is's still
in effect.
Thanks.
Did you restart IIS (iisreset)?
Nue
"Jane" <Jane@discussions.microsoft.com> wrote in message
news:BCFBE035-FFE4-4A02-B827-B33DE5954D51@microsoft.com...
> Hi all,
>
> Can we undo the OWA 2003 form-based authentication? Even I unchecked the
> OWA 2003 form-based authentication in http vitual protocol, but is's still
> in effect.
>
> Thanks.
>
You probably have to...
Form On Load CodeHello,
I am trying to create an event where the code will look for no results after
a query. If there are not results I want a prompt to ask the user to add
Yes/No message box. Once they select either yes or no then I want the forms
to open. I hope someone can help.
Private Sub Form_Load()
Dim rst As DAO.Recordset
'Specifies to User if no record found then add
Set rst = Me.RecordsetClone
If rst.RecordCount = 0 Then
Dim Response As Integer
Response = MsgBox("Agreement Not Found. Please make sure it was typed in
Correctly. You may need to add the Record. Do you want to Add?"...
Updating in a Form with a Query assigned to the FormI need to know how to make a form updatable when a query is assigned to the
form. It tells me that the query needs to be updatable to allow fields to be
updated.
On Mon, 25 Feb 2008 12:26:01 -0800, Sorting in a Graph
<SortinginaGraph@discussions.microsoft.com> wrote:
>I need to know how to make a form updatable when a query is assigned to the
>form. It tells me that the query needs to be updatable to allow fields to be
>updated.
A Form cannot make a non-updateable query into an updateable one. You need to
fix the Query instead!
Perhaps you could post the SQL view of the ...
finding last non empty cell in a column
I am trying to find the last used cell in a column and then select tha
entire range. The activecell here is "B1". What is happening is th
column I am working in has a blank cells within the column so when thi
code runs it the selected range is from B1 down to the first blank cell
I need it to go all the way to the last used cell in the column.
Any suggestions?
Range(ActiveCell, ActiveCell.End(xlDown)).Select
Thanks,
Crai
--
cparson
-----------------------------------------------------------------------
cparsons's Profile: http://www.excelforum.com/member.php?action=getinf...
How do I create a form in Excel that I can send to be filled out?I want to create a form in Excel that I can send out so people can fill it
out electronically and then send it back to me. I need lines in the form and
when I add lines I have to widen the column and then it messes up the
previous wording. I know it can be done but not sure if I have to protect
it, create a template (how do I do that), or lock some of the cells. Help!
For lines have you considered simply bottom borders?
i.e. wording in A1 bottom borders on B1:E1
Or lines drawn from the Drawing Toolbar.
No need to widen any columns.
Save the workbook and send it out...
Class array problemI have a class (stuff) with a m_name member.
I can:
stuff* pstuff;
pstuff = new stuff;
CString name = _T("Ralph");
pstuff.m_name = name;
I can't:
stuff* pstuff;
pstuff = new stuff[3];
CString name = _T("Ralph");
*(pstuff+0)->m_name = name;
I get an error C2440: '=': cannot convert from 'CString' to 'const WCHAR'
why have things changed and what would be a good solution?
--
Just Al
I meant to use pstuff->m_name = name;
in the I can: code
--
Just Al
"Al" wrote:
> I have a class (stuff) with a m_name member.
> I can:
&...
Duplicating reocords from main form and subform receiving Runtime Error 3022I am trying to develop a command button that will duplicate the main form and
the subform information and save it to another record within the same tables.
I used Allen Browne's program and modified it to fit my tables. At first it
would copy the main form and not the subform data so I made some changes and
now I am getting the Runtime error 3022. I have worked on this off and on
for about 2 weeks. Any help on getting this to run will be greatly
appreciated. Below is my code:
Private Sub Command78_Click()
'On Error GoTo Err_Handler
'Purpose: Duplicate the main ...
Form FieldsI have created a form for use by others. I used the Text form fields format
when creating the form, my problem is the main text in the form does not stay
locked in place. When we try to type to fill in the form fields it moves the
main body text. I have tried using the Document Protection tab and telling
it to allow formatting only in the form fields but that still does not
prevent the other text from moving. I did this in word 2007. Any idea on what
to do to lock the main body in to allow filling in just the Form fields.
Hi Michael,
The simplest way to gain control over the ...
Removing Exchange?Hi,
If I plan on removing an Exchange box from my domain can I simply run
uninstall on Exchange and then remove the box from the domain and call it a
day? The box is a simple domain member server and formerly functioned as my
front end box. Anything special I sould be aware of?
Thanks,
Dan
Aloha Dan,
See if this helps: http://www.msexchange.org/tutorials/Remove-Exchange-server-entire-Exchange-organization.html
-Ben-
Ben M. Schorr - MVP
http://www.rolandschorr.com
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm
> Hi,
> If I plan on removing an Exchange box from m...
Change or hide Form Group Box outlineCan I change the color of the Group Box outline. It is currently
black, and I would want it white so it is invisible, or gray if I use
a gray background.
I am using it in XL2003 to put 2 Option buttons in.
Thanks,
Tonso
You'll have to use VBA to make the groupbox invisible.
activesheet.groupboxes.visible = false
will work for a small (whatever that means) number of groupboxes.
But if you have lots, you can use:
dim GBX as groupbox
for each GBX in activesheet.groupboxes
gbx.visible = false
next gbx
On 01/09/2012 08:26, Tonso wrote:
> Can I change the color of the Group Box o...