Search results

  1. J

    Debugger complains about [apparently] non-existant characters

    I'm using this code to open a form in print preview: Private Sub cmdPrint_Click() Dim strWhere As String If Me.Dirty Then 'Save any edits. Me.Dirty = False End If If Me.NewRecord Then 'Check there is a record to print MsgBox "Select a record to print"...
  2. J

    How to Restore a window within Access (I'm embarassed to ask)

    How to Restore a window within Access so I can view two side by side.? I'm stuck with only seeing the selected one in this view: i.e. there's no Restore icon next to the X to close the window. Am I being stupid? (It's no different when the main Access window is maximised.) Thanks. PS Sorry I...
  3. J

    Hiding a text box and its label when display of the info is unwanted

    I've successfully used IIF() to hide a label to a textbox when the latter was null. but now i want to hide both textbox and label when the info being displayed is unwanted/inappropriate . This occurs when [Contact Type ID] is 25. (not my choice of field name with spaces!) There are probably...
  4. J

    Local group [club] membership renewal by email, not post?

    Until now the database generates a report of one A4 sheet per member which is ('printed' to pdf, and then) sent to someone else to print on paper. Some members require more than one different forms. (If the email process will work, then it won't matter that some members get unneccessary forms...
  5. J

    club membership data structure and relationships

    I'm working on a database I've inherited which has successfully worked for a local group belonging to a national organisation of Advanced Drivers. It is largely based on one table of member details, not attempting to record any detail of members' qualifications nor who held positions [and when]...
  6. J

    tables and relationships for members of a club database

    SORRY I didn't mean to post this as a sticky! Admin, please move, as I don't seem to be aable to delete it. (Embarrased!) I expect to take over a datavbse of 'club' members, actually a local group of a national association. This local 'club' has its own committee, with a chairperson, treasurer...
  7. J

    Hello Folks!

    I started using Access in the mid nineties, got heavily involved and even did some training of users, and developed a couple of fairly staightforward applications up until around 2003, then dropped working with it, as my life had moved on. [Sort-of! :) ] Now I may need to brush up on my...
Back
Top Bottom