Search results

Hi, I have a split database on a network (LAN). (The network is pretty fast...MS Word and other apps load quickly) The Access database backend contains 1 major table with 65 fields and only 10 records in this table. I have a form in the front end. When I switch this form to design or layout...

Thank you! The subform approach worked well. I created a subform based on my lookup table and then selected this subforms name from the "list items edit form" property under the lookup tab. So now I have a multiple entry combobox which also allows list items editing.

I have a form containing a combobox. This combobox is populated via a lookup table. This table contains two fields: ID and FirstName. The combobox is set to allow multiple values and is working ok, however, my problem is that I cannot add a new item to the combobox list using it on the form? I...

If you are prepared to upgrade to Access 2010 you can do web databases and have them hosted on the internet by www.accesshosting.com (saves setting up your own server $$). Try a free trial of Access 2010 (Office 2010) and a 30 day free trial of AccessHosting.com to see if it's what your after...

Thank you for your help. Great idea. I have also switched from a Navigation Control to a Blank form containing your idea plus a Tab control. The Tab control seems to work better for my Subforms. Thanks.

Hi, I have an Access 2010 (Web) Navigation Form containing 2 tabs. Tab1 contains Subform1, while Tab2 contains Subform2. I want subform2 to be related/influenced by subform1; so that a record shown/selected in subform1 results in the related records in subform2 to be shown. Like a parent/child...

Yes, thanks.

My report is reporting all records :mad: I just want to report the current record. Is there a setting in the report properties to only report the current record? Thanks. Jason.

Thanks HiTechCoach...most helpful :). I've also found the following works for part1: 1) Add the Word doc to a form as an embedded object in an Unbound Object Frame (tick: add "as icon") 2) Set this Unbound Object Frame (icon) to hidden 3) Button "on click" code: Private Sub...

Hi, I have a small Word doc (43kb) embedded(?) (not linked) as a record in an OLE field. I have a button on a form (record source = table containing Word doc), when clicked I want to open the Word doc. Question 1: What is the button's "on click" vba code to open this word doc? Question 2...

I've tried to fix my linking problem but it is a really tricky problem.:confused: I cannot find any way of getting my child fields to autopopulate as they should (because they are based on parent fields of unbound comboboxes). i.e. the user selects a staff member from a Staffcombobox and a year...

Hi, My attached database contains a problem with the linking of the subform "SubFrm_Projects_Highlights" to the MainFrm. When entering data into the subform (while nested in the main form) I get an automation error. I want to link the subform so that it is filtered by Staff Name and Year...

vbaInet and gemma-the-husky thanks for your comments. The continous form option worked great! (Regarding the focus moving away...the record number remains unchanged in the subform so presumably code could still be used to identify the selected subform record.) Anyway I've fixed my problem using...

Hi, I have a form1 containing a subform(datasheet). I have a delete record button on the form1 which, when clicked, I want to delete the current record in the subform(datasheet). I'm not sure how to go about doing this. I'm not sure of the delete record code required, given it is a delete button...

Thanks vbaInet! It worked like a charm! The code I am using is: Private Sub Form_Load() Dim i As Integer Dim varLastYear As Integer varLastYear = Year(Now()) - 1 For i = 0 To Me.Combo15.ListCount - 1 If Me.Combo15.Column(1, i) = varLastYear Then...

comboboxName.value = Year(Date()) - 1 doesn't work because comboboxName.value is calling for the record ID not the year (it is a 2 column combobox: ID, RRYear). I guess I need to 1)find the record of interest, and then 2) set my combobox ID to this found record of interest. To this end, I have...

It only works for new records; which isn't applicable here; the combobox is unbound (the combobox looks up its values from a table but does not write to this table). I want the combobox to pre-select / pre-populate with 2009 (the current year -1) on load by simply looking up 2009 (or the current...

Hi, I have a combobox displaying a list of years...2009, 2010, 2011, etc. I want to set the combobox's default value to year(now()) -1. i.e. 2009. My options are to put some sort of expression in the combobox's default value property OR use VBA code. Any suggestions on an expression or VBA...

Hi Bob, Please find a sample db containing the error/problem attached. Thanks, Jason.

Hi Bob, Thank you for your comments. I'm really stuck on this one and I was hoping you would help. My problem is described in the thread "VBA Undo Command not Undoing" by me a couple of days ago. I'm still trying to solve the problem. Your comments would be most helpful. Thank you. (User...