Search results

Hey all, Quick question, is it possible for Access (2010) to just display the month and year rather than making people pick an acutal day in that month? Thanks, -NS

Thanks for that JDraw. This seems like the basis of a good solution. How would one normally going about ensuring that the ID in TblHistoryInfo is automatically set to the value in tblCurrentInfo? Thanks! -NS

Hi, I'm having a little trouble with this one. I basically need a little nudge in the right direction of how I could possibly achieve the following.. I am in the first stages are creating a database. It will hold records in one of the tables that at some point may be superseded by newer...

Many thanks John, I will give this a try.

Hey all, I have a combo box on my main form with a few text boxes under it. I can easily populate these text boxes with info related to the combobox box by using the column(n) method. However, because one of the fields is a memo field, it wont be included in the combo box. Is there an...

Hey all, A bit of an odd one but I would like a few text boxes to be populated on the main form when a record in the subform is clicked. So, on the subform, if I click into record number 3 I would like the text boxes on the main form to display employee name, age or whatever else is stored in...

Hi All, As the title says really...I have a form with a combo box and a subform. When the user opens the form I'd like to prevent them from entering a record in the subform before they select an option from the combo box. The combo box is linked to the subform via child/master links as normal...

Sorted it :) Indeed I should be! I've made it equal the txtNotes field. Thank you for your help, I've learnt a couple of things here that will help me a lot. I never knew that Access would simply "pick up" the row ID when opening a popup form..Magic ;) Thanks again, -NS

Private Sub txtNotes_AfterUpdate() Forms!fEmployeeDetails!sfEmployeeChoices!Notes End Sub

Forms!MainFormName!SubformName!Textbox Obviously changed for my form names etc.

Right, just tried this and I get a compile error ("expecting a =") when I enter the After Update/Load Form codes. Any idea?

I'm having a problem because the subform has multiple records and therefore mutliple buttons. When I click any of those buttons, I need to somehow tell the popup form that "this note is for record with the ID 211". I'm having trouble seeing how to do that when the popup form is unbound. Perhaps...

Ok Great, I can see how that will work. However, now the popup form is unbound, I have the problem of linking the Notes field to the subform record of which I'm entring notes for. :o/ Can I ask, should the whole popup FORM be undound, or just the Notes textbox? Thanks, -NS

Thanks, I think I'm just going to have to give this a go and see what happens. I the bit I am struggling with is... I open my database, locate a record, enter a note in the popup form, after update event kicks in and puts the text in the notes field and I carry on using as normal then close...

Ah yes, the recordsource does, is that what you were refering to? If so.....If I use an unbound textbox in the popup form and then put the code in the After Update event, how will the Note be there if I close it an open it back up again 5mins later? Surely I'd need to use an event to pull...

I'm a little confused, I think I may have given the wrong impression. I not have a Notes textbox in the subform. Instead of a Notes textbox I have a little button. When this button is clicked, it opens up a popup form using a WHERE condition and links the Notes field in the popup form to the row...

Thanks, I will try this. Just one question, if I go back to the record, click the button to open the Notes popup form, will the notes I have previosuly entered be visable? Thanks, -NS

Thanks for the reply vbaInet. I'm a little unsure of how to go about this. I'm dont have a 'note' textbox on the subform, I have a button that opens the popup form that contains the 'notes' text box. In what After Update event do I put that code in? The text box on the popup form? Thanks, -NS

Hey all, Hoping someone can help on this.. I have form with a subform and the subform is linked to a combo box on the main form. Within the subform I have a little button next to each record that, when clicked, a pop up window appears and allows the user to enter a note against each record...

Hey all, I'm running Access 2010 and have a FE/BE database that I would like to secure. I thought I could basically put a password on the BE that would stop anyone from going into the folder and opening the BE directly. However, upon reading some security info on the MS website (link below), it...