Search results

  1. A

    Prompt a windows alert to all User who using the same Database file

    Have you considered having the program send an e-mail to the supervisor? That way they don't need to keep the program open. I seem to remember seeing an option for automatically collecting answers via e-mail but I have not explored that possibility.
  2. A

    Advice on Cascade Delete not being enforced between tables

    Cascade deletes are quite dangerous. If you only have those two tables it might not matter much but when you add the next table, things will also disappear from there or they will stop working. I have no idea why this is occurring but I would recommend that you re-think the reason for having...
  3. A

    Displying progress?

    I have used the technique from here http://www.granite.ab.ca/access/progressbar.htm It relies on vba but you can probably use it from a macro as well with some modifications.
  4. A

    Bulk Emailing a report using email addresses contained in a table

    This is how I am sending with an excel file. It can be used for a single e-mail or called for each of the e-mails you wish to send. There is a small loop that enables it to go through a query and add all the receipients from a pre-defined list. You can use the same technique as it scales with...
  5. A

    Bulk Emailing a report using email addresses contained in a table

    You nearly gave the answer yourself. Since you have a subreport able to generate a specific page on you main report, you should be able to have the subreport generate the page you want by providing it with the required ID. This you should be able to get from the table where you also store the...
  6. A

    Import a Excel file to a table

    Jass7869 the method CJ_London refers top is able to import a spreadsheet into a table in your database. From that import table you can do your checks and transform it into something that fits your existing table. From a user perspective it will just be a button but there needs to be a whole lot...
  7. A

    Using a web API to load data

    So I have been playing around with this challenge for a while now. There appears to be two important things in play. In one area you need to look at childnodes to get your data read correctly. In the other area you need to look at the attribute of the childnodes. This is the method I ended up...
  8. A

    Parsing strings of text between xml tag identifiers

    I am not sure you can use it but access has an xml parser built in. It requires the right reference to be activated but once done it works fine. What you are looking for has to do with either childnodes or attribute value if I remember correctly. I don't have any examples as I am struggling to...
  9. A

    Temporary tables, pros and cons

    I tend to use a permanent temporary table instead of creating and deleting it all the time. Once I finish with the table I wipe the data so its ready for the next time. For me it is easier than creating and deleting and as far as I understand it is faster as well.
  10. A

    Using a web API to load data

    This is nice. After activating the reference for active x I just needed to change two lines to make it work: Dim XMLHttpRequest As XMLHTTP Set XMLHttpRequest = New MSXML2.XMLHTTP was replaced by Dim XMLHttpRequest As Object Set XMLHttpRequest = CreateObject("MSXML2.XMLHTTP")
  11. A

    Using a web API to load data

    thanks for the reference spikepl I think I can see how it was done. I will need to try it out tonight and see how it works.
  12. A

    Using a web API to load data

    I have been dabbling in excel to get data from an online database however I would like it to come straight into access instead of coming through excel. In excel it is quite easy using a web query however I have not been able to find anything that can do the same in access. Is it even possible...
  13. A

    Starbucks is reviewing strict rule for no visible tatoos

    good morning: how can i help you? that could be a reason.
  14. A

    Extract data from word documents into Access

    Have a look at this article: http://www.techrepublic.com/blog/how-do-i/how-do-i-transfer-data-from-a-word-form-to-an-access-database/
  15. A

    Extract data from word documents into Access

    Have you tried something like this: Dim oCell As Cell With ActiveDocument.Tables(x) For Each oCell In oTbl.Range.Cells With oCell 'do stuff End With Next oCell End With I have not tested the code but as long as you replace the x it should do...
  16. A

    Extract data from word documents into Access

    This one has me stumped at the moment. Of course you nee the information in that table otherwise you would not have received the error but since it appears to be a one time job, consider that time spent on making the code to transfer the data vs. the time needed to enter it manually. One thing...
  17. A

    Extract data from word documents into Access

    The easiest would of course be to unmerge the cells. Is the layout fixed or can you make changes?
  18. A

    Extract data from word documents into Access

    One option is to use the form fields throughout instead of only for checkboxes. There is also a text variety you can use. It is possible to use VBA to extract the contents of form fields and load it into a table for further processing. Since each form field is individually named, their position...
  19. A

    Text as Primary Key vs Auto Number

    We are having the same type of discussion in Denmark. For many years this number was considered a secret but in reality it was extremely easy to find out what the number was if you had a little information about the person. As of today, it is possible to buy stuff and borrow money if you just...
  20. A

    Question How to send a single email message to all the email addresses in my query?

    A word of warning. Sometimes it is not your system deciding this but rather some server between you and the receivers. Some are set to automatically flag the sender as a spammer and within a day you could end up being banned completely as they exchange this kind of information. Based on...
Back
Top Bottom