Hyperlink to specific Form in MSAccess
I can create a link very easily to open an Access database, but can i refer
to a specific form in that database instead of the default 'switchboard' ?
Proficient in VBA.
... anyone ?
widemonk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2040
View this thread: http://www.excelforum.com/showthread.php?threadid=48343
Maybe someone in the Access newsgroups could help more.
> I can create a link very easily to open an Access database, ...Hyperlinks in Custom Forms
We have a need for distributing excel spreadsheets and
large documents to our outside people who dialup to get
I created a custom form with a hyperlink to an EXE file
that will install the document into a specific folder.
The problem is that this works sometimes, but most of the
time it tries to open the link in IE (then I get the
unable to open the page error). I want the form to
automatically download (or just give me option to
download) the file when the link is clicked.
I thought it might be encoded in the link somewhere as a
switch or something... ANY help or sugge...Custom Outlook Form
I am currently working on creating a custom outlook task form and have
the following questions:
1. When I assign the task to someone, it sends information from
hidden pages within the email. Is there a way to remove or customize
the message that accompanies the task request?
2. Within the actual form itself, when a user hits enter, it sends
them to the next field. Is there a way to preven this from
3. I read online that you could use variables and populate portions
of the form with those variables. In my case, I wanted to take the
data entered by the user within a proj...Populating Excel from CSV
I need to know how to populate an Excel template with data from a
external CSV file. Let's say I have this nice pretty colourful templat
that is far more pleasing to the eye than the usual chunk of importe
CSV data, what are some methods to populate it with data from a CS
Any ideas or suggestions or redirections would be much appreciated.
Thanks in advance :
AJMorgan591's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2777
View this thread: http://www.ex...Double Click record in cont. form and delete the record
I am trying to double click the TransID on continuous form and delete that
Can someone help me with the code?
Do you not have enough room to put a delete button on the line in your
continuous form? I would strongly suggest you create a visible Delete Button
on the TransID line because that is the window standard. Double clicking on
something to delete it is NOT a window starndard. If I double clicked on
something, I would expect to "Open" the TransID detail. I would never ever
guess that double clicking it would delete it.
Now having stated the...Exporting from Access Form to Excel
Does anyone have any ideas to get information that is
entered on a Access 2000 form exported to Excel? When data
is entered on my form sheet, it goes into a query. I would
like it to go right to an Excel file.
Any answer or any help would be appreciated.
...Exchange 2003 Standard edition mobile SMS (text messaging)
My mobile phone accepts SMS (text messaging). Is there any way that I make
exchange to notify every time that I receive a message or I even can create
an email that will send a direct message to my mobile.
I understand that I can activate the mobile feature of exchange but it will
require the internet to be active on my mobile costing me more money.
We have Exchange 2003 Standard edition
SMS was used by Exchange ActiveSync to initiate ActiveSync in Exchange
Server 2003 before SP2.
The actual delivery of mail would still require a data connection on your
mobile device - t...Sequence Not populated for the MO Numbers during Data Collection
When data collection is done for the MO Numbers by using the Data Collection
Window under Manufaturing, the Sequnce look up does not show the whole list,
it only shows NOTES, for the user to select and enter the necessary data. why
does this happen in the case of some MO Numbers and in the others it shows
all the sequnces as NOTES,MAKE READY, PRESS RUN, WASH UP, MAINTENANCE,
REPAIRS, REWIND/INSPECTION, etc. Any information would be much appreciated
It should show all of the router steps. Are some of your steps possibly
marked to backflush labor? These steps would not...how do i bring a visual basic form to the spread sheet?
I have created a form using teh developer tab in excel in vb. The problem
is anytime I want to access the form i need to go to the developer tab, click
on vb and run it frorm there. What I would like to do is to bring the form to
the spreadsheet so that I can run it directly from there. or better yet, be
able to run the form independently of the spreadhseet. is that a possibility?
Thanks a lot for your help,
add a button to the spreadsheet and attach the code
UserForm1.show 'or whatever the form name is
You will not be able to run the form independant of ...how do populate empty cells with the contents of populated cells .
I have this worksheet problem. The work sheet is thousands of rows long. One
of my columns has cells not populated. I would like to get any empty cell in
this column to populate itself with the contents of the next populated cell
Kind of a "find and replace" action where by an empty cell says to it
self;"I'm going fill myself in with the next thing I find below me"
I would greatly appreciate if someone can relate how to do this.
Select the column, use Edit | Go To... Special , Blanks, OK. Then type an
equal sign, press the down arrow...Autoplay for Pictures Not Populated
I inserted my XD card in to my card reader today and the autoplay pop up
window asking what I wanted Windows to do was blank. For Video, Music and
Mixed content the options are there but not for Pictures - it is just blank.
I have tried running autofix.exe but this has not fixed it. Any ideas? Is
this a Microsoft problem or has something else caused this? It worked fine
until today. Thanks.
> I inserted my XD card in to my card reader today and the autoplay
> pop up window asking what I wanted Windows to do was blank. For
> Video, Music and Mi...Customizing forms 07-02-04
OK - newbie question here. We've modified a couple of
forms, and the changes show up fine when we are in the
customization screens, but they never show up when the
users are doing data entry. What are we missing?
Did you do Deployment Manager | All Tasks | Publish
Customization ... ?
>OK - newbie question here. We've modified a couple of
>forms, and the changes show up fine when we are in the
>customization screens, but they never show up when the
>users are doing data entry. What are we missing?
Yep - I...Convert a form to a split form?
After creating a subform in single form view, I realized the users would
sometimes like to see all of the records at once, though the single form
allows much better visiblity to the data. Is there a simple way to convert
it to a Split Form, or will I have to create a new split form and move all
of the custom designed UI to the new form?
I tried changing the Default View on my original form to Split Form, but
this did not bring up the datasheet view - is there another setting I need
...Customising forms does not work
I can customise the form, I see the changes even when
going to the customisation later. In the actual working
env. I do not see the changes, I have tried everything,
save, create form etc. but nothing works.
Publish the form from deployment manager and issue an IISRESET.
On Wed, 7 Apr 2004 00:53:08 -0700, "Vignir"
I can customise the form, I see the changes even when
going to the customisation later. In the actual w...Populating a field
I want to populate a description field based on a par number that is entered
in the field before it. In other owrds, you enter a part number and presto,
in the next field, the description is entered for you.
Can you help??
On Thu, 6 Dec 2007 08:48:01 -0800, Tom <Tom@discussions.microsoft.com> wrote:
>I want to populate a description field based on a par number that is entered
>in the field before it. In other owrds, you enter a part number and presto,
>in the next field, the description is entered for you.
>Can you help??
If yo...printing forms
Hi, i have this table in one sheet
Name Surname Adress Tel.No. E-mail Gender
Paul Gaultier Baker st 9995 firstname.lastname@example.org M
John Smith Rose st. 5556 email@example.com F
And in another sheet I have couple of forms (application forms,
Applc. form. No.1
My wish is, to have buttons (or functions) next to each name, that will
print each form with data of this person put in right boxes of the forms.
Name Surname Adress Tel.No. E-mail Gender Print Form
Paul Gaultier ...2007
A client installed Access 2007 yesterday and now her form command buttons are
not working. We have run a compile on the application code, with no errors.
Checked the referenced libraries, nothing missing. She mentioned the form
has a Filter OnLoad property that is not on my 2003 form properties. One
command button no longer working builds a simple form filter string as
me.filter = filterstring
There are other command buttons on the form that run very simple code such as
Docmd.OpenForm - nothing is working. I've reviewed the "Whats new in Access
2007&quo...Blank field in form
I have a query that gets some criteria (City and State) from a form.
I have the State field set up as a ComboBox connected to a local
I created. If a user was to type in a City (i.e. "Springfield") and
then leave the State field empty, then the query would have no
How do I make the query so that if one of the fields on the form is
left empty it will run for all possibilities (i.e. look for all
Springfields in any state)?
It would help tremendously if you had provided the SQL view of your query.
Without that I can suggest you might use a where clause like...City and State Populated by Zip Code
Does anyone know of a way to load a program that when you type in the
Zip Code the City and State are automatically populated?
I have seen a MSCRM add-in from a company called QAS (http://www.qas.com/).
This is more than just Zip Code/City&State. It's a full address validator along
with streamlined data entry. They have integrated with CRM via an ISV pop-up
and it seems to work fairly smoothly.
MVP - Microsoft CRM
On 15 Apr 2005 11:13:56 -0700, "Morgan" <firstname.lastname@example.org> wr...Calculate Running Sum on Datasheet Veiw Form
I have a Datasheet View form with the following fields:
The "Tax" field is a calculated field from the "Subtotal" field:
The "Linetotal" field is also a calculated field from the "Subtotal" and
"Tax" fields: =[tax]+[subtotal]
I would like to have a Running Sum of the "Linetotal" field, and have it
display in the "Grandtotal" field. What Expression would I use for a
Running Sum for the "Grandtotal" field?
I've tried =Sum([Linetotal]) ...Forms in E-mail folders
Have created a new e-mail template for a Public Folder.
When you post new mail to that folder it comes up with the
correct e-mail headers but once you go into the e-mail
again once it has been posted the email headers
You then have to revise contents to see them. Does anyone
know how to make the email headers display once it has
been posted without having to revise the contents?
Thanks to anyone that can solve this problem.
I have a table with part numbers and locations. There are multiple
locations per part number. I would like to populate a listbox with a
filtered list of the locations for the part number shown on my form. I'm not
very good at vba and have been looking all over for code, but can't find
You have multiple locations per part number. So first, let's get your form
set up correctly. When you have a one-to-many format (one salesman, many
products or one part number, many locations) you need a form and subform. The
Mainform would be for...How to get all the texts on all type controls in form?
I want to make the multi-languages program, want to get all texts of each
control item in a form, then read the XML file (Control Name and Text) to
write to the text of control, and have wrote some codes, but seem that it's
complicated. Can anyone tell easy method or sample? thank you.
Public Shared Sub AllControlOnForm(ByVal FormName As Form, ByVal xPath As
String, Optional ByVal ToolTipName As ToolTip = Nothing)
Dim ReturnValue As String = GetXMLText(xPat...Help Please: Retrieving the first populated cell value from a specific excel spreadsheet column
I need help with retrieving the first populated cell value from a specific
excel spreadsheet column. This value will then be used for later parts in
an broader script to mark the entry as used.
The 3rd worksheet contains 3 columns. I need this code to go through all
the cells in the 2nd column, in order from top to bottom, and have it return
the first value found. In this example, it should return 55553.
Phone Free Used
...........Inventory Item List Not Populating, Generating SQL Errors
When any user tries to view the Items list under the Inventory category in
the sidebar, the following warning appears:
[Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into
column 'ATYALLOC', table 'tempdb.dbo.##2411735'; column does not allow nulls.
After clicking ok, the list never populates. All of our other lists are
working correctly, except for this one. What can be done to enable this
What version of GP? What Service Pack or build number? Did this feature ever
worked before? Did you just noticed thi...