Search results

  1. I

    Filtering data to match requirements

    Hi If there is a reference tables for each listbox, do as follows qry1 = SELECT [Product type] FROM [Product type Table] qry2 = SELECT [ISIN] FROM [ISIN table] qry3 = SELECT [Counterparty code] FROM [Counterparty code table] qry4 = SELECT [Trader] FROM [Trader table] Then proceed as...
  2. I

    List Months Based on Start/ End date

    Hi r24igh A very simple way to obtain your list, create a table month with this structure: monthNumber as integer monthName as string Data 1 | january 2 | february 3 | april and so on then a SQL query as follows: SELECT month.* FROM [month] WHERE (((month.[monthNumber]) Between...
  3. I

    A couple of questions

    Sorry if I have initiated a sharp debate
  4. I

    Class modules?? for common operations

    Hi A little mistake replace mySetting with flag. I certify this code 100% free bugs Public Function VisibleOnOff(formName As String, controlName As String, flag As Boolean) Forms(formName).Form.Controls(controlName).Visible = flag End function
  5. I

    Class modules?? for common operations

    But It could be interesting for others community members :D
  6. I

    Class modules?? for common operations

    it is never too late :rolleyes:
  7. I

    Class modules?? for common operations

    Hi databasedonr An other way In a module Public Function VisibleOnOff(formName As String, controlName As String, flag As Boolean) Forms(formName).Form.Controls(controlName).Visible = mySetting End Function In a form you would write Private Sub cmdButtonVisible_Click() Call...
  8. I

    copy forms and modules from one database to another

    Hi Jaye7 I tested this code, it works : DoCmd.TransferDatabase acImport, "Microsoft Access", "D:\..\DataBaseSourceName.accdb", acForm, "ObjectNameSource", "ObjectNameTarget"To go further read msdn.microsoft.com/fr-fr/library/office/ff196455.aspx ;)
  9. I

    A couple of questions

    You are right NauticalGent Thanks
  10. I

    A couple of questions

    Hi Snak9r To help you, could you: Explain your functional needs, it means without considering technical database problems? If you have already developed something, post it too?
  11. I

    Setting up table structure

    Hi funk88 here is a free soft to model: jfreesoft.com/JMerise/ conceptual data model (CDM) Generate automatically ta Physical data model from the CDM And to go further with normalization a wiki topic herehttpshttps://en.wikipedia.org/wiki/Database_normalization#Normal_forms Good reading;)
  12. I

    Normalizing table

    Hi carlpoppa here is a free soft to model: jfreesoft.com/JMerise/ conceptual data model (CDM) Generate automatically ta Physical data model from the CDM And to go further with normalization a wiki topic herehttpshttps://en.wikipedia.org/wiki/Database_normalization#Normal_forms
  13. I

    a couple of newbie questions

    Hi merlin777 Read this wiki topic:httpshttps://en.wikipedia.org/wiki/Database_normalization#Normal_forms Good reading ;)
  14. I

    Quick data entry

    Hi nhood42 With a VBA program but what do you mean by "enter"? Add or update records? For adding records with the same date, call this code on click event button sDate ="#07/25/2016#" For i to 100 sqlINSERT = "INSERT INTO tableName ( field) VALUES (" & sDate & ")" DoCmd.RunSQL =...
  15. I

    Filtering data to match requirements

    Hi aark, Spontaneously, I'll create 4 queries, each of them based on transactions table. qry1 = 'SELECT [Product type] FROM [transactions table]' qry2 = 'SELECT [ISIN] FROM [transactions table]' qry3 = 'SELECT [Counterparty code] FROM [transactions table]' qry4 = 'SELECT [Trader] FROM...
View older results
Back
Top Bottom