Recent content by wheels27

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.

same thing happens, no effect thanks Nick

Thank you for the reply, is there a solution fro removing it from the individual text boxes Nick

ok this eliminates the scroll bars on the page but i need to eliminate the scroll bars in the individual fields and that setting does not acomplish that. nick

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

simple the tile of the label is appearing in the data field insted of the acutal data which should be the part number nick

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

yes there is a format to it the data type is text but i have currency in there, with date and a text word. i have figured i can covert the text word to a numeric value that has been solved but the dat is the prob. the currency value is $0000.00 date value is 00/00/0000 how can i take the date...

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