Search results for query: *

i've checked out the links but still not to clear about some of the stuff. what i want to do is for the application to send out an email from a designated mailbox. however i don't want to assign rights to the mailbox, i was planning on putting the server info, server file info and the password...

one more thing. if i use the import wizard to import the file into the existing table it works fine, it's only when i use the transfertext method the error occurs. jeff

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

MP9, quick question sometimes after users log off the ldb is not updated and therefore is sometimes inaccurate, is there anyway around this. i used to do something similar to what you've done but i opened the file for random access instead of binary, does binary access solve this problem...

on the format event of the report try something like this Me.Controls("Name of Control").Left = 100 you can use any of the properties that you normally would be able to use for the control type( ie top, left, height, width). the unit used for the properties are in twips, so you...

thanks for the reply but it won't quite work for my setup. i want to incorporate the viewer into the administration module of the application, so apart from me parsing the ldb file i can't think of any other solutions. hmm i guess i'll play around it a bit more.

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

Ken, yeah i wrote a loop which basically updated the table x amount of times. not very efficient, but i couldn't think of a way to write a sql statement which would do the update. jeff

ken, thanks for the quick reply. that's why i figured too but i was hoping that it was something fixable. jeff

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

Zero, I'm having the same problems with my subforms and i've found that if i add a "sleep" function after the save and b4 the requery it "requeries" more often than not. I'm not sure if this is coincident or not though, so not sure if this will help you. also one thing i...

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

what kind of router are you using? i just finished helping my friend setup a similar network using a linksys router. All i had to do was set up the router as a dhcp server, and each of the clients "obtain ip automatically." hopefully this helps. jeff

i have a similar set up and here's a summary of what i do. first of all b/c there are many employees per site i suggest using a list box instead of a combo box. on the save event of the form i first delete all employees of the given site from the link table and then i loop the...

the specs information is saved in the MSysIMEXSpecs and MSysIMEXColumns system tables. If you goto tools --> options --> check the "Show System Objects" you'll be able to show the two tables. But i believe both tables are read-access only, so i don't think you can create the specs...

hey thanks for the reply. i've tried the "SELECT Field1,Field2 FROM tableName WITH OWNERACCESS OPTION" syntax with no luck. I looked at the security faq on the MS site and they say it's not possible with VBA to use the "WITH OWNERACCESS OPTION&quot...

i have a similar problem with access getting stuck on the task bar. i have multiple databases that i open from a common logon db. i've noticed that if i open another db, exit,and then exit the common logon db access instance gets stuck. the weird thing is that if i use a user that is part of...

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

i kept on pasting it into the actual text box, i didn't realize that you could paste it into the formula bar. thanks again. jeff