|
Me.Name results in "Invalid procedure call or argument"
I am debugging an Access application written by someone else. In
Access 2003 it behaves OK, but the client needs to upgrade to Access
2007 for various reasons. When the app is run in Access 2007 I get a
few niggles that I have been working through, but this one has really
got me stumped....
A subform of a subform (I'll call it subform2) will not display any
records. On further investigati...
|
6 |
12/17/2008 9:57:01 PM |
|
|
Can't send email with attachment from Access 2003
When I try to send an email with the results of a query as an attachment in
Access 2003 I get the following message: Micorsoft Office Access can't send
this e-mail message. Before attemping to send an e-mail message from
Microsoft Office Access, resolve the problem identified in the previous
message, or configure your computer to send and receive e-mail messages.
There was no previous me...
|
4 |
12/17/2008 9:36:25 PM |
|
|
saving items from disk to my PC
Hi can anyone help me. I have a number of CVs saved in word format saved to
dick when I try and open them they are blank. I know they are there because
they have opened before but now they have diserpeared again....
|
2 |
12/17/2008 9:11:22 PM |
|
|
How to prevent multiple fields section in a from
Hi All,
I have a from in data sheet view, I don't want the user to select more than
one field in a record i.e., at a time only one field should be in selection.
So I wanted to avoid user user in selection for more than one field at a time
using shift+arrow keys or with cursor on column header or with cursor on
record selector to select more than one record, etc.,
If inselection/infoc...
|
7 |
12/17/2008 9:07:20 PM |
|
|
validation rule
Hi
I would like to place a validation rule on a form and can not figure out the
code.
What I want to do is:
If Me.wait8-9 >14 then
Me.hour8-9 must be >0
Thanks in advance for any help with this
Chuck
...
|
3 |
12/17/2008 8:55:02 PM |
|
|
INFO
--
Per Guardare i miei centri comerciali,clicca i link.
www.nikol.gigacenter.it
https://www.clubshop.com/cgi-bin/ppreport.cgi?a=CT4458870...
|
1 |
12/17/2008 8:07:43 PM |
|
|
Ranking in Query
I need to rank customers by TotalAll. There are ten customers, I need to put
1, 2, 3, 4, 5...10 in a column.
SELECT [IP-TopTenRanking1].CustNo, [IP-TopTenRanking1].TotalAll
FROM [IP-TopTenRanking1]
GROUP BY [IP-TopTenRanking1].CustNo, [IP-TopTenRanking1].TotalAll;
Thanks in advance...
|
4 |
12/17/2008 8:03:13 PM |
|
|
How to display a list box with select items in edit mode
Hi All,
Here is my requirement,
I've a bound form to edit existed records from a table whiich contains free
text boxes and some list boxes (multi selection). During opening a form I'm
assigning list box items through query which reads from master table. Once
the list is populated I should highlight list boxes with existed data for the
same field from recored source i.e., A,B,C,D,E,F ...
|
2 |
12/17/2008 7:57:01 PM |
|
|
DCount returning Zero
Can anybody advise as to why the DCount is returning Zero for this query?
SELECT DatePart("yyyy",[xDateIssuedtoSC]) AS ayear,
DatePart("ww",[xDateIssuedtoSC]) AS amonth,
Sum(DCount("[x]","x_tbl_dates",DatePart('ww',[xDateIssuedToSC])="amonth")) AS
RunTot, DatePart('ww',[xDateIssuedToSC]) AS Expr1
FROM x_tbl_dates
GROUP BY DatePart("yyyy",[xDateIssuedtoSC]),
DatePart("ww",[xDateIssuedt...
|
2 |
12/17/2008 7:55:24 PM |
|
|
hi
This is a multi-part message in MIME format.
------=_NextPart_000_002C_01C9607C.06997020
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_002D_01C9607C.06999730"
------=_NextPart_001_002D_01C9607C.06999730
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
hi emily=20
it is emily an sophia xx
byebye x
oh an this email ...
|
1 |
12/17/2008 7:16:55 PM |
|
|
Edit record in subform
I am pretty new to Access and can't figure this out.
I have a form and a sub form based on the same table. The form and sub form
are linked by a field called Country. The form and sub form are behaving
like I want them to with one exception. When an entry pops up on the subform
I want the user to be able to click on a link and go to the record in the
subform. How do I do this?
Th...
|
1 |
12/17/2008 7:05:03 PM |
|
|
Require fields
I have two fields one call exit date and the other one exit reason. If a date
is enter in the exit date field i want the exit reason to be a require field.
How can i do that...
|
8 |
12/17/2008 6:29:36 PM |
|
|
How to display contineous form as datasheet view
Hi All,
This is one of the response from my previous post on couple of days back,
which is a form will have table as data source and it shouldn't allow user to
select multiple cells. Form will be in 'Data sheet view'
The designed form will be used as subform, so if user selects single cell
followed by clicking a button which will copy the selected cell data into
equvalent field in an...
|
2 |
12/17/2008 6:18:36 PM |
|
|
ABsolute Refereneces
Is it possible to globally update absolute references for an entire
workshett? I have formulas that are linked to other worksheets. For
example. Each month I prepare a summary of investments. They are linked to
another worksheet so when I need to update the worksheet for the next month,
the link needs to change to the next cell down. Is there a way to do this
without manually updati...
|
2 |
12/17/2008 6:09:32 PM |
|
|
Slow saving queries
I have an access database that uses a large linked SQLServer table. If I run
a query and then make a change and save it, it takes a very long time to
save the query, about the same amount of time that it takes to run the
query. Is access automatically running the query when I save it? Is there a
way to stop this or speed up the save?
...
|
1 |
12/17/2008 6:01:02 PM |
|
|
Filename goes missing from titlebar
When I open my Access 2007 database, the name appears in the title bar. After
I've been working with it for awhile (I have to databases open) the filename
disappears. This is a bit of a nuiscance. Is there anyway to make it
reappear? Is there anything in the menus that will reveal the name of the
current database?...
|
1 |
12/17/2008 5:14:01 PM |
|
|
Make User See Only Certain Form
Is there a way to set up an Access application so that the user will only see
a certain form? What I want is to separate the main form that will be used
from all other objects - I want to ensure no one mucks around with the
tables, queries, etc.
I think what I am asking in some way touches upon security. But I vaguely
recall reading once that Access allows for "splitting" objects acr...
|
4 |
12/17/2008 4:53:01 PM |
|
|
HELP...!
Hi all,
Firstly, thanks for all of your help thus far.
I have having major major problems with a couple of issues. I have a table
set up, I think correctly, which records the common details (such as contact
details) of our adult users of our community centre (Adult Users Table). I
then have a table which records the extra information we need for adults who
have children i the nur...
|
5 |
12/17/2008 4:50:02 PM |
|
|
demande de canditature
bonjour madame
Je m'appelle Sangba Bintou Danielle, je suis née le 29 juillet 1988 et j'ai
20 ans.
je suis étudiante/salarié, précisément en BTS Négociation Relation Client en
alternance.
j'ai une rémunération de 700e par mois, des aides aux logement d'un montant
de 263e (APL) ensuite je dispose deux garants qui sont mon patron: Mr
Souhouré et mon parrain Mr Imma.
je vis en ce moment...
|
1 |
12/17/2008 4:20:57 PM |
|
|
SubReport: Determining Size?
I posted this a few days ago under "Report: Varying Control Positions
Depending On SubReport's Size? " but I'm not getting any nibbles and
am getting desperate. Figuring that maybe it never made it out of
GoogleGroups, I'm posting it again.
Got a report with a subreport.
Subreport has .CanGrow=Yes and .CanShrink=Yes.
In Detail_Format, I'm trying to use .Line to draw an enclosing
rec...
|
4 |
12/17/2008 4:04:39 PM |
|
|
opening up outlook from a form
I am currently setting up a database and have a query on it. So far I've
done my tables and relationships and have created forms. I want the form to
be user friendly so when anyone needs to add information to it then it can be
done simply. This particular form includes contact information of
businesses. There are fields for an e-mail address and web address which I
have made hyperlin...
|
1 |
12/17/2008 3:49:10 PM |
|
|
yuki_under_earth_th@hotmail.com
/cgibin/star?108&login=23n4j3&pass=(jonatan)=Manera. de hackear
hotmai/login&access19%80s10eBrd/user&javascript=active&get=(thu.joni.moreno@hotmail.com)&login=javascript/cgi/bin%0a/
...
|
1 |
12/17/2008 3:45:09 PM |
|
|
If Statement and macro
Hi, does anyone know if it is possible to put a ctrl function into an if
statement so that if the statemnt is true the ctrl function will run a macro,
and if not true, it does nothing?
--
Lolli...
|
5 |
12/17/2008 3:21:18 PM |
|
|
Top Number Of Rows
I am having some problems with one of my databases on the Web and am
wondering if perhaps the number of rows may be causing that problem.
The main table contains about 90,000 rows, and I am wondering if this
fact might be causing a problem. Can Access handle tables of this
size without any difficulties, or should I look to remove as many rows
as possible?
Thanks -
george...
|
7 |
12/17/2008 3:15:31 PM |
|
|
Read only front end
I am just needing some ideas and directions. We currently have a db that is
split front end and back end for our users in the office. We are going in a
new direction and I am just wanting to pick the brain of the "guru's". What I
am looking into, is we have 4 inspectors who recently have new laptops to
take in the field. What the request from them is they want to look up
applicants licen...
|
1 |
12/17/2008 3:04:04 PM |