Thanks in advance.
I'm using 2003, I've set up security, I want to prevent a specific user from
being able to modify specific fields in a form that opens up in datasheet
view. I've attempted the following behind the form & it's not working:
Private Sub Form_Load()
If CurrentUser() = "blackman" Then
Me.ID = vbReadOnly
Me.GageNo = vbReadOnly
Me.EmpNo = vbReadOnly
Me.GageOwner = vbReadOnly
Me.QA = vbReadOnly
Me.QARecDate = vbReadOnly
Me.QARetDate = vbReadOnly
Me.EmpNoRecd = vbReadOnly
Me.CalCategory = vbReadO...ANN: DBForms from MS Access to ASP.NET + MS SQL v 1.0 released.
We are glad to announce the releases of our new product DBForms from
MS Access to ASP.NET+MS SQL v.1.0.0.
This tool allows you to convert mdb (Microsoft Access forms) to .aspx
web pages + MS SQL back-end with AJAX support. Convert forms and their
elements (Label, Image, OptionGroup, TextBox, ListBox, ComboBox,
CommandBox and others) to Web page including element position, color
pallet and fields type.
Advanced customization options:
- Rename caption forms
- partial selection for database objects that will be converted.
- detection of possible conversion errors at customization stage.
Session...blinking form afterupdate
When i use this command:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
The form blinks with every update. Is there a way to prevent the form from
I hope to hear from you !
Best regards and thanks in advance,
This code requeries the form and displays any changes to the data.
Where are you using that code - is it on a button or some other event?
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"Pierkes" <email@example.com> wrote in message
> Hi...Back Order Qty Print on Picking Ticket form
I have 2 itmes on Invoice, One of the item is full filled partially and
other are Back order while 2nd item has 2 qty and all of them are Back order.
I would like to print the back order qty of 2 items on picking ticket forms.
When I print the picking ticked it doesn't print the 2nd item as second item
qty invoice and fulfill is zero.
How do i print the second item on picking ticket when all the qty is back
order and nothing has to invoice.
I don't think you can. You can 'override the shortage' on the order and then
it will ...Multiple Instances of Access.. is it safe?
Hello and thanks for any insight...
I've always tried to avoid doing this, but increasingly, between my
management software (access), my development application (access) and various
other tools (access) that are in seperate dbs, I'm finding myself doing a lot
of closing this app before opening that app, running a quick utility, then
closing and switching back to the main app. And this is if I'm not working
on development at the office.
I'm not sure what actually goes on when you have two instances of access
open. I *think* that these are the DBEngine(0).(0) ...displaying a chart in a form
How do I display an excel chart in a form?
Add an image control to the form.
Copy the chart.
Paste directly (Ctrl + V) into the "Picture" property of the image in the properties window.
Adjust the "Picture Alignment", "PictureSizeMode" properties to suit.
San Francisco, USA
"cd" <firstname.lastname@example.org> wrote in message
How do I display an excel chart in a form?
I should have said I need the chart to refresh when the data ref...Form
An former employee password protect an Outlook 2000 form. We don't know the
password. What can an Administrator do to unlock the password.
See http://www.outlookcode.com/d/code/getformpassword.htm for sample code.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Kristina" <Kristina@discussions.microsoft.com> wrote in message
> An former employee password protect an Outl...email report or form
Is there a way to email a form or just the corresponding page of the report
rather then the entire report?
Ruth <Ruth@discussions.microsoft.com> wrote:
>Is there a way to email a form or just the corresponding page of the report
>rather then the entire report?
Form, I have no idea as I have never printed from a form.
Page or selected records? For a page on how to print a report for a
single record and how to generate reports to attach to emails see the
Emailing reports as attachments from Microsoft Access page at
http://www.granite.ab.ca/access...Changing Form background color conditional format
I am trying to fingue out how to get the conditional format for a Form. There
is a field called [Reason For Test] and I am trying to write the code so that
when someone chooses "Applicant" the form page (not continuous) background
color is Green, and when they choose "Allied Agency" the form page background
color is blue.
I would really appreciate help with this.
Forms, to my knowledge, don't have a conditional format property.
You'll need to add a small bit of code to the After_Update event of this
control ([Reason For Test]) to change the backgro...Modify Form
I want to add some textfield to the wndor maintainance window..
Well i select the field to the list of field....
i saved the change, but i used the form i want to saved in that field..
the information that i writed was not saved...
It's not saved, because you have not told it to save it. Adding a field with
Modifier to a window by itself will do absolutely nothing to save the data.
Take a look at the material and sample code we (David Musgrave and I)
presented at the Microsoft Dynamics GP Technical Conference 2009 which
explains in detail various techniques to ...update form after adding to combo box
I'm trying to figure out what's missing from my code. After adding a record,
if its not already in the combo box, I need to update my form and subform to
show the new record and related records (in the subform). The form is
programmed to automatically add a client if the name is not already in the
combo box. When the new record is created, I need my form and subform to
show the new record, but it is showing information for a different record.
The master and Child relationships are set on the forms, but I need some kind
of code to make the connection between the new client that ...Upgrade GP8 to 9 and multicurrency access
After upgrade databases, some users reporting about troubles.
I check this and found error message while accessing to "Transaction ->
Sales -> Sales transaction entry" menu item. Error message displayed "Your
multicurrency registration status has changed. Please check links on the
Mutlicurrency Setup table".
For another databases error message different: "A functional currency does
not exists for this company. Transaction cannot be entered."
What I can do for error correcting?
PS Sorry for may be simple questions, but I only DBA and not very ...Populate a footer on a protected form with text from mixture of text form fields & drop down form filed
I have a form which generates the filename from various drop down fields/ text fields(for extraction of text in one field, the text is split, only using PART of the entry)
I would like to populate the footer with the generated filename BEFORE the file is saved with this auto generated name.
The code I am using to create the fileneame & save with this name is (section after "Call RunSpellCheck":
Private Sub CommandButton1_Click()
If ActiveDocument.FormFields("classificationDD").Result = "ENTER REPORT CLASSIFICATION" Then
MsgBox "You forgot to fill in th...Add description for a text box in Access forms
I have a text box where the user is expected to enter dates.But i want to
display a message < dd-mm-yyyy> highlighted with a blue blackground to give a
visual clue that only such a date format will be accepted.
You can use the ToolTip for this function but you do not have control over
the colors. Stephan Lebans has a ToolTip where you do have control over these
>I have a text box where the user is expected to enter dates.But i want to
>display a message < dd-mm-yyyy> highlighted ...form scroll bars
We have noticed that when a form has a horizontal scroll bar and there
is more than a page full of records there is no vertical scroll bar
available until the horizontal scroll bar is moved to the complete
right of the form.
Is this a known issue or does anyone know of a fix?
this is a known issue and is a pain :-)
the message is dont add too many fields to views that force users to scroll
way to the right
Microsoft CRM MVP
"nathan" <email@example.com> wrote in message
news:2d6ba84d.0504181859.39058137@posting...Help with cell referencing.
I have an Excel file which contains multiple worksheets.
Worksheet 1 has data that is imported from an external source. The data
is imported in rows. For example row 1 is the data name (header). Row 2
is data set 1, row 3 is data set 2, row 4 is data set 3......etc. etc.
Worksheet 2 just has the data transposed into columns. So the header is
column A, column B is data set 1, colum C, is data set 3......etc. etc.
Worksheets 3, 4 ,5....and so on are the presentation sheets (printed
reports will be generated from these sheets.
Worksheet 3 only requires data from column B of Worksheet 2. ...Org. Forms.
I have published several forms into the Organizational Forms Library on my
Exchange Server 2003 and need to delete or overwrite them. The program I
used to publish the problem forms generates a 'you don't have permission'
type error when I try to run it to publish the corrected forms. I find that
if I look at them in Outlook 2003 the delete key is grayed out in the
'Choose Form' box (from which I assume I would delete it). This occurs
whether I'm in as myself (and I've granted my account every permission I
can) or as the administrator account.
Ayy Ideas?...Printing Options for a report on Access 2000
My question is:
When printing a report on Access 2000, How can I make the Printing Options
appear so I can select the amount of copies for that particular report. As
of right now when you select to print it will print the report without
selecting the printer or the amount of copies you will like to print.
Thanks in advance.
Change the print option to acViewPreview rather than acViewNormal
...Change Form Field Font
MS Word 2003.
I have quite a few Form Fields on my document. I would like to change
the font on ALL of them.
Is there an easy way to accomplish this?
1. Unprotect the form.
2. Display field codes (Al+F9).
3. In the Replace dialog, in the "Find what" box, type
4. Click More to expand the dialog.
5. With the insertion point in the "Replace with" box, click Format | Font
and select the desired font.
7. Replace All.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.or...Saving form on changes
I don't know how but somehow I must have disabled asking if I wanted to save
my form changes when closing a form. It has been ok up till now but today I
made a ton of changes (that I did NOT) want to save and there was no way of
not saving because when I closed it automiatically saves without asking. I am
Message posted via AccessMonster.com
You, quite possibly, turned off warnings. You should be able to turn them
back on in Options (In the Office button). If you used code to turn them
off, ...Converting Access 1.x database to Access 2000
My Dad has a couple of Access 1.x databases that he wants
to convert to Access 2000 (or Excel format). I tried to
open them with my version of Access 2000 and when trying
to convert database got the following message:
This operation is not supported for Microsoft Access 1.x
Any suggestions? I tried looking for a converter
unsuccessfully on the web.
Thank you in advance.
I was able to open 1.x Access tables in Excel as an
external database query. Go Data, Import External Data,
New Database Query. Select MS Access database, find the
mdb file, then you...Attaching excel adress list to custom form
I wondered if this is possible what I want.
FWIW : I'm working in a WinXP environment using Outlook 2000.
What I want is to create a custom form as a custom reply to certain
I want to attach an xls-file to the to button. I want the names that
are in this xls-sheet to appear in the To-box. I want to be able to
add in CC other contacts from the Outlook contacts.
Thanks in advance for your quick replies.
P.s.: just tell me as well if you know it's impossible.
It's not possible to "attach an xls file to the to button" but you could
certainly wri...Function help #2
I am wanting to know how to get excel to look at a coloumn of information
and compare with another coloumn and then tell me what and where the
differences are. Let me explain what I have. I have a spreadsheet that has
two seperate "pieces" of information. Each piece has two coloumns. What I
need to do is have a function that will look at coloumn a and then compare
it with coloumn b. The twist in this is that the information does not line
up as far as the rows go. I am running Excel 2000 on an XP box. Any help
is great. thanks!!!!
Try using conditi...Tabebed Forms in Access!!!HELP!
I am trying to design a tabbed form in Access 2007. I have my five tabs
named etc....I have inserted fields onto the first tab and for the life of
me cannot figure out have to get the fields from the first tabs to not show
up on the other tabs!!!!!
I want each tab to contain its own fields. How do I do this???? PLEASE HELP
Try cutting the controls, and pasting them back on the the correct page.
Make sure that the page itself is selected before pasting the control.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Heather Elbert&qu...New to User Forms
When I first found this site I was a crazy woman and just about read
everthing. Thanks to all you folks who take the time to answer our
The one thing I cannot get to is a video/tutoraial on forms, the link was
provided by somebody as an assist to another question. I loved the videos
but was unable to complete the 3 or 4 part series and forgot to make it a
favorite. Can anybody point me in the right direction or provide links to
other training for starting forms?
Might have been Debra Dalgleish's site.