Search results

Well, they are answered, but seeing your post... What do you mean by Master file? To put it pretty straightforward (I think). If you can doubleclick the front-end and you get in the db, security is not set. In my experience, give every user his/her own frontend (otherwise you'll have problems...

Do the users have the mdw file in their shortcut? Place the security file in the same folder as the BE (for accessibility reasons) and have them use a shortcut with something like : "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "D:\Data\Access\Helpdesk Benelux\Helpdesk...

Dont' forget a ; at the end of the sql statement

I guess it's because it's a integer field which holds the data, so you cant set text as a value. I have done some testing and didn't find an option to display what you want, but I do understand what you mean you can try to work around it a textbox on top of it with the text you want and code in...

Shouldn't the relation between the lesson tbl and the planprogamdetail tbl be the other way around? Btw, if you try it, make a copy of the mdb first :)

or if that doesn't work try Private Sub cmdNotifyChampion_Click() email = Me.EmailChamptionID.cemailaddress DoCmd.SendObject , , , email, , , "TS16949 Non-Conformance #" & Me.Text19 & "", "hello", False, "" or email = Me.EmailChamptionID.cemailaddress.Fields(2) You can try with a...

I think you have a problem using vba objects I've experienced funny things using them. For example in 1 database I have several forms. On 1 form I use vba the way it's supposed to, object related and it works. When i copy/paste the same lines into another form, I get the compile errors...

I've looked at the sample and I think it's not that difficult to help you out here I changed the master form to single form in it's properties and I changed the child form to continous form (and moved the fields a bit, the labels in form header). Looked like it should? Ok, you can do more on...

I am under the impression that on closing access, a subform remains longer than a parent form...

hi Dave, I have ran into a similar problem using parent/child forms and the on_current action, so this is a subscribtion to the thread as well. Is there indeed a priority in the handling of actions?

Does your listbox still have an after_update event set to vba-code? I have have copied this from a form where List24 is the name of my listbox. Private Sub List24_AfterUpdate() On Error GoTo Error ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone...

Is it always the same subform you use, to get the other subform to display the records? If so, you can use the query of the 'display' subform to get the records you want. Use the criteria field in the query and 'build' it to point to the related field. You can try switching between design and...

In the criteria field below the field name type true (no " " ) That works in 2003, but I think it should in older versions too. If that doesn't work, try -1 (0 = false) You can switch between datasheet and design view when you are trying to get the response you want.

I once read about a similar problem, have you tried before_update ? I guess you have trouble because access tries to save the record when opening the popups

Maybe on_focus? Or does that run every time too? ps. I have a similar question in another topic, I'm also not sure which action to take, so this is also a subscription ;)

Make a query off which the result depends on 'bad' Use that query to make a subform on your form

When I want to make a subform I just use the easiest way I know. 1. Make a query which has the outcome you desire 2. Open the mainform in design view 3. Add a subform using the toolbox with wizard on 4. Select the query and answer the next few questions (you can adjust the parent and child ID...

I just tested in 2003 and i do see '+' in a datasheetview of a form, tested again with another table and didn't see the '+' I guess you have at least 1 subform on the form you view as datasheet

Make the datasheet a continous form Sounds like you have related records and unless you want to break the relation, they will show. But if someone knows how to not show them, plz inform us :)

ah ok why not place the textbox in a subform?