I am getting the message "Could not delete from specified tables" when I try to run a simple delete query.
This query returns 1 row when I run it as a select query.
ANy ideas?
Confused about the lock file behavior. I noticed a lock file tonite when I was leaving the office. The users said they all closed out of the app. I looked at the lock file and my pc was the one in the file. I did not have the app open. When I got home, I checked the situation again, the lock...
We have a read-only version of a database that they give to certain people. The save btn as well as some other things have limited functionality.
Problem is now there are two versions to keep in sync.
How do any of you deal with a situation such as this.
And setting the property to read only is...
My user would like to tag their account records as a type 1 Or type 2 Or type 3. I originally set this up as an Option Group (with checkboxes) and stored the value "1" or "2" or "3" into a text field in the table. However, the fields on the form are checkboxes and this is causing some havoc with...
I have a user with a table of 210,000 rows. She exported it into EXCEL and received only 16,000 rows. I thought Excel would convert 64,000 at a time.
Should she copy from Access and paste into Excel????
Does she have to do it in increments????
A manager has requested that I password protect a report.
They don't want the other users to see it. Off the top of my head I am not sure how to accomplish this.
Is there a good way to do this.
Does anyone know if the new version will address compacting and repair. For instance, if you delete a table will the database automatically handle that bloat issue.
Any improvements on the corruption issues....
Thanks
It works on some computers and some it does not? One of the sites we work with have a testing room with 17 computers and all of a sudden this error comes up on one of our apps, but it works fine on other computers in the room and throughout the building. Any ideas?
I would like to load a directory containing all the excel files and have the user be able to select the appropriate file and click on it to open....
Is there an easy way to accomplish this? OR a sample piece of code to do this task.
Is there a way to create option check boxes without going thru the wizard. I have inherited an existing app where there is a series of check boxes BUT the user wants to be able to select only 1....Is there an easy way to do this.... The app is OOP, and its difficult to maintain.
I have been using Access to query our mainframe DB2 tables. This works pretty well, but we would like to know if IBM-DB2 has some kind of front-end for developing queries.
I am doing an evaluation of the benefits and issues with Infopath. It may be useful for our organization, I would like to hear how and what you like about it and what you dislike. Thanks
On my home machine I have Office Pro and use Outlook as my email client. Outlook has a feature when you begin a new email and type a letter in the "To" box, you get a list of everyone you have sent an email to that begins with that letter. How can I remove some of those names? I get the...
I was talking to a collegue the other day about a new pc i was thinking about. He recommended I get the hard drive as RAID 0, he says its really fast. Can someone explain the benefits and the negatives of having this in a home machine.
I am supporting an app where a section contains a series of check boxes...there are a series of 9 labels (1 to a row). After the label, there are 3 check boxes, the user can select more than one...How can I make it so they can select only one. Note...the code is object oriented and its very...
I noticed something strange with class files in my Access folders. If I change someting in one of the class files, all the class files dates become the same.
Its not like that with the forms, for instance, if you modify a form, only the modified date for that form is changed. On class files...
I have a report that I need to email on a daily basis,
I would like to use the DoCmd.SendObject .....
I know I did this in the past, but I don't have the code available or I forgot how to do the attachment part.
Anyone know ???
I have two loops, I want to save the place in the table being processed in the inner loop when control goes to the outer loop. And then when control passes to the inner loop again, I wish to move to the next record and process...
I am using regular DAO dynasets....How can this be done...
Thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.