Search results for query: *

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

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.

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.

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...

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...

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...

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

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...

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...

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.

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...

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...

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

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

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

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...

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...

...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...

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...

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...