Search results for query: *

I have started to migrate users from NT4 to Active Directory/WK3 Server. When a user under NT has an Access app open (creating a lock file), and, as a Active Directory user, I also try to open the app - NOTHING HAPPENS! But when I open access, and point to the app through file open, it works...

What is the VBA code to run the Export cmd from the File menu when i have a report on the screen (can I do it all at once?)? I need to loop through a form, calling each line to export that report saved as snapshot file on the network (or word) open form x, start at top loop.. open report...

What's the simplest way to call the MS XP OS to get the User Name or their group into my Access2002 App?

I am using an old MSPress Access97 ref book. Can anyone suggest a newer reference book for Access/VBA Application development? (especially the newer stuff like Web Pages linked to the Access Database)

I have a form that displays a record, and it has a "clear" button on it. When the "clear" button is pressed, I wish to secretly copy the entire record to an identically structured database (using VBA), and then clear most fields displayed on the from to null. ie. Everytime the clear button is...

I have a Detail section that I would like to alternate the background color when it is formated. (from gray to white so that this is used instead of putting a line between each detail) Can anyone suggest how to do VBA on the OnFormat section of the Detail. ie: Detail.BackColor = grey I would...

Help! Is there something simple to do this. If I have a qry like this... ID# Time 6 X 6 Y 6 z 7 g 7 b 8 e how can I run a query/vba to get it grouped for my ID# so that it looks like this... ID# Times 6 x,y,z 7 g,b 8 e I am...

Need a little help remembering. I need to copy, rename and delete files in a folder on the network, from within Access using VBA linked to a button. I can't get the shell command to work! Can someone please provide a example of the syntax. Thanks in advance.

Easy question, but I can find it in the help files. I want to get the userID name retrieved from the network login. Is it something like??? Dim strUserIs as String strUserIs = Environ("UserID") Thanks in advance!

I want to open a form, Goto the first record, loop to the last record and collect up info from a string field. I want to use something like.... if (at least one record) then !need code here! DoCmd.GotoRecord First string_now_is = string_now_is & someField while (not eof)...

I would like to put a button on a form. When selected by the user, it would run a query of the database, adding values and arriving at a total. Then I want to assign the arrived at total to a variable on the form. Is there VBA to do this that I can put under the On_click of my button?? ex...

Need a little help with VBA. I need to rename a file from x.lst to x.txt . I then have an import macro that works great with the x.txt file. After that I want to move the x.txt file into my "done" directory and rename it to y.txt. What would be the VBA code for this??? Can the rename and...

I have a Windows NT 4.0 network. When I create a new account and have the tick-box on asking the user to change password after first login.... they are asked to do this, but then the system says they do not have permissions to change password. Where do I find the "Everyone" group and add a...

I made all my programs in Access2000, and all my users just go new WindowsXP machines with OfficeXP. My users have said that the margins on the reports seem to go to default of 1 inch all around and paper size/landscape portrait don't stay around either. Has anyone heard of this problem...

I have an old FoxPro app (1998?) and do not know what version it is. I do not have FoxPro and need to get the tables into Access2000. Access seems to bring them in fine except for the *.dbf tables with memos (*.fpt files?) Is there some shareware out there that can help me get everything into...

I have an old FoxPro app (1998?) and do not know what version it is. I do not have FoxPro and need to get the tables into Access2000. Access seems to bring them in fine except for the *.dbf tables with memos (*.ftp files?) Is there some shareware out there that can help me get everything into...

When my Access2000 database opens, I want to create access to some tables that are not previously linked to the Program. (trying to hide background tables as much as possible from end users, so they cannot open a table from the tables tab of the database window). When a specific form is...

Can you compile Access2000 into an executable that does not require a computer to have Access on it inorder to run the app?

I need to complete block out access to the back-end of Access2000 (Database WIndow,F11,etc) so that users can only use what I give them. Is there an easy way to do this??

I have an Access query data source merging with a 5 page word document (employee evaluation). I NEED to save each of the merged results as their own word doc so that it can be e-mailed out to the supervisors!!! (perferable named as each employees names to be evaluated). Does anyone know any...