Search results

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

ok, will stick with the append query. I'm just getting bogged down with the syntax ... If I could get just one field to work, I could add all the others. Here's what I have for the title field: INSERT INTO TBlabels ( title ) VALUES (" '& me.title&' "); i think i have to set the values of...

last i checked "chicken" was not a reserved word :-) Here is a piece of the form and database that is causing the problem. Please, any help on this would be greatly appreciated!! I tried to upload my zipped database, but I'm 5 KB too big - can't figure how to make it any smaller.

ya, I started with the append query, but I couldn't get the d*(& thing to work ... the syntax of taking the info from the form was killing me. But, as you suggest, I am back to working that route now. FYI, the text I'm trying to enter is as follows: Thaw in refrigerator overnight. Warm...

i guess if figured memo was better if I'd need more text. Anyway, changed it to memo, but still got the same error message

Here's my code to insert into the DB. Like I said, it works fine, up to 121 characters in the instructions field. Private Sub SaveLabel_Click() Dim i As Long For i = 1 To Forms!Labels!NumLabels DoCmd.RunSQL ("INSERT INTO labels (title, servings, instructions, PrepDate, client)VALUES...