|
Expression Builder to build code.
I use to be able to build code using an Expression builder and have recently
istalled Access2003.
How do I access it?
Thank You
...
|
3 |
18.04.2006 21:53:43 |
|
|
Advice/Guidance for Table Code Issue
Hello All,
4 tables involved (maybe more, if you say so)
1- Employee
2- EmployeeHomeAddress
3- EmployeeWorkAddress1
4- Employee WorkAddress2
Employee Table contains no address/Phone info/fax email info
All other tables contain Address/Phone/Fax Email info, linked by EmployeeID.
Monthly Report (very important)
A roster Containing all employees and contact info.
**Can only Co...
|
9 |
17.04.2006 23:07:11 |
|
|
JPG wont display on Bound OLE Object Control
Hello,
I have a bound picture frame on a form. Source Data is a .jpg image.
The soure data table field reads "Package".
The image wont display. It only displays the name of the File (when double
clicked the image opens in another window just fine).
It seems to work fine when the picture is a .bmp.
Am i doing soemthing wrong, or failing to do something that is needed ?
Thanks \
VL
...
|
4 |
17.04.2006 14:38:58 |
|
|
for sale: internetDotComs.com
domain for sale: internetdotcoms.com
http://www.afternic.com/name.php?id=11866440
...
|
1 |
16.04.2006 13:28:34 |
|
|
Image on Form based on Field Criteria
Hello,
I would like to display an image on a form based on crieria.
i.e. :
If [Rank] = "VADM" then Display 3Star.jpg
If [Rank]= "ADM" then Display 4Star.jpg
Anyone know how to do this (well, thats a stupid question, Ill rephrase).
Would anyone care to show me how to do this?
As usual, thanks for all your help,
VL
...
|
7 |
16.04.2006 01:01:34 |
|
|
HyperLink Image on Form
Hello, I posted this on the public.access group, I dont think it was the
appropiate place.
I would like to be able to Display a hyperlinked Picture within a form.
To give the same appearance as it would have if it were an ole object.
**The image is an employee picture. Almost identical to the North Wind
Sample database employee form. With the exception that the image is a
hyperlinked fi...
|
3 |
15.04.2006 16:09:51 |
|
|
Outlook Automation
Hello..
I would like to find some sample coding that allows me from withing Access
to send an email that allows the person recieving the email to answer a
questions with yes or no and then have the answer send to a specific email
address.
Thank you....
|
3 |
15.04.2006 13:57:11 |
|
|
VBA code (if needed) to provide the number of queries in a databas
Hi,
I've taken on a database which has I think around 1000 queries! in it. I
just want to confirm this. Is there a property I can refer to find this out.
Thanks
Sandra...
|
4 |
14.04.2006 22:47:07 |
|
|
replace function
in one of my users machine the response to the Replace function is:
"run time error 5: Invalid procedure call or argument"
no reference is missing
what can be wrong ?
thanks
...
|
4 |
14.04.2006 11:13:36 |
|
|
email from Access to Outlook Express
This is a multi-part message in MIME format.
------=_NextPart_000_001C_01C65C18.05F60EA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I found this code on the web. It works great. Can it do attachments? =
If so, can someone show me an example? Thanks so much!!
Option Explicit
Type MAPIRecip
Reserved As Long
RecipClass As ...
|
4 |
13.04.2006 03:59:56 |
|
|
Mail Merge Word - worddoc.MailMerge.OpenDataSource
I am using the following to mail merge a word document:
worddoc.MailMerge.OpenDataSource _
Name:="C:\Documents and Settings\Craig\My Documents\About Data\Work
in Progress\Community Health Charities\Letters2\Text.xls", _
ConfirmConversions:=False, _
ReadOnly:=False, LinkToSource:=True, AddToRecentFiles:=False, _
PasswordDocument:="", PasswordTemplate:="",
...
|
3 |
12.04.2006 14:58:24 |
|
|
Export Code
I am using code like the following to export data to text files:
appAccess.DoCmd.TransferText acExportDelim, "Update-B_AFFIL", _
"B_AFFILIATION", T_BAffil, True
My question is with the last parameter that is supposed to output the field
names as the first row. It appears that, even though this parameter is set
to True, the exported text file will only have the field names...
|
4 |
11.04.2006 21:14:19 |
|
|
Need to update a description field based on check boxes
I have a form with 16 check boxes. Each one represents 1/16th of a square
mile. They are called quater quaters. for example number 1 is NE 1/4 - NE
1/4 and number 2 NW 1/4 - NE 1/4. I want to update a text field called [Land
Description] based on which of the 16 boxes are checked. I need to put a code
module in the click event of a button called "Update Description"
I know this is VBA...
|
14 |
11.04.2006 05:50:36 |
|
|
Check for Open File
With Access, is there a way to check if a Word document is open and if so
close it?
Thanks
Craig
...
|
2 |
10.04.2006 20:55:01 |
|
|
Start Earning Money 15 Minutes From Now
Did you know?
$29 can make you $1,000?
And
$1,000 can return you $3,081,484 in 3 years?
(without you lifting a finger)
Yes, we will show you how AND give you the method
Yes, InvestPlace uses extremely powerful tools
InvestPlace contains a powerful combination of two match winners...
This is some valuable information. I'm using it and watching my money grow everyday.
...
|
1 |
09.04.2006 14:21:32 |
|
|
Number of Days in a Month
Given a month/year is there a command that shows the number of days in that
month please?
...
|
3 |
06.04.2006 15:40:25 |
|
|
Day Function
Hello All,
This is driving me nuts.
I need to pull out the day of the month from a date, but I keep getting a
"Type Mismatch" error.
My code is:
Dim SDay as variant
SDay=Day(me.dateholder)
The me.dateholder control is a text box with a date stored in it (in date
format)
What am I missing???
Bemused and amused Brian....
|
8 |
04.04.2006 22:56:10 |
|
|
SendObject Coding and 0x3 Memory Read Error
I am trying to send a report to an email address in access 97 using initially
a VBA function as outlined below:
Code:
--------------------------------------------------------------------------------
Private Sub cmdEmailAllWhitehall_Click()
On Error GoTo Err_cmdMailAllWhitehall_Click
Dim stWhiteHallEmail As String
Dim stDocName As String
stWhiteHallEmail = "example@example....
|
4 |
04.04.2006 15:46:48 |
|
|
#deleted
what can be the reason for having #Deleted sign on all rows in a form
some seconds after it was opened while recordsource is not corrupteed?
thanks
...
|
4 |
04.04.2006 11:15:38 |
|
|
Printing reports
Hi,
Using MS Access 2003 on Windows XP
Opening report with DoCmd.OpenReport syntax
This always prints to my default printer (as set in Windows). How do I open
the printer dialog to allow the user to print to a specified printer?
Thanks,
Robert
...
|
3 |
03.04.2006 21:11:01 |
|
|
HTTP link in Excel
Hi
I have created an extra item in a drop down menu in the Excel menu toolbar,
and have attached an onclick event on it which when clicked should go to a
website.
However eventhough the url loads it becomes distorted, boxes, texts are not
in line etc.
What do I have to do so the Web page displays as it is meant too.
Thanks for any help on this.
Regards
Subs
...
|
2 |
02.04.2006 16:03:15 |
|
|
Opening Excel in Access
First I open Excel;
Set objExcel = GetObject("", "excel.application")
Set objWorkbook = objExcel.Workbooks.Add
objWorkbook.Worksheets.Add
Before:=objWorkbook.Worksheets(objWorkbook.Worksheets.Count)
objWorkbook.ActiveSheet.Name = "SheetName"
Set objWorksheet = objWorkbook.Worksheets("SheetName")
objWorksheet.Select
Then I'm able to insert all my data and format my cell...
|
7 |
01.04.2006 05:46:55 |
|
|
Linking tables
Hi,
I have a Front-End DB which must be coupled by means of VBA to a Back-End
DB and possibly other BE-archive DB's. This succeeds, however, I want
directly
testing if the user has selected the correct DB that corresponds to
the button.
The problem is when I read a table , immediately after the relink, he takes
the old table (BE before relink).
What do I wrong here?
tx
Michel
...
|
5 |
30.03.2006 06:22:01 |
|
|
opening a word document from accsess is very slow
opening a word document from accsess is very slow
what can be done to speed it ?
thanks
...
|
4 |
29.03.2006 07:23:39 |
|
|
Code doesn't work or do anything unless I step through it with breakpoint
I have some code that shows or hides columns on a subform depending on which
item in a combo box is selected. The code works fine if you step through it
(by using a break point and hitting F8 line by line). Nothing works or
happens if I don't have a break point set as if the code doesn't even run.
Access 2000 with Sp3.
Has anyone ran into this and what could be the problem and soluti...
|
16 |
29.03.2006 07:20:48 |