473,695 Members | 2,048 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Problem turning off action messages in runtime - append query not working

Lee
Hello All,

First of all I would like to say thank you for all of the help I have
received here. I have been teaching myself Access for about 4 years
now and I've always been able to find a solution here - until now.
This one is driving me crazy.

I am making my first attempt at creating a runtime application. I am
using Access 2003 Developer Extensions. Initially I developed the
database without planning on creating a runtime app but things have
progressed and I wanted to distribute it to those who don't have MS
Access.

My problem is trying to run an append query without getting the confirm
messages.

I have a main form with a subform. On the subform is a button that
appends records from the subform into a header and detail table (if the
record does not exist) and opens another form to display the records.
Too append the records I am using two queries. This has always worked
for me perfectly well until I tried the runtime version on a PC without
Access.

I researched and found different things to try and all of them either
do not append the records or give a parameter error.

The full code behind the button is:

Private Sub CmdOpenDetails_ Click()
On Error GoTo Err_CmdOpenDeta ils_Click

'Verify that Race Date, Race Track and Race Name are entered.

If IsNull(Me.Track ) Then
MsgBox "Please enter a track.", vbCritical, "No Track entered."
Me.Track.SetFoc us
GoTo Done
Else

If IsNull(Me.RaceD ate) Then
MsgBox "Please enter a Race Date.", vbCritical, "No Race Date
entered."
Me.RaceDate.Set Focus
GoTo Done
Else

If IsNull(Me.RaceN ame) Then
MsgBox "Please enter a Race Name.", vbCritical, "No Race Name
entered."
Me.RaceName.Set Focus
GoTo Done
End If
End If
End If
DoCmd.RunComman d acCmdSaveRecord

Dim stDocName As String
Dim stLinkCriteria As String

On Error GoTo Err_CmdOpenDeta ils_Click

DoCmd.OpenQuery ("qryappendtblr aceheader")
DoCmd.OpenQuery ("qryappendrace detail")

stDocName = "subfrmracedeta ils"

stLinkCriteria = "([TrackName]=" & "'" & Me![Track] & "') AND
([RaceName]= """ & Me![RaceName] & """) AND [RaceDate]=" & "#" &
Me![RaceDate] & "#"

DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_CmdOpenDet ails_Click:
Exit Sub

Err_CmdOpenDeta ils_Click:
MsgBox Err.Description
Resume Exit_CmdOpenDet ails_Click

Done:

End Sub

I have attempted to turn off the action confirms with:

the execute method - this caused a "need 3 parameters error"
Setoption "Confirm Action Queries", False - this goes to the next form
but without appending the records
Docmd.setwarnin gs False - same result as setoption
Application.Set Option "Confirm Action Queries", 0 on load

My latest try was creating a macro turning off the messages and then
turning them back on. That also moved to the next form but did not
append the records.

I really don't understand what I'm doing wrong and I've run out of
things to try.

I would really appreciate any help at all with this and if I haven't
provided enough information please let me know.

Thank you,

Lee

Nov 13 '05 #1
13 4223
Lee wrote:
the execute method - this caused a "need 3 parameters error"


Did you try the dbFailOnError option in the execute method?

Access.CurrentD b.Execute "QryName", dbfailonError

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #2
Lee
Thanks for the reply.

I couldn't remember so I just tried it again and I'm still getting the
error "Too few parameters. Expected 3" And that is using the full
Access program.

Thanks,

Lee
Tim Marshall wrote:
Lee wrote:
the execute method - this caused a "need 3 parameters error"


Did you try the dbFailOnError option in the execute method?

Access.CurrentD b.Execute "QryName", dbfailonError

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me


Nov 13 '05 #3
Lee wrote:
Thanks for the reply.

I couldn't remember so I just tried it again and I'm still getting the
error "Too few parameters. Expected 3" And that is using the full
Access program.


I usually construct my SQL dynamically (in VBA) rather than used stored
querydefs. I do recall there were sometimes issues using stored queries
and the execute method. Can you post the SQL of the query(ies) that's
causing this? Unless you figure out or someone comes up with a better
solution, of course. 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #4
Lee
I tried to do that when I was just working on getting the data to
update another table based on the form and subform and it was beyond
me.

The append query is built upon another query which I use to get
information from the main table (tblhorse) and the race table
(tblraces).

qryhorseandrace

SELECT tblraces.RaceID , tblhorse.Name, tblhorse.Traine r,
tblhorse.Owner, tblraces.Result , tblraces.Time, tblraces.Notes,
tblraces.Jockey , tblraces.Beyer, tblraces.Weight , tblraces.PP,
tblraces.TrackN ame, tblraces.RaceNa me, tblraces.RaceDa te,
tblraces.Distan ce, tblraces.RaceTy pe, tblraces.Surfac e
FROM tblhorse INNER JOIN tblraces ON tblhorse.ID = tblraces.HorseI D;

qryappendracehe ader

INSERT INTO tblraceheader ( TrackName, RaceName, RaceDate, Distance,
RaceType, Surface )
SELECT DISTINCT qryhorseandrace .TrackName, qryhorseandrace .RaceName,
qryhorseandrace .RaceDate, qryhorseandrace .Distance,
qryhorseandrace .RaceType, qryhorseandrace .Surface
FROM qryhorseandrace LEFT JOIN tblraceheader ON
(qryhorseandrac e.RaceDate=tblr aceheader.RaceD ate) AND
(qryhorseandrac e.RaceName=tblr aceheader.RaceN ame) AND
(qryhorseandrac e.TrackName=tbl raceheader.Trac kName)
WHERE
(((qryhorseandr ace.TrackName)= Forms!frmhorse! subfrmraces!Tra ckName) And
((qryhorseandra ce.RaceName)=Fo rms!frmhorse!su bfrmraces!RaceN ame) And
((qryhorseandra ce.RaceDate)=Fo rms!frmhorse!su bfrmraces!RaceD ate) And
((tblraceheader .TrackName) Is Null) And ((tblraceheader .RaceName) Is
Null) And ((tblraceheader .RaceDate) Is Null));

The query to append the details also is based on another query (based
on another query) to find out if the race details have already been
added.

qryfindmissingr ace

SELECT qryhorseracedet ail.RaceID, qryhorseracedet ail.Name,
qryhorseracedet ail.Trainer, qryhorseracedet ail.Owner,
qryhorseracedet ail.Result, qryhorseracedet ail.Time,
qryhorseracedet ail.Notes, qryhorseracedet ail.Jockey,
qryhorseracedet ail.Beyer, qryhorseracedet ail.Weight,
qryhorseracedet ail.PP, qryhorseracedet ail.TrackName,
qryhorseracedet ail.RaceName, qryhorseracedet ail.RaceDate,
qryhorseracedet ail.Distance, qryhorseracedet ail.RaceType
FROM qryhorseracedet ail LEFT JOIN tblracedetails ON
qryhorseracedet ail.RaceID = tblracedetails. RaceID
WHERE (((tblracedetai ls.RaceID) Is Null));

qryhorseracedet ail

SELECT tblraceheader.R aceID, qryhorseandrace .Name,
qryhorseandrace .Trainer, qryhorseandrace .Owner, qryhorseandrace .Result,
qryhorseandrace .Time, qryhorseandrace .Notes, qryhorseandrace .Jockey,
qryhorseandrace .Beyer, qryhorseandrace .Weight, qryhorseandrace .PP,
qryhorseandrace .TrackName, qryhorseandrace .RaceName,
qryhorseandrace .RaceDate, qryhorseandrace .Distance,
qryhorseandrace .RaceType
FROM tblraceheader INNER JOIN qryhorseandrace ON
(tblraceheader. RaceDate = qryhorseandrace .RaceDate) AND
(tblraceheader. RaceName = qryhorseandrace .RaceName) AND
(tblraceheader. TrackName = qryhorseandrace .TrackName);

qryappendracede tails

INSERT INTO tblraceheader ( TrackName, RaceName, RaceDate, Distance,
RaceType, Surface )
SELECT DISTINCT qryhorseandrace .TrackName, qryhorseandrace .RaceName,
qryhorseandrace .RaceDate, qryhorseandrace .Distance,
qryhorseandrace .RaceType, qryhorseandrace .Surface
FROM qryhorseandrace LEFT JOIN tblraceheader ON
(qryhorseandrac e.RaceDate=tblr aceheader.RaceD ate) AND
(qryhorseandrac e.RaceName=tblr aceheader.RaceN ame) AND
(qryhorseandrac e.TrackName=tbl raceheader.Trac kName)
WHERE
(((qryhorseandr ace.TrackName)= Forms!frmhorse! subfrmraces!Tra ckName) And
((qryhorseandra ce.RaceName)=Fo rms!frmhorse!su bfrmraces!RaceN ame) And
((qryhorseandra ce.RaceDate)=Fo rms!frmhorse!su bfrmraces!RaceD ate) And
((tblraceheader .TrackName) Is Null) And ((tblraceheader .RaceName) Is
Null) And ((tblraceheader .RaceDate) Is Null));
Wow, this looks like a convoluted mess now that I'm seeing it laid out.
It did take me a long time and several efforts to get it working at
all and it's been working great in the full Access program.

I'm tempted to just tell them hit okay at the append messages but I
know that will bother me.

Thanks for your help,

Lee
Tim Marshall wrote:
Lee wrote:
Thanks for the reply.

I couldn't remember so I just tried it again and I'm still getting the
error "Too few parameters. Expected 3" And that is using the full
Access program.


I usually construct my SQL dynamically (in VBA) rather than used stored
querydefs. I do recall there were sometimes issues using stored queries
and the execute method. Can you post the SQL of the query(ies) that's
causing this? Unless you figure out or someone comes up with a better
solution, of course. 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me


Nov 13 '05 #5
I don't know why the set warnings would fail,I would assume that:

docmd.SetWarnin gs (false)

DoCmd.OpenQuery ("qryappendtblr aceheader")
DoCmd.OpenQuery ("qryappendrace detail")

docmd.SetWarnin gs (true)

I would think the above should work.

I would actually not try and open a query to run it however (you don't need
to try and open a query to run it..).

If you use the execute method however, then you need to supply the
parameters your self, and you can't use a form expression the sql (I never
understood why people do that..as it just creates a absolute mess anyway).
And, if you queries don't have any parameters, then I not sure what the
problem is.

You can go:

Dim q As DAO.QueryDef
Set q = CurrentDb.Query Defs("query9")
q.Parameters(0) = "abc"
q.Execute

The above assumes you only have one parameter.

So, if you use the execute method for a query, then you don't have the
expression service to resolve the parameters, but you MUST supply the
parameters in code.

As mentioned, I don't know why the set warnings don't work. (however,
relying on the possibility that some form is open, or not open for the query
to run is not a reliably approach anyway, and then that sql is tied to that
form, and can't be used anywhere else - so, it is not a good programming
practice to use a form expression inside of a query anyway, and it is not
regular sql).
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #6
Lee wrote:
I tried to do that when I was just working on getting the data to
update another table based on the form and subform and it was beyond
me.

The append query is built upon another query which I use to get
information from the main table (tblhorse) and the race table
(tblraces).

qryhorseandrace

SELECT tblraces.RaceID , tblhorse.Name, tblhorse.Traine r,
tblhorse.Owner, tblraces.Result , tblraces.Time, tblraces.Notes,
tblraces.Jockey , tblraces.Beyer, tblraces.Weight , tblraces.PP,
tblraces.TrackN ame, tblraces.RaceNa me, tblraces.RaceDa te,
tblraces.Distan ce, tblraces.RaceTy pe, tblraces.Surfac e
FROM tblhorse INNER JOIN tblraces ON tblhorse.ID = tblraces.HorseI D;

qryappendracehe ader

INSERT INTO tblraceheader ( TrackName, RaceName, RaceDate, Distance,
RaceType, Surface )
SELECT DISTINCT qryhorseandrace .TrackName, qryhorseandrace .RaceName,
qryhorseandrace .RaceDate, qryhorseandrace .Distance,
qryhorseandrace .RaceType, qryhorseandrace .Surface
FROM qryhorseandrace LEFT JOIN tblraceheader ON
(qryhorseandrac e.RaceDate=tblr aceheader.RaceD ate) AND
(qryhorseandrac e.RaceName=tblr aceheader.RaceN ame) AND
(qryhorseandrac e.TrackName=tbl raceheader.Trac kName)
WHERE
(((qryhorseandr ace.TrackName)= Forms!frmhorse! subfrmraces!Tra ckName) And
((qryhorseandra ce.RaceName)=Fo rms!frmhorse!su bfrmraces!RaceN ame) And
((qryhorseandra ce.RaceDate)=Fo rms!frmhorse!su bfrmraces!RaceD ate) And
((tblraceheader .TrackName) Is Null) And ((tblraceheader .RaceName) Is
Null) And ((tblraceheader .RaceDate) Is Null));

The query to append the details also is based on another query (based
on another query) to find out if the race details have already been
added.

qryfindmissingr ace

SELECT qryhorseracedet ail.RaceID, qryhorseracedet ail.Name,
qryhorseracedet ail.Trainer, qryhorseracedet ail.Owner,
qryhorseracedet ail.Result, qryhorseracedet ail.Time,
qryhorseracedet ail.Notes, qryhorseracedet ail.Jockey,
qryhorseracedet ail.Beyer, qryhorseracedet ail.Weight,
qryhorseracedet ail.PP, qryhorseracedet ail.TrackName,
qryhorseracedet ail.RaceName, qryhorseracedet ail.RaceDate,
qryhorseracedet ail.Distance, qryhorseracedet ail.RaceType
FROM qryhorseracedet ail LEFT JOIN tblracedetails ON
qryhorseracedet ail.RaceID = tblracedetails. RaceID
WHERE (((tblracedetai ls.RaceID) Is Null));

qryhorseracedet ail

SELECT tblraceheader.R aceID, qryhorseandrace .Name,
qryhorseandrace .Trainer, qryhorseandrace .Owner, qryhorseandrace .Result,
qryhorseandrace .Time, qryhorseandrace .Notes, qryhorseandrace .Jockey,
qryhorseandrace .Beyer, qryhorseandrace .Weight, qryhorseandrace .PP,
qryhorseandrace .TrackName, qryhorseandrace .RaceName,
qryhorseandrace .RaceDate, qryhorseandrace .Distance,
qryhorseandrace .RaceType
FROM tblraceheader INNER JOIN qryhorseandrace ON
(tblraceheader. RaceDate = qryhorseandrace .RaceDate) AND
(tblraceheader. RaceName = qryhorseandrace .RaceName) AND
(tblraceheader. TrackName = qryhorseandrace .TrackName);

qryappendracede tails

INSERT INTO tblraceheader ( TrackName, RaceName, RaceDate, Distance,
RaceType, Surface )
SELECT DISTINCT qryhorseandrace .TrackName, qryhorseandrace .RaceName,
qryhorseandrace .RaceDate, qryhorseandrace .Distance,
qryhorseandrace .RaceType, qryhorseandrace .Surface
FROM qryhorseandrace LEFT JOIN tblraceheader ON
(qryhorseandrac e.RaceDate=tblr aceheader.RaceD ate) AND
(qryhorseandrac e.RaceName=tblr aceheader.RaceN ame) AND
(qryhorseandrac e.TrackName=tbl raceheader.Trac kName)
WHERE
(((qryhorseandr ace.TrackName)= Forms!frmhorse! subfrmraces!Tra ckName) And
((qryhorseandra ce.RaceName)=Fo rms!frmhorse!su bfrmraces!RaceN ame) And
((qryhorseandra ce.RaceDate)=Fo rms!frmhorse!su bfrmraces!RaceD ate) And
((tblraceheader .TrackName) Is Null) And ((tblraceheader .RaceName) Is
Null) And ((tblraceheader .RaceDate) Is Null));
Wow, this looks like a convoluted mess now that I'm seeing it laid out.
It did take me a long time and several efforts to get it working at
all and it's been working great in the full Access program.

I'm tempted to just tell them hit okay at the append messages but I
know that will bother me.

Thanks for your help,

Lee
Tim Marshall wrote:
Lee wrote:

Thanks for the reply.

I couldn't remember so I just tried it again and I'm still getting the
error "Too few parameters. Expected 3" And that is using the full
Access program.


I usually construct my SQL dynamically (in VBA) rather than used stored
querydefs. I do recall there were sometimes issues using stored queries
and the execute method. Can you post the SQL of the query(ies) that's
causing this? Unless you figure out or someone comes up with a better
solution, of course. 8)

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me


There are 3 references to Forms!frmhorse! subfrmraces. I would assume
that is where your errors are cropping up.

You might want to check out Parameters in help. See if that will assist.

If not, use DAO or ADO to open up the recordset and add the records.
That would be faster, I think, than banging your head against the wall
attempting to make an insert query run.

Another thing to do is enter your values without clicking on the button.
Then open the database and go to the query and try to run it from the
database window. If it errors, it may have the insert at the point the
query chokes.

Nov 13 '05 #7
> form, and can't be used anywhere else - so, it is not a good programming
practice to use a form expression inside of a query anyway, and it is not
regular sql).
--
Albert D. Kallal (Access MVP)


Albert, I use form expressions all the time in queries that are used as
recordsources for subforms. For example:
Select First, Last, Phone from tblPeople where PersonID =
forms!frmPeople .txtPersonID
I got the idea from the Access Developer's Handbook, so I thought that was
the best way to go.
Are you recommending just leaving with subform without a recordsource at
first, and then when the main form loads (or a textbox is updated or a
button is pushed), setting the subform's recordsource dynamically?
Nov 13 '05 #8
Albert D. Kallal wrote:
I don't know why the set warnings would fail,I would assume that:

docmd.SetWarnin gs (false)

DoCmd.OpenQuery ("qryappendtblr aceheader")
DoCmd.OpenQuery ("qryappendrace detail")

docmd.SetWarnin gs (true)

I would think the above should work.

I would actually not try and open a query to run it however (you don't need
to try and open a query to run it..).

If you use the execute method however, then you need to supply the
parameters your self, and you can't use a form expression the sql (I never
understood why people do that..as it just creates a absolute mess anyway).
And, if you queries don't have any parameters, then I not sure what the
problem is.

You can go:

Dim q As DAO.QueryDef
Set q = CurrentDb.Query Defs("query9")
q.Parameters(0) = "abc"
q.Execute

The above assumes you only have one parameter.

So, if you use the execute method for a query, then you don't have the
expression service to resolve the parameters, but you MUST supply the
parameters in code.

As mentioned, I don't know why the set warnings don't work. (however,
relying on the possibility that some form is open, or not open for the query
to run is not a reliably approach anyway, and then that sql is tied to that
form, and can't be used anywhere else - so, it is not a good programming
practice to use a form expression inside of a query anyway, and it is not
regular sql).

Near as I could tell the problem isn't so much with the messages is that
even tho the queries run, they don't append records so the new form
opens up with nothing. I think once he gets the queries working he can
set the warnings to false/true.
Nov 13 '05 #9
Albert, I use form expressions all the time in queries that are used as
recordsources for subforms. For example:
Select First, Last, Phone from tblPeople where PersonID =
forms!frmPeople .txtPersonID
I got the idea from the Access Developer's Handbook, so I thought that was
the best way to go.
It is more of a easy way to go. I can't rally agree with it being the best
way to go. So, easy <> best!

The result of the above sql is now you got this very bad looking sql.
Further, that sql is not compatible with any other sql dialect I seen.
Further, if that form is closed (on purpose, or by accident), then the sql
don't work. And, worse, that query, or sql can ONLY be used when that form
is opened. This is hardly a re-usable approach here. And, if you want to do
data processing, and execute the sql in code, then again you are asking for
trouble. I guess I have the view that you need to figure out the sql, and
THEN send it off to the data engine.
Are you recommending just leaving with subform without a recordsource at
first, and then when the main form loads (or a textbox is updated or a
button is pushed), setting the subform's recordsource dynamically?


Your above need has little, or no relation to needing to using sql with a
forms ref. The above is talking about a datasouce being blank, or not set
for a sub-form. That decision is up to you. But, yes, in the above case, I
would suggest that you put in the sql in code. If you are having to use some
code in this sub-form setting example, then throwing in a extra parameter in
code is really NO MORE work then typing in a very ugly form ref expression
in the query builder. And, as mentioned, that resulting query now married to
that form. Further, if you got query in a sub-form that tied to expression
in the main form, then when do things get executed when you change the forms
value that the query refs? (you have NO IDEA)....

So, to set that sub-form in your example via some button code, I would use

me.SubFormConto rl.form.ReocrdS ource = "select * from tblCust where id = " &
me!someID

And, if you need the sub-form to be based on a query, then use

me.SubFormConto rl.form.ReocrdS ource = "select * from myquery where id = " &
me!someID

Keep in mind that you need to correctly form the sql, and thus if the above
someID is text, you need to use quotes: eg:

me.SubFormConto rl.form.ReocrdS ource = "select * from myquery where id = '" &
me!someID & "'"

The great thing about this is now we have a query that can be use over for
other things (like reports etc.), and we don't have to worry, or care if
some form is open. I mean, you look at some applications, and they got 10
copies of the same query..and the only thing different is forms refs.

What is even worse when you use form refs is what happens when you want the
parameter to be optional? then the expression starts to get really messy
here. So, at the end of the day, those sql form refs are NOT flexibility at
all.

Further, if you use the execute method of a query, then you don't have the
expression service for you in resolving form expressions as parameters
anyway (this seems to be your problem in the original post).

Also, in your/our sub-form example, it sounds like the link child/master
fields could do this job anyway...

In the case for opening a form, or report that needs parameters, then just
pass the "where" clause to that form/report if you need parameters.

docmd.OpenForm "frmCustomers", ,,"custid = " & me!someCustID

This again allows you to use clean sql for the form (or report). This is the
whole idea behind the "where" clause for those forms/reports anyway.
Further, when you build nice form prompt screens, allowing optional
parameters is far more easy. Sure, you have to write a bit of code, but the
resulting increase in re-use of the sql, and ease of maintains offsets the
small amount of code.

If you take a look at the following repro prompt screens you will note that
most options are optional. They are optional due to the fact that I open the
reports with a where clause, and don't use sql with reference to forms for
parameters.

http://www.members.shaw.ca/AlbertKal.../ridesrpt.html

About the only thing I can say about placing forms references directly in
the sql is they are easy at first, but over time, they are not all that
great. And, to be fair, those expressions can be used in place of having to
write code. So, ones mileage will depend on this. I can't make it a rule and
say don't use forms expressions in sql. This would be mean on my part, and
would suggest that some people have to use code (and, they might not know
code!!). So, this suggestion to avoided forms expressions really is one of
those things that one learns over time, and may NOT apply to everyone.

The only thing I can point out is that there is some real downfalls. And, in
many cases, you might not experience those downfalls.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl************* ****@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2722
by: Juho Saarikko | last post by:
I made a Python script which takes Usenet message bodies from a database, decodes uuencoded contents and inserts them as Large Object into a PostGreSQL database. However, it appears that the to last few bytes of uudecoded data are always mangled. Take a look of this hexdump output: Originals (decoded with Pan, each line is from a different file): 000c2c0 e1bf 00ff 2541 a9e4 a724 d9ff 0011a10 ff54 00d9 00093e0 fb4f a80d ffd9 c200 ffef...
4
1906
by: Ola Tuvesson | last post by:
I'm having a really weird problem. When running the SP below in query analyzer the calculated column "Subscribed" is returned as expected: ------------- CREATE PROCEDURE get_mailinglists( @intCustomerID AS int ) AS
5
4476
by: deko | last post by:
How to run action query against linked table? I have an Access 2003 mdb with an Excel 2003 Workbook as a linked table. When I attempt to run an action query against the linked table I get this error: Deleting data in a linked table is not supported by this ISAM. From what I understand, indexed sequential access method (ISAM) drivers are used to update "non-Microsoft" file formats. So why doesn't Access
4
1906
by: Eric E | last post by:
Hi all, I have a fairly complex form in Access 2000. In particular, it has two subforms on separate tabs of a tab control. For the last two weeks, I've encountered the dreaded : "You can't carry out this action at the present time." error, runtime 2486. Subsequently Access will not exit the form, and shuts down uncleanly. Looking back on the messages here, this seems to be an indication of a corrupt object in the .mdb. So I imported...
7
6328
by: TSanders | last post by:
Wize ones: I created an Access database for a local telco that is split into a front and back end. I would like to distribute the Access runtime along with the front end. When I use the front end with the Access runtime, I must confirm every time an action query runs from VBA. I know that in the full version of Access, a user can opt to turn off notification every time an action query runs from VBA. Can this option be exercised using...
5
10645
by: HS Hartkamp | last post by:
Hi all, I am working with fairly large databases (> 500 Mb / < 2,000,000 rexcords), and often need to do action queries on these. I have the feeling that much of the computing power is going into building a table of changes so that you can be prompted "Are you sure to change xx records", and be able to reply no. I regularly get messages that say "Insufficient memory or disk space, you won't be able to undo; continue?"
0
2269
by: kisc71117 | last post by:
When accessing my JSP I get the following error: org.apache.jasper.JasperException: Missing message for key "button.add" my error message javax.servlet.ServletException: Missing message for key "button.add" org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758) ...
8
13611
by: jesmi | last post by:
my code is: addRecord.cfm <cfinclude template="head.cfm"> <p> <table width="100%" border="0" align="center" cellpadding="2" cellspacing="0"> <tr> <td> <div align="center">
2
3151
by: swethak | last post by:
Hi, I am getting the problem the problem with google map in Internet Explorer. This map worked fine in mozilla . When i opened the same map in Internet Explorer i am getting the error message as in alert box as " Internet Explorer cannot open the Internet site http://google.citycarrentals.com.au/viewalllocations.php . Operation aborted". It is working in Mozilla . Here i mentioned my code . I am facing this problem several...
0
8574
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9119
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8994
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8852
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8830
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7664
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6493
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5839
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4582
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.