Recent content by qwerty906

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