Search results for query: *

in my database there are some macros that run 15 queries or so. we recently upgraded to acc2000 and had to do all the conversions. it went well thankfully. the problem is that each time a macro or query or anything for that matter is run or opened a sepearte box in the toolbar at the bottom of...

howdy friends, with my internship coming to an end it is fitting i need the forum for one last piece of help. We have created a database and placed in on the network dive to allow multiple users within the group to have access to it. there is a security issue because we only want 1 person at...

hello all i am trying to add a watermark picture to a form on accees. the current background is a solid color and i was wondering if i could have a picture imposed there instead. anyone ever heard of something like this? its essentially a background imade instead of a color, thanks a lot. Ed

i am having a problem witht he autonumber feature in access2000. i had a DB created in 97 that imported an xls file. the first column of that xls file would be left blank. on import access would asign that blank field an autonumber. thus it was also our primary key (not really relevant though)...

sorry for the lack of info, wil try a lot harder to give as many details as i can type. here goes. we have a database that is used with excel to enter in reports for our departmental needs. there was a lot of integration between excel and access when it was created. however, it was created in...

sorry for the lack of info, wil try a lot harder to give as many details as i can type. here goes. we have a database that is used with excel to enter in reports for our departmental needs. there was a lot of integration between excel and access when it was created. however, it was created in...

Hello I have a DB created in office 97 and we would like all of the users to be able to upgrade to access 2000 soon. somoe of the users have upgraded to 2000 but a problem exists with the modules created in the 97 version. i know i need to edit it to make it readable for access 2000 but i do not...

Ben changing the DOA stuff is only applicable if i have modules correct? do i have to worry about anything besides checking the refernce library in 2000 for dao3.6???

some of you might have read a previou post regarding this issue. management has changed its ideas though. We have decided to upgrade everyone here to Access2000. my question now is how to convert my acc97 DB so that i wont lose it in the upgrade. should i install both on my comp at first? or...

I created an acc97 DB for a network here at work. however some of the network users have acc2000 installed and not 97. thus we have a problem since the two arent compatible, or so i've heard. since we are all sharing the same DB i was thinking i could convert the current access DB to Acc2000 by...

after completeing my DB i have just learned that access 97 is not compatible with access 2000. what crap. i created my DB on a network using off97, but the users who have 2000 installed on their computer can't use my DB. anyone have any suggestions to fix this problem? is their an update patch...

I have the following code. it should display a message box asking whether formatting has taken place? if it has then it should run a macro in an xls file. this occurs with amodule in access. Sub IsFormated() Dim Answer As Integer Answer = MsgBox("Is the file formated ?", vbYesNo...

i am running a db that works off a switchboard. one of the buttons allows for the importation of a file. however, this file needs to be formatted first. I would like a msgbox to appear that would ask the use rif they have formatted the file already. if not they could stop the macro form...

hello all i am sure this is a simple question. i have a table that gets its data impported daily. as a result some of the data is often repeated. i have a query that finds all unique values within that table. i would like to take the results of my query and use them to create a cleaner tbale. i...

Sorry joe but im not clear on how they are doing it. what i did was added a column with my existing query and then in the criteria row i entered =sum(credit), i figure there has to be more to it than this because it won't work. thanks

The form has a button that runs a macro which in turn is running the query. the data is presented tot he user in a data sheet view. So i take it the sub query should be used. just how would i go about doing that? thanks

hello all, I have developed a DB that imports and excel file of financial data, which will occur daily. i then have a query that finds the unique entries in the DB. the user is able to go to a form and select the account # the wish to view. all unique transactions then appear based on the...

Thanks everyone for your help. Dale you're right extracting to another sheet won't work, all i did was create a 2nd copy of my file, performed the filter, and then appended that to the original file. thanks a lot for your assistance though. It's great to know 4 ways to perform a task, it really...

I have an excel worksheet with about 10,000 rows of data and 10 or so columns. i would like to grab a list of unique vendor names from column C, many of the names reappear in each row. is there a function that can do this for me. i just want a list of unique values in a row. i've tried using...

hello all, I am tryingt o set up excel so that when i open up 2 spreadsheets they open and become affiliated with seprate task bar icons so that i can manuever between them easier. where can i set the feature to set up a new instance of excel when i open a 2nd, 3rd etc. file? thanks alot