Recent content by risicare

Jeff I wish I knew why this happened also. I've learnt not to set the tab order manually, and instead always use the menu option. I hadn't associated the behaviour with having a tab control on the form, but next time I might just check this out. Jason, UK

I'd like to determine whether a form has been opened in dialog mode (modal = yes, popup = yes) after using DoCmd.OpenForm. I thought it would be as simple as - If Me.Modal = True And Me.Popup = True Then ... BUT, Me.Modal returns FALSE even when the form has been opened as dialog. Is there a...

Try this. I can't for the life of me remember where I got this little lot from, could possibly have been Getz & Litwin. Put this code with your start-up form. This code contains some other stuff 'cos it's from one of my projects. Private Sub cmdbtn_yes_Click() ' Tests a linked table for...

Thanks guys. I started with Access because that's what my employer at the time used. But it's a good enough grounding in database basics. My Access app is suited to one of my market segments so no wasted energy. In fact I'm going to ensure my browser front end can speak with both the Access...

I have an Access database that has been my design platform. It now does everything I want it to do. I now wish to upsize it to client server. Ideally I would like a SQL-based relational database that will be as comfortable running on Linux as Windows. I intend to write a browser based...

Thanks. All the labels are attached to their respective controls. This doesn't appear to be the reason for the different behaviours. Incidentally, my understanding of 'print data only' is that none of the labels should be visible. Cheers Jason UK

I don't have a ready made solution, but I think I would approach it this way. 1. Have code in the front-end start-up form create the new table in the back-end database. I'm not sure how to code relationships but there must be a way. 2. Then run the start-up code that checks the links between...

Hi, Strange one. When printing a form and selecting "Print Data Only" check-box on the Page Set-up menu, some control labels are visible and some are not. Mostly they are not visible, but I have a form on which they are all visible, but I don't know why. Copying and pasting one of these...

The recordsource of the subreport is a SQL (SELECT, FROM, WHERE) statement. Everything but the WHERE clause remains the same. Therefore, the subreport displays information from the same tables.

The Parent report displays multiple records. I've got it half working, setting the subreport recordsource using the Report_Open event of the subreport. This will not work if the child and parent properties of the subreport are used. Unfortunately I cannot figure out how to change the WHERE...

I'm having difficulty figuring out how best to set the recordsource of a subreport using vba. The key point is that the recordsource of the subreport needs to change in response to a changing value in the detail section of the parent report. Is there any way that this can be done? Many thanks Jason

Thank-you.

I'm using VB to change the SQL statement in the RecordSource property of a form. I would like the form to save the new SQL when it closes, so that the user goes back to the same record(s) they were at previously when they reopen the form. Reading through Litwin and Getz it is clear that the...