Search results

Yes, you understand correctly. I tried entering this... Me.Combobox.Requery as well as... Me.Requery on the OnActivate event of the subform on which the combobox resides. Didn't work in either case. Other suggestions? Thanks, Zarty

There is the main form, which contains a record by record display from 'tableA'. On the main form is a subform that contains a list of records from a Fact table, TableB. The records in TableB are related by FK relationship to TableA. The combobox allows a lookup to TableC. On the mainform is...

Yeh, I tried that before. I should explain, on the subform, there is are multiple rows and the dropdown appears on any row you click on. By default, when you make focus on the subform, the dropdown appears on the first empty record in the list. Fine. However, if I put the requery on the...

Thank you, that was a useful link and, yes, that was most of the problem. In the popup form that allows rows to be inserted/updated/deleted from the lookup table referenced by the combobox on the subform, I entered an 'After Update' event and put in the corrected object reference as per the...

The me.refresh didn't work but had the effect of refreshing the subform but not actually getting the updated data in the combobox on the subform. Also it had the effect of not putting the comboxbox dropdown on the next empty row at the bottom of the list - it just went to the first row. The...

I have a main form and on that form there is a subform. The subform displays detail records relating to the main form... the Main form gets its record set from TableA. The subform gets its data from TableB and TableA and Table be are linked via a FK relationship. On the subform, there is a...

Thanks. useful.

I solved it myself. From within code you can refer to the hyperlink's "Hyperlink Address" property... Me.ReportForDeal_hyperlink.HyperlinkAddress = "http:\\someURLpath&ID=" & Me.ID.Value where Me.ID.Value is the field on the form, which is the parameter to pass. Still have an open...

Is it possible to open an Access form from the command line with a parameter so that the form opens up and displays at the record defined by that parameter? So, for example, if the main 'Primary Key' field at the top of the form was called 'ID' with a numeric value, could that ID be passed...

I can create a hyperlink from an Access form to open a web page from a URL no problem but can anyone advise the best way to pass the value of a field on the form as a parameter in the URL? For example, a normal URL hyperlink might look like this... http://[server]/reportserver?MyReport The...

Ok, I have a working solution now. The subforms are disabled, not locked using 'Me.' Similarly enabled 'after update'. Question... Is there a simple way to 'grey out' a subform? It'll still need disabling but greying out make it clear to the users. Zarty

Ok, I've almost answered this question myself... In the 'Current' event of the form... If Me.NewRecord Then Me.subform.locked = True I suppose I can use other events like 'after update' to unlock the subform(s). Ideas still welcome. Zarty

I have a MS Access 2003 app pointing to a SQL Server database. The main form has two subforms on it. The main form contains a few fields that, due to referential integrity rules, have to be completed before data can be entered into the subforms. From a db design point-of-view, this makes...

Thank you, I'll try that out and report back.

Yes, it's ADP. Is there a better way to do it with ADP? Regards, Zarty

I've been going around in circles with this. I want to find out if it iis possible to use a stored procedure with a parameter as a row source? I imagine this would be exactly the same using a query with 'variables' in the where clause. Thanks, Zarty

Yes, that works a lot better thank you. Excellent! Regards, Zarty

Yes, that makes sense. Unfortunately though, when I tested it, it breaks when I try to add a date to one of the date fields via the calendar control. It actually changes the date but bugs out on cboOriginator.SetFocus ... Run-time error '2110': Microsoft Office Access can't move the focus...

Thank you khawar, The only problem with your solution is that my form has quite a few fields, controls, etc. I would have have events where none exist right now and every field/control would have to be amended to make the calendar control invisible. Is there another way to do it? Clive

I was looking for a solution to enable a popup calendar for two date fields on a form. I found this... http://www.fontstuff.com/access/acctut09.htm It seems quite good to me and I have a solution working using the suggestion in the article. Essentially, the calendar becomes visible when either...