Search results for query: *

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

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

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

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

I am hoping someone can help. See thread181-350699 for the whole post, but basically, I am trying to use an AutoExec function to make sure that a user in a secured database has a password when they log on, but the function won't work unless the user trying to log on is in the Admins group. It...

I have an Access 2000 db that I have secured with various groups and users and I am trying to run some AutoExec code straight from the Access Desktop Development book to make sure a user has a password, but unless I login as Admins, I get error 3251 at the Set usr = cat.Users(CurrentUser) line...

I have found numerous examples, both in books and online, of using callback functions to populate a listbox, but all the examples I have come across (that I understand) are for ONE column listboxes...I am VERY stumped (expecially by the acLBInitialize part) how to make this function work for a 2...

I found a way to print a list of the users and groups in a secured database manually from the MSDN website/Access Help (Tools menu, Security, User And Group Accounts, click Print Users And Groups), but I am wondering if the same can be accomplished using code? Sorry for my ignorance. Also, is...

I have several forms with this problem...when a Save command button using code below is clicked, my other command buttons (which close the form or add a new record) won't work. I don't get an error message or anything, unless I click on Save again, and then I am told that Save is unavailable...

When opening a form using DoCmd I am using the OpenArgs statement already to pass data from multiple controls, but I don't want the opened form to refer to the openargs statement unless that form has been opened from a certain other form (because it could stand alone under different...

I have about 9 fields on a form that I want to check to make sure they aren't null when a user hits a 'save record' button, and suspend the save action until all the fields have data... I have individual "If IsNull(Field) = True Then send error to user and redirect error to field" for...