Search:

Type: Posts; User: WendellB; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.20 seconds.

  1. Replies
    3
    Views
    408

    If no one has welcomed you to the Windows Secrets...

    If no one has welcomed you to the Windows Secrets Lounge, let me be the first to do so. I did take a quick look at your prior thread, and it seems you have undertaken an ambitious task for a...
  2. Replies
    3
    Views
    408

    Hi Kelly. I edited your message to put your VBA...

    Hi Kelly. I edited your message to put your VBA procedure into a code window so it's a bit easier to read and has indents, etc. You can do that by using [ code ] and [ /code ] tags without the...
  3. In 2002 (only older version I have up and working...

    In 2002 (only older version I have up and working at the moment), there were three options for Default Find/Replace Behavior: Fast Search, General Search, and Start of Field Search. Those same...
  4. Off the top of my head, it appearss to me that...

    Off the top of my head, it appearss to me that you are using the full recordset with the statement "set rsParent = Me.Recordset" where Me. refers to the form you are currently in. However I can't...
  5. I presume you are working with the .accdb format...

    I presume you are working with the .accdb format where you can attach various types of documents to a record, and that you are working with Access 2007/2010/2013. There are some issues with...
  6. Replies
    1
    Views
    136

    Welcome to the Windows Secrets Lounge and the...

    Welcome to the Windows Secrets Lounge and the Databases forum.

    There are at least a couple of ways of doing what you describe using Access and Excel, but both require some knowledge regarding the...
  7. Replies
    2
    Views
    368

    My personal opinion is that there is only minimal...

    My personal opinion is that there is only minimal danger is changing the sandbox mode in 2010. The security features that were introduced in 2007 and beyond were intended to make it less vulnerable...
  8. Replies
    2
    Views
    170

    Unless you want to jump through alot of hoops,...

    Unless you want to jump through alot of hoops, entering "Nov" as a criteria for the report is not the easiest way to do that. Dates are stored internally in Access as a number (actually with both...
  9. Replies
    5
    Views
    219

    I feared that might be the case - the lesson here...

    I feared that might be the case - the lesson here is painful, but make sure your development directory is backed up daily.
  10. Replies
    5
    Views
    219

    Unfortunately Kevin, when that happens it often...

    Unfortunately Kevin, when that happens it often means the VBA project is really gone. But there are some possibilities to check out. First, are you still using Access 2007, and do you have SP3 with...
  11. Replies
    3
    Views
    226

    What version of Access are you using (2000, 2003,...

    What version of Access are you using (2000, 2003, 2007, 2010...) and what file format are you using (.mdb, .adp, .accdb, etc.)? There is a setting in Access on the General group that specifies the...
  12. Replies
    25
    Views
    1,140

    Most recent versions of Windows (post XP) allow...

    Most recent versions of Windows (post XP) allow you to right-click on a file and choose Send To/Compressed Folder as an option which creates a zip file.
  13. Replies
    25
    Views
    1,140

    If you want to attach an Access database,...

    If you want to attach an Access database, compress it to a zip file, and you should be able to upload that. Before you do that be sure to compact and compress it if you have done any significant...
  14. Replies
    3
    Views
    460

    The error about the record not being updateable...

    The error about the record not being updateable is typically because Access thinks you don't have a primary key on the table when you are running an update against a single table. Is your table...
  15. It is possible to export all of those VBA windows...

    It is possible to export all of those VBA windows to text files, which is a common way of repairing VBA projects that are corrupted for some reason, or you can simply copy and paste the contents of...
  16. What is the end result going to be - a saved set...

    What is the end result going to be - a saved set of values in a table, a report, or a display on a form? It seems to me you should be able to do a GroupBy query that gives you the minimum year for...
  17. I would start by making a table (probably the one...

    I would start by making a table (probably the one you are using for new records entered using the form you mentioned), and then for each of the 3 tables, figure out where the data in those tables...
  18. Dave's suggestion for a tutorial on deploying a...

    Dave's suggestion for a tutorial on deploying a database to users is an excellent start, but doesn't help with the Access runtime installation and configuration. Here are a couple of suggestions for...
  19. Replies
    4
    Views
    422

    You've bumped into the hard part of database...

    You've bumped into the hard part of database design, and that is getting a sound table design in place. One question I have is whether a street number is unique across all of the Properties. For...
  20. Replies
    5
    Views
    350

    [SOLVED] It appears you have a referential integrity issue...

    It appears you have a referential integrity issue with your database design. If it was constructed properly, it would not have let you delete the records in tblAlllLocated until you deleted records...
  21. Replies
    9
    Views
    777

    [SOLVED] Actually, Access 2010 will happily run a .mdb...

    Actually, Access 2010 will happily run a .mdb database, and so will 2013. But 2003 will not be able to connect to a .accdb format database. As long as you keep using the .mdb format things will...
  22. OK, let's clarify things - in Access you have two...

    OK, let's clarify things - in Access you have two basic tools you can use to provide a user interface. They are Forms and Reports. User Forms are a Word/Excel construct, and quite different from...
  23. See this thread in the Office Dev Center forum:...

    See this thread in the Office Dev Center forum: https://social.msdn.microsoft.com/Forums/office/en-US/a470115f-4334-413d-b8cf-0f364296daae/datetime-picker-control-access-2007?forum=accessdev - the...
  24. There is an Access Method that will do that task....

    There is an Access Method that will do that task. Do a search for acFormatPDF, or simply go to http://msdn.microsoft.com/en-us/library/office/ff192065(v=office.15).aspx and you will find the nitty...
  25. Replies
    3
    Views
    257

    It seems to me it should be possible - using VBA,...

    It seems to me it should be possible - using VBA, I would do it on the OnFormat event for the report, and actually use DAO to cycle through the data source for the detail section to see if I find one...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4