hi all, i got a problem that i need a solution to before the end of the week so any help is much appreciated. i'm working on a system that allows users to import csv files and then allow them to create dynamic mailmerge and excel files. originally i was using the docmd.transfertext method to...
just a quick question maybe one of you can answer. I'm trying to do a mail merge that takes in a dynamic SQL statement. If i use the following statement i can pull the data from a query
objWord.ActiveDocument.MailMerge.OpenDataSource Name:=strDBPath, LinkToSource:=True...
hi all,
just a quick question that maybe you ppl know the answer to. I'm using the MSLDBUSR.DLL as a way to monitor my AC97 database. however i can only see the machine name, i can't see the actual usernames. i've set up user-level security and if i view the ldb file with notepad i can see...
maybe somebody could shed some light on my problem. I'm trying to update a table based on values from a linked text file. however it's giving me an error message saying that "Updating data in a linked table is not supported by this ISAM" but the table i'm updating is a local Access...
hi all,
i've set up an A97 application using workgroup level security. however i'm encountering some weird problems. almost on a daily level i'm getting an error message saying "Couldn't use XXXXXX.mdw; file alreay in use", i think it's cuz one of the users has somehow locked the...
Hi all,
I know that this subject has been beat to death but i need some help here. First when you split the db into FE and BE do you do this after you secure the database? Do the permissions flow over after you split it. Cuz i split my db first and then set the permissions on both files...
hi all, does anyone know how to make dynamic chart titles using excel 97. i've set up a pivot table with a 'page' field. i then set up a pivot table chart which pulls from the above pivot table. what i want to is that each team i change the 'page' field the title on the chart gets updated as...
i was wondering if anybody could help me out here. i know it's possible to to open an access file within another access app. but if the 2 apps share the same workgroup file is it possible to skip the user logon process of the second access app? thanks in advance.
Hi i have a question regarding multiple database access using the user-level security. Currently i have 2 Access apps that use the same workgroup info file and share some tables. What i want to do is create a third Access app which is a single logon for the other 2 apps and put the shared...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.