Re: Strange fault

Very strange that you couldn't set the UniqueTable property in code, first
time that I see this. In what event did you try to do this?

For your ResyncCommand, you can try something like this:

"SELECT * FROM [C - Giornale] WHERE [ID giornale] = ? "

Access should replace the ? with the value of the primary key for the
current record. However, as you have some trouble with the UniqueTable
property, I'm not sure if this will work. Also, personally, I prefer to use
a stored procedure and set this value for the form with something like:

MyResyncSP ?

For the question about the support from MS; it's look like that MS has
dropped the ball in favor of .NET or for those who insists to use Access, in
favor of ODBC linked tables in a MDF file; so don't expect to see any ADP's
problem solved (and quite probably, this will also be true for the next
version of Office).

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Atlas" <atlaspeak@xxxxxxxxxxx> wrote in message
news:11uop66mhllnvda@xxxxxxxxxxxxxxxxxxxxx
Creating a ResyncCommand and setting the UniqueTable property correctly


Ok I couldn't set programmatically the uniquetable property (errors),
nevertheless placing the following command in the form's beforeupdate
event solved the problem.

Me.ResyncCommand = " SELECT * FROM [C - Giornale] WHERE [ID giornale] =
" & Me.ID_Giornale

There's a slight "flash" when the command is executed......but it works!
And it looks like only that record is requeried, not the whole recordset.

One funny beheaviour: I've began setting the me.ResyncCommand in the
form's Load event; obviously it wouldn't work because the field
Me.ID_Giornale was set at load and never changed, hence the resynched
query would load always the first record int the recordset and MAGIC:
multiple instance of the first record would appear!!!!

Strange no?

Another strange thing is that the form did'nt have any multitable or
innerjoined table. The problem arised only when a WHERE clause was
specified.

What is unbeleivable is that since jan 2005 they didn't fix the problem
that occurs only in access 2003.

Did they decide to abandon the pot?



.

Relevant Pages

  • Re: Strange fault
    ... nevertheless placing the following command in the form's beforeupdate event ... There's a slight "flash" when the command is executed......but it works! ... Load event; obviously it wouldn't work because the field Me.ID_Giornale was ... Strange no? ...
    (microsoft.public.access.adp.sqlserver)
  • Re: lorries v cars
    ... In article, SteveH ... > The decision is 100% driven by cost. ... Strange when last week I went to pick up a load of chocolate Santas to ...
    (uk.rec.driving)
  • Re: Cannot access microsoft.com
    ... if you get strange results, pointing mostly to ads/commercials, you're in big trouble. ... You could be hijacked and you need antivirus tobe updated via FTP site on ANOTHER computer, then load it on yours and run it in SAFE mode, not in regular windows. ... But if you can load Symantec, it maybe just Microsoft was down at the time which is highly suspicious. ...
    (microsoft.public.windows.vista.general)
  • Re: lorries v cars
    ... >> The decision is 100% driven by cost. ... Strange then once in the mid 90's when there was a load of ... > phrase "name your price" cropped up. ...
    (uk.rec.driving)
  • Re: D***n dictionary
    ... On Jul 8, 7:37 pm, Cheryl Flanders ... What is strange is when I opened the dictionary on my old computer the ... Cheryl, yes, I did load Stedman's years ago, but can't find it on my ... A friend has one ...
    (sci.med.transcription)
Quantcast