Search results

  1. M

    Slow Query on table with many memo records

    Len, Fofa, Thank you both for your replies, just to answer some of the queries below: The unique ID for the table, EscJornalId, is indexed, I will be testing this though with the indexes set on the other fields, to see fi that speeds up the search at all. Also the 255 limit is too small, I...
  2. M

    Slow Query on table with many memo records

    Ok my database tracks escalations through my team, I have a main table that stores the unique ID's from the other tables I use in my Combo boxes, this part works really well, no problems. My issue is with a tableI have claled "TBL_EscJournal", this table has the following fields: JournalID...
  3. M

    Switching subforms based on a record selection

    Thanks Pat, Got it working, makes perfect sense once I had read your repsonse. Thanks for your help MattP
  4. M

    Switching subforms based on a record selection

    Pat, Couls you confirm how I could do this (not sure on the coding) I have now set my main form to have both subforms on the same screen. Sub from "FRM_SUMMARYOPEN" is at the top half of the screen, that lists all my current open records. Sub Form "FRM_MAINDATA" is on the bottom half of the...
  5. M

    Switching subforms based on a record selection

    Pat, Do you mean to have both subforms on the screen together and link the parent/child ? Regards MattP
  6. M

    Switching subforms based on a record selection

    Right slightly complicated (in my eyes) and I have not found anything in previous threads to help but here goes: I have a main form (FRM_SUMMARYREVIEW) that has an unbound subform field on it (subfrmmaster). When FRM_SUMMARYREVIEW is first opened subfrmmaster has its sourceobject set to a form...
  7. M

    Checking field for a value

    Ok so I've got the following code behind my close form button Select Case me.root (field which sets my crieria) Case 1 If Me.Office = "" Then MsgBox "Please select an Office location", VbOkOnly Else Docmd.close Case 2 DoCmd.Close Case 3...
  8. M

    Checking field for a value

    Ok so I've got the following code behind my close form button Select Case me.root (field which sets my crieria) Case 1 If Me.Office = "" Then MsgBox "Please select an Office location", VbOkOnly Else Docmd.close Case 2 DoCmd.Close Case 3...
  9. M

    Checking field for a value

    I'll have a go and see how it goes, thanks for the suggestion MattP
  10. M

    Checking field for a value

    I've had a search in the threaqds for an answer but cannot find anything specific, plus this one has stumped me. What I need to do is check if a certain field has a value if another field has a specific value ??!!? Ok so if Combo Box 1 is set to 1, then Combo box 2 must have a value selected...
  11. M

    Text boxes behind a sub form

    Thanks for the quick response, I see what you are saying now but cannot get that to work, Subform is always over the top of the label ? I'm playing with a menu sample I've found, if I get that working I'll post the sample as it is a very simple menu drop down but looks rather nice. Thanks for...
  12. M

    Text boxes behind a sub form

    Thanks for the suggestion and I'll try this, however, do I use this in the VBA code and if so how do I use the "Format" command, everything I've tried to enter seems to be assuming I'm formatting a date function ? Thanks MattP
  13. M

    Text boxes behind a sub form

    I wonder if anyone could help me here: I have my main form that has a row of buttons at the top, some of these buttons have multiple functions so I have some hidden text boxes underneath that appear on the mouse move command, giving the impression of a drop down list for that button. Just...
  14. M

    Sendkeys Syntax

    I won'tnecessarily be sending the "PrintScreen" key to another application, I will be using that keystroke to capture the image in Access (to the clipboard), the other application will be opened and then, hopefully a keystroke to paste the image from the clipboard. Not sure if that makes sense...
  15. M

    Sendkeys Syntax

    I have put together various charts form my DB, using Pivot charts but would like to be able to export these out to Powerpoint, easily. I am trying to use a macro and the "SendKeys" option to take a snapshot of the screen(form) and then have it pasted into Powerpoint. Does anybody know the...
  16. M

    Changing subform size

    Uncle Gizmo, Ok thanks for that, hopefully someone will be able to shed some light on this one. MattP
  17. M

    Changing subform size

    A quick design question here, Is there any code that you can add so that you have your main form open to maximise and your subform adjusts accordingly ? My database is used by a number of users, some use 1024x768 and some use 1280x1024. I want the main form to maximise when loaded but I would...
  18. M

    Showing latest toal for the day.

    Ok i have searched through the forums but can't find anything that is specific to my problem. On my database I have a main screen, that has several option buttons on it, and asubform for the main data entry. On the main screen I have a text box that is bound to a query that counts a total of...
  19. M

    Showing latest toal for the day.

    Ok i have searched through the forums but can't find anything that is specific to my problem. On my database I have a main screen, that has several option buttons on it, and asubform for the main data entry. On the main screen I have a text box that is bound to a query that counts a total of...
  20. M

    SubForm hiding text field

    Godofhell, Thanks for the feedback and help, I did come across the attached sample, that has Windows type menu's which I am looking into at the moment. This sample was kindly supplied by http://www.candace-tripp.com/. I have incorporated this into one of my main forms and it works really...
Back
Top Bottom