Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.09 seconds.

  1. Replies
    2
    Views
    85

    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...
  2. Replies
    24
    Views
    831

    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.
  3. Replies
    24
    Views
    831

    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...
  4. Replies
    3
    Views
    360

    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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. Replies
    4
    Views
    310

    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...
  10. Replies
    5
    Views
    248

    [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...
  11. Replies
    9
    Views
    633

    [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...
  12. 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...
  13. 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...
  14. 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...
  15. Replies
    3
    Views
    196

    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...
  16. Thread: Time dilemma

    by WendellB
    Replies
    2
    Views
    217

    It is possible to do what you suggest, but it...

    It is possible to do what you suggest, but it involves using some moderately complex VBA code to open a recordset that contains the records for talks in a specific symposium, using either DAO or ADO,...
  17. If you have a choice on SQL Server, I would go...

    If you have a choice on SQL Server, I would go with SQL Server 2014 Stamdard Edition (the current version), although for small databases (substantially less than 10 GBytes) the Express version should...
  18. Well, I've not had experience with the Amazon S3...

    Well, I've not had experience with the Amazon S3 and how it handles file locking and such, but at a local network level each user must have full read-write permissions on the back-end file as well as...
  19. Mark will probably chime in here too, but in his...

    Mark will probably chime in here too, but in his absence, we really only work in the Access front-end, SQL Server back-end environment. Allison Balter has an excellent book on the subject based on...
  20. Replies
    1
    Views
    223

    I don't know of any formatting that can be done...

    I don't know of any formatting that can be done on a list box other than the standard format properties associated with list boxes. It is possible that something in your video card, or your video...
  21. Is this a query that was done in Microsoft Access...

    Is this a query that was done in Microsoft Access and you are now trying to create the same query in Microsoft SQL Server in T-SQL? The reason I ask is that Access does not in general use the INNER...
  22. Replies
    3
    Views
    318

    To repair your Access 2013 installation, open...

    To repair your Access 2013 installation, open Control Panel, click Programs, and then click Programs and Features. That will list all of the programs installed on your PC. Find Microsoft Office...
  23. Replies
    2
    Views
    513

    So far we haven't made any adjustments, as most...

    So far we haven't made any adjustments, as most of the tablets or ultra-books have a resolution that will work with a design where we expect a resolution of something like 1024 by 768 pixels minimum....
  24. Replies
    3
    Views
    318

    Have you applied all the latest updates for...

    Have you applied all the latest updates for Office/Access 2013? If not, do that first. Then do a Compact and Repair on each database. As they are .mdb extension files, they are either in the 2000...
  25. Replies
    30
    Views
    1,815

    Thanks to all. I have managed to Capture Username...

    Thanks to all. I have managed to Capture Username and Time of Import through Update SQL. (Note that this could also be done by setting defaults for the 2 added fields.)

    Now I require help on the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4