Search results for query: *

As I have found out from MSDN, I cannot install any earlier version of MDAC on my Windows XP computer. I have whittled my references down so the only conflict I seem to have is msadox.dll (ADO ext 2.7 for DDL and Security), because I have version 2.7 and my users have 2.5 I have searched in...

I have a problem...(besides trying to program an Access DB when I am not a programmer and know nothing about programming): I have developed a database on my home computer, which has Access 2002 (I formatted the DB as an Access 2000 format), therefore, it referenced ADODB, ADOX, and ADOR version...

I don't know if any of the original posters are around, but I have a similar problem in that I went and created a database (my first database) in Access XP for a client with only Access 2000--I thought I was OK by using the default Access 2000 file format, but I only have the Object Library 10.0...

That was pretty much what I was afraid of (the front end not being able to access the network based on the credentials of the user). I don't know anything about setting up dsn's (data source name, right?) or if that is an option, but it is somthing I will make a note to consider. Thanks...

I am hoping to make an mde file from my frontend mdb file but the option is grayed out/not even available from the menu. I am using Access 2002 but the database is Access 2000 format--I found this from the msdn website... "Additionally, MDE and ADE files can only be created with Access...

I don't know anything about the specifics of the network I will be using, but I plan to put a split database onto our company's network for exclusive as opposed to shared use...it will be in a folder where I can ask for permissions to be set up so only the users have access to the folder...but I...

For some reason, I thought the shift key was a special key so I was worried I would loose access to that. I also was afraid if the users used the shift key that they would somehow be able to circumvent the security I set up (through the wizard) but in playing around with it, I see that's not...

I am getting ready to finish my first database that will be used my many users...I will continue to administer the database and I am wondering: Once I have created custom menus (where I will restrict users from customizing any menus/toolbars or any part of the design and security of the...

So simple, so helpful! Thanks very much LizardKingSchwing and CosmoKramer!

I have a report based on query and one of the fields in that query is in the General Data format. I want a way to filter the report or write a criteria for the report's query or something so that if a user enters a date in the MM/DD/YYYY format into an Open Event prompt that I have created, all...

Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you Thank you!!!!!

Thanks, I will try that. I tried to replace the error message in my table with something plain without any quotes(I thought this table was being used to derive the messages that are presented), but I didn't get my custom message back. I found this post that sounds similar to my problem--of...

I tried that and it didn't work. For example, I tried to click an 'Undo' command button and still got the #2046 error of The command or action 'Undo' isn't available now. Could it have something to do with the single quotes around Undo? (Probably a stupid question) When I ran some code to...

I have an error handler module with the code below that keeps breaking on the SQL statement in the LogError function with a runtime error of -2147217900(80040e14) Syntax Error (Missing Operator).... When I take out the ErrorString and str.Message portions of the code, I don't get the error. I...

I figured out how to pass the code from the listbox to a table and reference the table for the report and when it didn't work, for some reason, I realized that I had declared my listbox as a control instead of a listbox (I have a big DUMMY stamp on my forehead) and changing that made my crashes...

I know I don't have the terminology correct here, but by playing around, I have managed to get the data that I want to a report several different ways, using several different versions of SELECT statements as well as without, and I can do it successfully, the problem comes when I close that...

I tried that and it still crashes...I wouldn't be surprised if this code has tons of errors, as I am very new at Access and VB. Thanks for the suggestion, tgikristi

I think this article best describes my problem: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q295277 The article indicates "When you write SQL queries, avoid enclosing the items listed in the SELECT clause in parentheses." Could someone review this code to see if there is...

Hello, I have a multiselect listbox and a select query based on table that uses a Where statement to pass the selected items to a report. The query seems to be running correctly, but when the report opens, it lists enough lines for all the items in the listbox, but all the values appear as...

Thanks, I will try this right now--sorry I hadn't noticed a reply and just re-posted so I apologize to everyone for being so pesty! Thanks, tgikristi