Search results

  1. Robert88

    BE/FE Security *Important*

    Hi razaqad, What server are you running, I have looked after Windows NT Server, Windows 2000 and now Windows Server 2003. A lot of changes were made between Windows NT and the reminder, as microsoft introduced Active Directory, which is where all groups are created. I would have to set-up a...
  2. Robert88

    Delete a Database

    Hi MarionD, I do not understand why you want to do this through code if it is a one of, I would just go to the folder and hit delete, or am I missing something here?:rolleyes: Robert88
  3. Robert88

    table design and relationships...

    Checked the Microsoft Site? Hi snowman, Have you checked the Microsoft site? There is an orders management database on the microsoft site, maybe that will give you some good ideas? http://office.microsoft.com/en-us/templates/TC010185481033.aspx Goo dLuck with it.:D Robert88
  4. Robert88

    Tearing my hair out - Security for end/back end database

    Secure a Database............. Hi All, There is some pretty interesting reading here The 10 security steps summarized http://www.ltcomputerdesigns.com/The10Steps.htm Access 2002/2003 Security Step by Step http://www.jmwild.com/security02.htm Good reading:D . Robert88
  5. Robert88

    Count different

    Hi accessman2, If the table is in order from 1, 2, ....... then why don't you try using DLast() Function which will give you the result. If not then place it in a query in ascending order and then use the DLast in order to get the last records in order. Is this the result you are after?:p...
  6. Robert88

    BE/FE Security *Important*

    Hi razaqad, NTFS allows for the following file permissions; Read Write Read & Execute Modify Full Control If you remove Full Control and Modify permissions from the file the remaining permissions (Read, Write and Read & Execute) should allow users to use it and not delete it. The same...
  7. Robert88

    Delete a Database

    Hi MarionD, How often are you deleting this file? Robert88
  8. Robert88

    Create the link

    Hi accessman2, Not sure if I am correct here but what happens if you try .HTMLBody = "<A HREF='C:\Microsoft Office XP\Office10\MSACCESS.EXE' C:\db1.mdb >Open database</A>" Let me know. Robert88
  9. Robert88

    Which employee has the record?

    Hi Banaticus, try this connection http://www.access-programmers.co.uk/forums/showthread.php?t=101435 I hope it helps. Robert88
  10. Robert88

    Printing Report

    Hi IanT, I am only thinking out a loud here. Option1 I would explore possibly the avenue of setting up on a print server a shared printer with double sided set as its default so instead of encoding within your application. Then direct the application to the new shared printer set with...
  11. Robert88

    Anyone willing to provide some "replication code for dummies" assisatnce?

    Hi Scott, Check this article http://download.microsoft.com/download/access2000/whitepap/1.0/win98me/en-us/replfaq2k.exe Hope it helps. There is also some good references on the lower part of this response which is where I got the reference above from...
  12. Robert88

    Access Overview for Programmers

    Hi rbarlow, I quickly searched the forum for "book reference" and found the following; http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51192 and; http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=172177#post172177 They have some interesting...
  13. Robert88

    run time error 2465

    Hi stevie1969, When you have a space in your field names enclose it with parenthises. Eg, partner road becomes [partner road], so your code below would read me.[partner road] I hope this helps. Robert88
  14. Robert88

    updating records in a form

    Hi stevie1969, When you have a space in your field names enclose it with parenthises. Eg, partner road becomes [partner road], so your code below would read me.[partner road] I hope this helps. Robert88
  15. Robert88

    Reading dat file from CD

    Thank you Hi GHudson, Thanks for your code, sensational. You make everything so easy!!! :p So I suppose the code below is my long winded method of doing it, I should of checked for your response earlier. I did not end up using the import as I found something new called "Text Streaming". I...
  16. Robert88

    Reading dat file from CD

    Hi All, Another challenge to my life, reading a dat file from CD. I have looked at other posts on reading .dat files and it is clear that to import a dat file is not possible through the import of files.:eek: I have a standard file which for the purpose of the exercise I will call test.dat...
  17. Robert88

    How to speed up/improve performance for international DB users

    Hi Scott Braemer , How to improve the performance within the LAN. Split the database, keep the data (back-end) on the server and the application (front-end) on the local client. How to improve performance over WAN (or between your international sites). With your application split (usually...
  18. Robert88

    Changing table data via forms

    Hi JasonKiebler, I have recently taken data from a form to a table on unbound text boxes, check; http://www.access-programmers.co.uk/forums/showthread.php?t=102707&highlight=robert88 But as suggested to me and I am starting to agree is to use bound text boxes so that the form text boxes look...
  19. Robert88

    Updating Combo box defaults with Optionbox and/or Check box for a Table

    Here are details of one form in the attached zip above as maybe my explaination is not clear? frmDefaultCDDVDLabelling Media Type Option Group values on the form OptionCD = 1 OptionDVD = 2 Label Number Check box values Check_1 = 1 Check_2 = 2 Check_3 = 3 Check_4 = 4 Check_5 = 5 Check_6 = 6...
  20. Robert88

    Transferring form data to table?

    Thank you........ Hi Ashfaque and Pat Hartman, Thank you very much, appreciate it.:D This site is so helpful, couldn't meet a lovlier bunch of people to help support my Access addiction/craving......... :p Robert88:)
Back
Top Bottom