Search results

  1. G

    Access 2010 demo on MSDN channel9 you can share your experience and comments there.
  2. G

    Question Enable all macros

    Good day! I have created my project and on my startup form are functions that will be executed. However, these functions are disabled by default especially on the first run of access on the new computer. So if I am going to install the project on another computer on which I have not yet setup...
  3. G

    what is the subform in vb6

    I am studying vb6 and I dont know what is the subform object in vb6. Is it the msflexgrid? If access have subform and it works with main form by establishing master/child fields, what is for vb6 and how can we establish relationship with its main form?
  4. G

    printing receipt

    I would like to ask for help. I would like to print a receipt however, the printing will continue regardless how long the paper is. the receipt print the items sold and the amount. it is probable that it will consume more than the length of the short , A4 or long bond paper size. I am using...
  5. G

    Question Change the face of Office Button and current project Icon

    I have seen thru googling that they have managed to change the picture of the office button. but its was not vba because it was not under access forum or access topic. but I think it can be done. I have attached picture of the changed office button. Is there a way to change the Icon of the...
  6. G

    Discussion For RIBBON

    Hi good day! I would like to suggest to make a separate discussion for RIBBON. Because I think, ribbon is also a large topic, and what I think is like an object like tables, query, form and others. though it maybe possible to place the ribbon topic inside the general section, I just think...
  7. G

    Question Is service pack really cumulative?

    I have access 2007 and I have updated for SP2 knowing that SP2 includes the SP1. Question: Are Service packs and hotfix cumulative? Situation: I have setup my "Display Navigation Pane" to false so that it is not displayed. However when I run my docmd.transferdatabase statement, the...
  8. G

    gotonext record create runtime error '13' (type mismatch)

    when I click the next button it state runtime error '13' type mismatch. I dont know what part of the code is wrong. previously it worked ! please help. Private Sub next_Click() Dim rec As Recordset Set rec = Me.RecordsetClone 'Move recordset to current form record rec.Bookmark = Me.Bookmark...
  9. G

    Question where can I get the complete list of Ribbon idMso

    Good day! I have been searching the internet where to find the complete list of idMso for Ribbon in Access but not successful. Can someone direct me where I can find that list? example is command idMso.
  10. G

    Question QuickAccessToolbarCustomization

    <command idMso="QuickAccessToolbarCustomization" enabled="false"/> does the above code should disable the Customize Access Quick Toolbar? its not working in my code. has anyone tried this and working? can I also ask how to hide the " Recent Documents " in Office Button ? i have read article...
  11. G

    Question What's inside Access 2007 runtime?

    Can I ask what components or files inside Access 2007 runtime installer? Where are those components installed? What components or files are being registered into the computer?
  12. G

    VBA code to stop manual open of table objects

    quoting and posting here
  13. G

    Disable close button in access 2007

    I would like to quote and post this here:
  14. G

    Question To Create or Not to Create multiple backends

    while a single access database file has a size limitation of 2 gigabyte, I have been given two options in my previous post and those are: a. upsize to sql server or b. you can always create multiple backends. And so since I am not yet familiar with nor have backgrounds nor have learned about...
  15. G

    How to programmatically change the shortdate format in the regional settings

    How to programmatically change the shortdate format in the regional settings. Purpose: I want to alter the existing shortdate format of the computer to mm/dd/yy for the program use. If the existing format is not or is in the mm/dd/yy already, change it to mm/dd/yy format. Kindly help.
  16. G

    Question thread tool

    isnt there a thread tool in this forum such as "SOLVED" to indicate the post as Solved?
  17. G

    How to append query without error

    I have been using this code below in a query and it works just fine. however when I use this on module level the above code does not work. it says syntax error. so I modified it below in the module.. still syntax error on From Clause; any other way to revise the code to make it work? I need...
  18. G

    How to delete linked tables programmatically

    I have this database and it has local and linked tables. what I want to do is to decipher thru vba what table types are " linked " and by that criteria, loop thru those objects and delete them.
  19. G

    Question filter search of table objects

    Private Sub Command0_Click() Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentData ' Check each object of the AllTables collection For Each obj In dbs.AllTables ' When you find a table, display its name MsgBox obj.Name Next obj End Sub...
  20. G

    Dont know how "Do while" works

    Good day to all, I have this attached picture "paths.jpg" the purpose of this paths is for easy linking procedure. the form is a countinous form which has only three fields: pathnameid,pathname,pathlocation And I have this code: '------------------------------------------------- Private...
Top Bottom