Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.12 seconds.

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. Replies
    4
    Views
    185

    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...
  6. Replies
    5
    Views
    156

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

    [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...
  8. 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...
  9. 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...
  10. 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...
  11. Replies
    3
    Views
    139

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

    by WendellB
    Replies
    2
    Views
    158

    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,...
  13. 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...
  14. 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...
  15. 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...
  16. Replies
    1
    Views
    176

    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...
  17. 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...
  18. Replies
    3
    Views
    293

    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...
  19. Replies
    2
    Views
    485

    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....
  20. Replies
    3
    Views
    293

    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...
  21. Replies
    30
    Views
    1,630

    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...
  22. Replies
    4
    Views
    314

    Indexing has to do with the design of tables, and...

    Indexing has to do with the design of tables, and it provides a quick way to find records in one table that link to a specific record in another table. It is a property that you set for a field in...
  23. Replies
    4
    Views
    314

    Does each workstation have it's own copy of the...

    Does each workstation have it's own copy of the front end? If not, that could be an issue. But more than likely the issue is with the data source for the subform and the form. Have you checked to...
  24. Lots of others are debating those same issues,...

    Lots of others are debating those same issues, and it seems there isn't much consensus. In fact there doesn't seem to be much guidance either. I don't have personal experience, but did work with...
  25. Is your form constructed so that the...

    Is your form constructed so that the [Contact_Last_Name] text box is always entered before the [Relationship_to_Applicant] combo box is chosen? If so you could use a VBA procedure on the combo box...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4