Recent content by skiefer

Hi again - With the help of a post in the VB forum, I have created the following code to automatically launch word and run a mail merge. The problem is that I get an error message opening up the mdb database, stating that it's locked by another user. How do I force the mail merge to open in...

I know this post is a little old, but i've used it to setup a mail merge. I'm hoping someone can answer this question for me. When I try to run this mail merge I get an error opening up the data source from the word document because the database has a lock on it. The database will always be...

Hi ghudson, Thanks for the input on this. I have made your changes to my plan and all is working so far. Here's the tricky part though. I need to have the code check for a value in one of my screen textboxes and do the update accordingly. I have a checkbox that allows the user to enter a...

Hi all, I've spent lots of time over the past month developing a database that does exactly what I need it too, except for one problem which no one seems to be able to resolve. So ... i'm going to start from scratch and get some up-front advice on how to design this application. I need to...

new database new database w/ minor change.

Please Help!!! Isn't there anyone out there who can tell me why my form won't let me add more than 128 characters to my table field??? I'm about to scrap access altogether and find another database that will let me do what I want. I've spent hours getting this whole db to do exactly what I...

Ken, did you change anything? still doesn't work on this end... did it work for you? The only reason I'm trying to pass the field in is because I want the user to be able to press a button to save. It never seems right to me to have a record save without the user actually asking it to. I...

ok, here is my database stripped down to the bare minimum. You will see two buttons - one that uses as sql insert command and one that uses an append query. They both produce the same result.

Anyone got any ideas?? Anyone there?? Any ideas would be helpful. I've created a new db from scratch and am still getting the exact same problem. HELP!!!!!

nope - nothing like that. just doing the append with the syntax we discussed. you're right, this has got to be a silly no-brainer!! thanks for all the help.

Still Not Working!!! Hi all, Thanks (very much) to Ken, I have now converted my SQL insert to an append query, but unfortunately, I am still getting the same error message. The second I try to insert more than 128 characters (not 121 as I originally thought), I get an 'invalid argument'...

Here is my query, just as you said. Then the next image is the error. Also added [forms] in front, but same error.

AGHHHHH ... now it asks for me to "enter parameter vaue" for [labels]![title]. It doesn't want to take the info from the form. Do I have to put some VB code behind the 'submit' button?

Yes, the table i want to append to is also the source - only because normally when the user enters a new recipe/instructions, it usually looks very similar to others entered. They want to be able to pull up the previously entered record and edit it accordingly. Thank you for the info - i am...

what do you mean, you didn't realize this is where we were going ... Why don't you tell me the right way to do this (i'm a newbie if you hadn't already guessed). ALL i'm trying to do is take 5 fields from a form screen, that have been entered by a user, and put them into a table. Sometimes...