Errorpoint
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 23 articles for 0.302 sec
Griffo, I'm not sure why you are using subforms for this - it sounds like the sort of thing people often do with cascading combos. You could have 2 combos on the main form. After users select the Progman in the first combo, the second combo has its row source set to only the projects that are in that program. After user selects the project, you can populate the subform with the appropriate     

Group: microsoft.public.access.formscoding · Group Profile · Search for Errorpoint in microsoft.public.access.formscoding
Author: Jeanette Cunningham
Date: Apr 10, 2008 02:59

Hi, Thanks, but I am using the subform control name, not the subform name. I even went in and renamed the subform control just to make sure. Access still wont recognise it, so the problem must be elsewhere. (maybe between keyboard and chair). :) The exact error message is "Microsoft Access cant find the field 'sfrmObjectProject' referred to in your expression." Error 2465. -- Your
Show full article (3.72Kb) · Show article thread
Griffo, where you use the name of the subform as sfrmProject, you must use the name of the subform control instead of the name of the subform. The subform is inside a subform control in much the same way as an image is inside an image control. The name of the subform control may be different from the name of the subform. Jeanette Cunningham "GRIFFO" <GRIFFO@discussions.microsoft.com     

Group: microsoft.public.access.formscoding · Group Profile · Search for Errorpoint in microsoft.public.access.formscoding
Author: GRIFFO
Date: Apr 9, 2008 23:37

Hi, I have successfully used Allen Browne's method to use a combo box to find a record many times, it is excellent. Thanks Allen. But I was wondering if anyone could help me with some code to do the same, but on a sub form. Database structure: One program has many projects. That is, I have a one to many relationship between tblProgram and tblProject. The main form has the tblProgram
Show full article (3.02Kb) · Show article thread
This code to create an email by double clicking is great! Can code be added so that not only will it fill in the email address, it will fill in the subject line and message body based on two separate text fields that I already have populated? "Jeff Conrad" wrote: > "tlaker" wrote in message: > news:66C76F34-1FF6-4DE3-8583-E31BA381F77B@microsoft.com... > > > when entering an e-mail     

Group: microsoft.public.access.formscoding · Group Profile · Search for Errorpoint in microsoft.public.access.formscoding
Author: Jeanette Cunningham
Date: Apr 9, 2008 23:21

Steve That helped, along with one other change - see attached code. The re-arrangement of the set focus works properly as you suggested, but the alteration to the error handler keeps the sequence going until Excel has a chance to get started properly before the focus is switched. as soon as that happens the eror handler keeps things going again (from the save line) until Excel registers
Show full article (2.39Kb) · Show article thread
Try switching the lines so that you save the xl doc before setting focus to Access. If xlFound Then xl.ActiveWorkbook.SaveAs fName, -4143 ' normal workbook format SetFocusAPI Application.hWndAccessApp End If Steve "Keithr" wrote: > Can anyone work out why the following code fails to re-activate the Access > application. The code fails at the point where     

Group: microsoft.public.access.formscoding · Group Profile · Search for Errorpoint in microsoft.public.access.formscoding
Author: GRIFFO
Date: Apr 9, 2008 23:12

Can anyone work out why the following code fails to re-activate the Access application. The code fails at the point where it tells the XL object to save the file in workbook format. I've tried using AppActivate instead of SetFocusAPI, to no avail. The Debug.Print gets the correct application name and xlFound gets to true, but nothing else works on the xl object. When the code stops on the
Show full article (1.82Kb) · Show article thread
Hi Steve: The form has a tab control with 2 pages: Page 1 has 5 or 6 textboxes and some command buttons to print reports/close the form/quit the app/reset the criteria. Not too much code so here it all is: Option Compare Database Option Explicit Private Sub cmdChange_Click() On Error GoTo ErrorPoint ' If Form is dirty, save the record If Me.Dirty = False Then     

Group: microsoft.public.access.gettingstarted · Group Profile · Search for Errorpoint in microsoft.public.access.gettingstarted
Author: MikeP125
Date: Oct 4, 2007 08:46

Nothing in your code jumps out at me. I would do sometthing slightly different: If Nz(Me!Combo,"") = "" Then 'will achieve the same Small difference but less code to write... I would be curious to know if this form opens directly from the database window on the other machines. What controls do you have on that form? Is there anything special happening in an event on that form? Try commenting
Show full article (2.26Kb)
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Errorpoint in microsoft.public.access.formscoding
Author: Keithr
Date: Sep 27, 2007 02:19

Show full article (1.53Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Errorpoint in microsoft.public.access.formscoding
Author: SteveM
Date: Sep 26, 2007 13:10

Show full article (2.67Kb) · Show article thread
    

Group: microsoft.public.access.formscoding · Group Profile · Search for Errorpoint in microsoft.public.access.formscoding
Author: Keithr
Date: Sep 26, 2007 08:52

Show full article (2.26Kb)
    

Group: microsoft.public.access · Group Profile · Search for Errorpoint in microsoft.public.access
Author: Fred Boer
Date: Sep 7, 2007 18:36

Show full article (5.98Kb) · Show article thread
    

Group: microsoft.public.access · Group Profile · Search for Errorpoint in microsoft.public.access
Author: SteveM
Date: Sep 7, 2007 18:24

Show full article (6.19Kb) · Show article thread
1 · 2 · 3 · next