Search results for query: *

the microsoft jet database engine cannot open the file <FILENAME> it is already opened exclusively by another user how do i correct this, i have the db and the linked excell file in a drive share that is being shared by 18 users, when i have it open they cannot access it.

how do you disable the scroll bars on the side or bottom of a page and also how do you remove scroll bars in a field

this there a way I can design one form with all the same field names and then just change the source name where it pulls its data from, i ask this because i have multiple quierys using the same data and it would make it easy if I just had to design one form and just chage the quiery name each...

when i run the form wizard using data from a quiery the data that appears in the text box of the form is the field name not the data in that field. ex: field name is server model number, the server model number should show up in the text box instead the the field name of server model number is...

when I take and build a form using a quiery i wrote you have the column heading and then there should be a part number under the heading. example 36 gb 15k HD - text label 310-0001 this is the part number that should be appearing in the text box from data generated from the quiery insted the...

how do i insert a group footer so i can creat a group total field for my prices thanks nick

i am tring to sum a field called prices i currently have =Sum([Price]) in a text box in the page footer and it gives me #error how can i get this to work. (does it need to go into the report footer) nick

i have a table with a currency and a date in the same column and to get my currency to total in excel i need to remove the date but i cant. how do i get data type number to recognize the dat with out having problems. when it does not recognize it it deletes the rows with the date. how do i...

I Need to run an update query to fill in a dollar value, it is set to text but then it sees a cell that has a date or dollar value it won't cange or update it, essently it only fills cells that are emptyand does not over write the cells with data. I have had the problem with over writing data...

i am writting a macro that will use multiple update queries i know in the sql it specifies the name of the table, how do you set it to run and prompt you for the name of the table you want to update when i run the multiple queries using the macro nick

what i need to do is when the description says computer A i ned to put this date when the description says Computer b put this date. also i will have multiple descriptions for each date so will i use an or statement for the descriptions while i use an if then for the date matching thanks

i need to run a query to remove qoutes &quot; and also double quote &quot;&quot; how do i do this they appear on the end of some text &quot;like this&quot; and also &quot;like,&quot;this&quot; so how iwll go about removing them i know it will probobaly be an update or delete query thanks nick

i need to write a query that looks at month and year but can use a wild card for the date there for pulling all date within a paticulare month and year would i use the following 08/??/2001 or is it differant. ?? being my wild card or what is the wild card for a query

i want to remove &quot; 's that have been imported i know this is possible how would i do this and would i use a delete or append query

i need to take the answer in =Sum([Cost])and devide it by =Sum([Asset Count]) to get a average total how do i do this, it will then creat a new toal answer

i need access to add the total in one column and give me a grand total of that one in another,instead all the scripts i have been given are carrying the total over to the next column and not adding anything exp: SumOfAmounts Total $5,021.00 $900.29 $1,500.00 7421.29...

I need the amounts column to add all three values up as one whole to and not to carry the totals to sumoftotal column, there should be only one number in the sum of total column and that is the total of all three. next i need to add the assets up and divide by the total number of assets...

where does this data go or do i build it in expression builder. Select FieldName, Sum(FieldName) as SumOfFieldName, Avg(FieldName) as AvgOfFieldName FROM TblName

how do i get Access to add all in a paticular field column, right now all it is dong is by row. after i get that problem resolved what i need to do is to take that total and divid it by the number of row to get an average, what do i need to do.

how do i create a query that will recognize a value(meaning the number of line items in a table column by adding thier total then dividing them by the number of items in that column, but the number of items changes when one is deleted so in other words the divide by number changes automaticly...