Search results for query: *

Anyone know what could be causing this? Whenever i try to link tables via an ODBC data source, i get an error that says "The Visual Basic for Applications project in the database is corrupt." Access seems to function fine otherwise. Any ideas??

We are debating the pros and cons of giving users Admin rights on the desktop machines. I have been assigned to researching the benefits of doing this, and am coming up short, so i'm looking for experiences any of you have regarding this issue. Anything you can give will help greatly! Thanks...

How can i change the owner of a module if it doesnt let me change it if i am the admin user? It says <unknown> in the owner box, and it wont let me change it. It says i need to have administer rights on it to change the owner. Any ideas?

Is there a way to programatically change the field data type? I need to change a field data type from integer to single. Any ideas? Thanks.

How can i programatically check to see if a certain table has a specific field, and if it doesnt, add the field to the table? The field isnt going to have any relationships or indexes, so i'm hoping it will be simple. Thanks for any help. Aaron

Is there any way to Export an Access Report to Word and include the images on the report? -Aaron

Is it possible to use an Application.path type string to find linked tables? What my problem is, is if a user installs the application in a folder other than the default, i get an error because the linked tables arent in the path that it is looking for. Anyone have any idea? Thanks! Aaron

Does anyone know how to set the .gif graphics filter to work? It is installed on my machine, but Access is not using it to open a .gif image on my reports. I have office 2000 professional edition. Also, is it possible to package that .gif graphics filter with my application in the package and...

Is there a way that you can have other reports print when you select print on one report? Basically, i have one main report with a few other reports that i would like to have printed when the main report is printed, without having to select print for the other reports. Thanks! -Aaron

How can i get a number to increment by one in a query? All i need it to do is number each line number consecutively. Its so simple to do in the report, but i cant figure out how to get it to do the same thing on the form that displays the query info. Any ideas?? -Aaron

Is there an easy way to convert Access forms to Visual Basic forms? Anyone know? Aaron

How can i run a query with criteria that has an apostraphe in it? I cant change the data cause it is linked to other tables by this field. Is it possible?? Any ideas of how to get around this issue? Thanks. Aaron

Is it possible to have the user define a range of dates to search on for a crosstab query? I tried the usual [] for user parameters, and also tried to use values off of a form, and neither worked. Any ideas?? -Aaron

How can i get the autonumber to update before i close the form on a form that is prepopulated with data from another form? Basically i need the autonumber which is the ID of the report to update itself when the form is opened so that the subform data goes in correctly with the ID populated and...

Is there a way in Access 2000 either with an ActiveX control or something else, that i can pop up a window that will let the user pick a file on their system? I want to use this with some FTP functionality i am building. Any help would be great! Thanks. Aaron

How do you deal with currency types? I have a drop down that has the different currencies we might ever use, and i want the format of the Salary box to change depending on what the currecy is. So in other words, i want the field to show the corresponding symbol, and a numeric value after...

I am using the Outlook Contacts folder for contact data in my Access Application. The problem is that when i use the link table wizard in Access, it doesnt pull the same fields all the time on different computers with identical setups. I need the table to bring over the 4 user fields that are...

How do i stop the default Access error message for NotInList to stop popping up? I have a custom error message that displays when you try to enter a value not in the list, and the default Access error message saying &quot;The text you entered isn't an item in the list. Select an item from the...

Anyone know the code to programatically reload a form? If its for a subform, thats even better. Thanks! Aaron

What I am trying to figure out is how I can have a subform reload itself when a user clicks a button that is basically a record selector. So that when they click the button to go to a different record, the subform will reload with the data from that new record. My subform loads different...