Search results

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...

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...

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...

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

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...