473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

CurrentDb.Execute Problem

91
I have the followind code executing when a popup form closes.

Expand|Select|Wrap|Line Numbers
  1. CurrentDb.Execute ("UPDATE Orders SET RequiredDate=#" & [ShippedDate] & "# WHERE OrderID=" & [OrderID] & ";")
I need the 'RequiredDate' field in the backend db to update to what is stored in the [RequiredDate] fireld. I also have the Shipped date updating in the db but that is done automatically since it is bound.

First I got the "Write conflict" errors, but once I fixed those, now it will work but only if I update the shipping info, close the form, open it again, then close it (it will work once the same shipping info is there, and the same after closing the subform twice)
May 12 '10 #1
1 1530
TheSmileyCoder
2,322 Expert Mod 2GB
You need to show us the rest of the code and the context in which it is being used. The code you have shown us should work fine, so there must be something your not telling us. Im guessing it involves requerying some information on your form, but you have to provide more details for us to help.
May 12 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Savas Ates | last post by:
iam using codes which only execute first query. in loop other queries i can write screen them but only first query making executed.. why? for bul=0 to sayac-1 set...
1
by: The One of Need | last post by:
This newsgroup is tapped so I must be brief. When using VB and ASP 3.0, I did the clever dynamic include method of using "Server.Execute", but switching to ASP.NET and C#, it does a myriad of...
1
by: dbb9h | last post by:
I've noticed a problem with calls to server.execute on a webserver running IIS 5.0. The call is used to conditionally include some asp code according to the language, but there seem to exist...
6
by: PiGei | last post by:
hi all, I'm trying to use server.execute statement to include in an asp page another asp page with a parameter. That's because I've a parametric query in the second asp page and I have to pass...
8
by: frank | last post by:
Below is some code for doing and insert into one of my tables. The inserts do not work because a duplicate key exists, which I want to happen. The problem is, I cannot get access to return an error...
1
by: GSteven | last post by:
I have a statemnt which says: CurrentDb.Execute strSQL, dbFailOnError where strSQL is a create query. Is there an overwrite option for the execute method so thath I don't get the 'file already...
2
by: Chris Roberts | last post by:
Hi, I was wondering if anybody can help, I have a ASP.Net application and am currently trying to get the Server.Execute method to work but I keep on getting the following error "Exception of...
12
by: saddist | last post by:
Hello, I have a problem with connection.execute statemant Con.Execute("UPDATE table SET column = 'a'") It does compile, but does not complete. It 'hangs' on this command and does nothing. No...
1
MitchR
by: MitchR | last post by:
Hello Folks; I have run myself into a hole I cannot get of and need some assistance. I have a Form "Frm_ATandT_Activation_Center" that has a sub form "Frm_ATandT_Activation"....
2
by: =?Utf-8?B?QmFiYQ==?= | last post by:
Hi, using ADODB in ASP pages we have this strange problem. If we create an ADODB connection specifying the DNS server name instead of IP server address, then sometimes, during call to Execute...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.