Search results

thanks for the input!

My data entry clerk says she did not delete a record, but if I look at the 'Autonumber' field, a number is missing from the sequence of entries. And apparently Access will not allow me to edit the numbers to rectify the issue since it is an Autonumber field. Any solutions? I need the...

tHaNK goD aLIMIGHTY! Figured out that I was missing a Form_AfterUpdate() command, and it works. The world may now continue.

=( no responses forthcoming.

Sorry for the many personal add-on threads here... but just to be clear, it continues to work when I close the db (leaving access open) and reopen the db. But it does NOT work when I close access and reopen access. BTW.. can you tell I am desperate by the number of times I keep checking for...

Do I get an award for stumping everyone?

I did what was suggested in that posted thread (threadid=15442), but ... I do get a new image for each new record. but when I close the db and open again, I only get one image for all the records. I have to redo the steps to get it working again. But as soon as I close and reopen, it no...

hmm.. reading an interesting thread on this :threadid=15442 lemme see if it works.

I have spent most of the day reading the Help info on the WEb and in Access2002, to little avail. Simplistically speaking... I have created a db of contacts, and to add each contact, there is a form. I want to be able to store the contacts' image file somewhere outside the db, but add to the...

How do I prevent users from copying the db file??? I've read it is impossible. Is this true????

when i do this for a simlar scenario, i get a message that says "you didn't specify search criteria with a findrecord action" any ideas?

how do i select a number of items from a list box to be entered into the same field? for example, when i have a list of languages, say, english, french, german.... then i want to be able to select more than one of these so that the field data eventuallys says english, german. is this even...

problem fixed. it was related to my other post, and Pat's suggestion.

Thanks Pat! I just imported my tables, forms, queries, etc... into a new db, and it worked....it reset the Access functions back to what they were supposed to be. My scalp thanks you too (no more pulling my hair out!!!...for now)

Is the CONTROL the same thins as the NAME or CONTROL SOURCE? I used those names to substitute FieldName, but still get the Automation error. Geez, I am realy starting to get frustrated with Access @#!$! But thanks to all the supporters. This is like a "support" group for those with Accessenitus.

wh00t, not true in my case. see fizio's comment...i tried that already, still get the #Name error

When I try to rename the FieldName in the code provided to me by the previous post, I get an Automation Error. Any ideas? I tried to type in the field name, and also select it from the drop down box. Any help is appreciated!!! Thanks

Is there a way to show a field in a form, only if there is data for that field? For example, if the field is blank, can I omit viewing it in the form???? I know I could use a query to omit that record from the recordset, but I may still want to show that record, but just not that field in the...

anyone give more advice on this issue? tried the advice before, to no avail. i just want to display the current date on the form, so that it is date stamped when printed. this should be a very very easy thing to do you would think, but it seems so complicated?!? why doesn't the insert, date...

I have a form that I want to datestamp. I have tried both the expression builder, and used Insert, Date and Time from the menu. Neither work, and both result in a #Name? error. I am so confused, cause when I try these methhods on the MS sample db's, they do work. ANY IDEAS WHY MY DB IS SO...