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

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

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

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

Hello everyone 2 things 1st- I would like to make a query where the user could select an ID from a list as well as a begin and an end date to search within. the data from the table would then be extraced with all accounts under that ID for the time period selected. i know i have seen a greater...

Hello everyone, I'm a summer intern and have been given a project to finish with office 97. I am having a problem when I import an excel file that has data for at least 3 sequential days. the import occurs everyday though. as a result if one of the data fields has not been removed from the...

Hello everyone, I'm a summer intern and have been given a project to finish with office 97. I am having a problem when I import an excel file that has data for at least 3 sequential days. the import occurs everyday though. as a result if one of the data fields has not been removed from the...

I have a rather detailed macro that opens a lot of xls files then closes them. Id rather the user not see all the processing and only see the end result. I tried using Application.Visible = Flase at the begining and then Application.Visible = True as the last line to bring excel back on the...