B792
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 140 articles for 0.303 sec
----- Let's Get Physical ----- /, Globalfight Personals: h0t_d0c City: State/Country: Age: 38 Taste: Gay Prefers: Age is not important to me Look for 3 matches: 1. Wrestling in tank tops and boxer. 2. Pull off boxers and tank ops. 3. Rip off briefs. Loser gets topped. ----------------------------------------------------------------------- DO NOT     

Group: alt.personals.bi · Group Profile · Search for B792 in alt.personals.bi
Author: bounce
Date: Aug 31, 2008 09:15

Just as you can save each sheet as HTML you can save each sheet as its own workbook AND keep your workbook with all the sheets as the master. A macro could do the saving in a few seconds, overwriting the old user workbook if it exists. -- Jim "pattyw" <pattyw@discussions.microsoft.com> wrote in message news:52CA1E26-CDFA-4540-93B4-730374BF5852@microsoft.com... | Thanks for the info
Show full article (16.14Kb)
Thanks for the info Jim. The problem is that I need to have all 70 worksheets in one workbook when working with them. The 70 worksheets link with one lare master workbook. The 70 worksheets are basically identical dashboards and so it is handy to have them grouped when I need to make a change that applies to all 70. That is why I liked the web page method, becuase it allowed me to easily     

Group: rec.sport.tennis · Group Profile · Search for B792 in rec.sport.tennis
Author: bob
Date: Jul 31, 2008 17:36

When you save a worksheet as a webpage it is no longer a real worksheet and most Excel settings are lost. At the risk of stating the obvious, saving each worksheet are its own workbook should fix these issues. If users do not have Excel there is a viewer available from MS. -- Jim "pattyw" <pattyw@discussions.microsoft.com> wrote in message news:08C57DDD-B792-459A-8CED-33FACC95B724@microsoft
Show full article (0.32Kb) · Show article thread
The code is updating an "Record in Use" type of field. I can't use the BeforeUpdate as I need the field to be updated to prevent other users from attempting to update same record. I figured out another way - on the edit click, I check to see if the record is in use, if it's not, I set it and save it (using the DoCmd.RunCommand acCmdSaveRecord). On the Cancel click, if it's dirty, I undo     

Group: microsoft.public.excel.misc · Group Profile · Search for B792 in microsoft.public.excel.misc
Author: Jim Rech
Date: Jul 29, 2008 13:25

Hi cmw What are the fields that you are changing in code? Can you post the code for your Edit button? If they are fields such as "LastChangeDate" and "LastChangedBy" then the best place to set these is in the BeforeUpdate event of the form after the user clicks the Save button. The point is that if your code changes the fields in the current record of the form's recordset, it won't
Show full article (2.18Kb) · Show article thread
Hi Graham - When the form is opened, the Allow Updates property is false, the edit button sets the property to true, determines which fields can be edited based on the user's credentials and writes data to the table. When the record is saved, the data the user entered on the window is saved (cancelled performs an undo). I know it's the write to the table that causes the problem, programming     

Group: microsoft.public.excel.misc · Group Profile · Search for B792 in microsoft.public.excel.misc
Author: pattyw
Date: Jul 29, 2008 13:11

Hi cmw I don't quite understand the function of the Edit button. You say: Edit Button - when clicked, the system performs validations and writes data to the table. The user may add or update additional data. I suspect this is what is causing your problem. If this button writes data to the same record that is current on your form, then when the Save button is clicked, Access
Show full article (1.72Kb) · Show article thread
In article <72fd59c9-8681-4a97-aa49-05d3d55f2728@y38g2000hsy.googlegroups.com>, BurtonUrny@gmail.com says... > On Jul 11, 8:47 am, www.bobbarr2008.com <n...@spamm.com> wrote: > > In article <05027e6d-ff7d-49de-9f2b-a647c0cf8...@27g2000hsf.googlegroups.com>, BurtonU...@gmail.com says... > > > > > > > > > On Jul 10, 9:08 pm,www.bobbarr2008.com<n...@spamm.com> wrote: > > > > In article <7b14844b     

Group: microsoft.public.excel.misc · Group Profile · Search for B792 in microsoft.public.excel.misc
Author: Jim Rech
Date: Jul 29, 2008 11:54

Show full article (1.17Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for B792 in microsoft.public.access.modulesdaovba
Author: cmw
Date: Jul 22, 2008 04:13

Show full article (5.02Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for B792 in microsoft.public.access.modulesdaovba
Author: Graham Mandeno
Date: Jul 21, 2008 21:36

Show full article (4.12Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for B792 in microsoft.public.access.modulesdaovba
Author: cmw
Date: Jul 21, 2008 19:56

Show full article (3.27Kb) · Show article thread
    

Group: microsoft.public.access.modulesdaovba · Group Profile · Search for B792 in microsoft.public.access.modulesdaovba
Author: Graham Mandeno
Date: Jul 21, 2008 14:43

Show full article (2.22Kb) · Show article thread
    

Group: talk.politics.misc · Group Profile · Search for B792 in talk.politics.misc
Author: www.bobbarr2008.com
Date: Jul 16, 2008 18:25

Show full article (7.76Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next