Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bob44TheCat

    Identify when data was entered in Excel

    Hi Neil, Is Review > Track Changes what you're looking for? Regards, Bob.
  2. Bob44TheCat

    Access Security

    lidias13, Also, have a read of this: http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf and this: http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp Hope this helps, Bob.
  3. Bob44TheCat

    PopUp/Modal Yes: want to minimize application, but leave form open

    How about just selecting the other application they need by using the Alt+Tab keys? From the other app, they should be able to select Access again from the taskbar, and be back where they started. Hope this helps, Bob.
  4. Bob44TheCat

    MDB file security

    Hi - Re - "When some users try to open it they don't get asked username/password - Some of them get it few don't." When you create a user account it defaults to a 'blank' password - you need to log on to the database as that user, go to Tools > Security > User and Group Accounts > Change...
  5. Bob44TheCat

    Auto FE Updater

    Hi, Did you use the Database Utilities/Database Splitter? When I've split db's I use the manual approach - join to the relevant workgroup file, create a new Backend, import the tables from the unsplit db, delete the tables from the original (which is now the Frontend) and create links to the...
  6. Bob44TheCat

    Auto FE Updater

    Hi, I can't help on the Auto FE uploader, but one question comes to mind - and apologies if this seems obvious, but I know from bitter experience how easy it is to miss the seemingly obvious :-) Was your new (replacement) FE db created while you were joined to the...
  7. Bob44TheCat

    Divide a lot of cell data in Excel

    Gavin, Shouldn't that be Edit, Paste Special, Divide? Cheers, Bob.
  8. Bob44TheCat

    How can I automate an Append Query?

    Just a couple of thoughts: What is the recordsource of your Main Form - I'd guess it's your original table (622 records) and not the linked table? Also, do you actually need to have a separate table in your database, or could you just use the linked table? (Advantage - no need to run update or...
  9. Bob44TheCat

    Security - User Login Box If Used On A Network Drive

    Hi Pete, Not sure how much you have done so far from your post, or which version you're on (though the principles are pretty much the same across most versions, there are some differences), to start I'd recommend reading http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf and...
  10. Bob44TheCat

    Input Currency values being changed by ACCESS

    Hi JP, Not sure what this means, but had you noticed that the difference between each of the three examples you gave is 26.21? Presumably you're entering data into a form - is there some sort of calculation going on? Hope this helps, Bob.
  11. Bob44TheCat

    creating permissions

    Hi, Without knowing exactly what you did when you were first "playing around a little bit" it's hard to say. First off, you can find which workgroup you're joined to by running the Workgroup Administrator (C:\Program Files\Microsoft Office\Office\1033\WRKGADM.EXE in Win 2K)- as a default, you...
  12. Bob44TheCat

    creating permissions

    Hi Jimrawr, No easy answer to this, it sounds like you've set up a new workgroup and your database is joined to that on your PC only. Best thing is to read through these to get an understanding of Access security - and good luck! http://www.geocities.com/jacksonmacd/AJMAccessSecurity.pdf...
  13. Bob44TheCat

    i or I in Word!

    Hi Francois Try: Tools>AutoCorrect and uncheck 'Replace text as you type'. Hope this helps, Bob.
  14. Bob44TheCat

    parameter query results not expected with lookup field

    Hi, You could also have a look at http://www.fontstuff.com/access/acctut08.htm Hope this helps, Bob.
  15. Bob44TheCat

    User cannot log onto the Access database. User-level security issue

    Hi Maupiti, Does the group "Update Data Users" have Open/Run permission to the 'Database' Object Type on the BackEnd? Bob.
  16. Bob44TheCat

    How to find records in one spreadsheet but NOT in a second spreadsheet

    Les, Have a look at the VLookup Function in Excel. Lookup the records on the smaller spreadsheet from the bigger one, where there's no match you'll get a value of #N/A. Copy and Paste Special>Values the results of the lookup, sort by that column, and you'll have all the unmatched records...
  17. Bob44TheCat

    Access parameter query using wildcards

    Errr, Skip - I hate to ask, but: Am I missing something? I'm assuming FILE_NAME is a field in an Access table, and Menace is using a bog-standard, out-of-the-box Access parameter query to search for records using a partial filename plus a wildcard (actually that should have been wildcards...
  18. Bob44TheCat

    Access parameter query using wildcards

    ...done better to post this in the Access Queries forum but, as it's here - in the Criteria put Like [Enter full Filename or partial Filename plus *] The bit in the square brackets is the prompt that the user actually sees, so you can phrase it however you want. You might also need to do a bit...
  19. Bob44TheCat

    Security issue

    Hi Associates, As I said, this is a complex area - I had to read the documentation several times before I felt comfortable with it - but a few pointers to get you on the right lines... 1. If the database is going to be shared, I strongly suggest you look at splitting it into Front-end (which...
  20. Bob44TheCat

    Security issue

    Hi Associates, Briefly, the Database Password is one password for all users of a database. It is very basic, and does not give user-level security. Most people would not bother with it. If you have set up security using the user-level security wizard, you are on the right track. However, this...

Part and Inventory Search

Back
Top