Search results

#Error on the datasheet

no its more like Left("Test 1", Instr("Test 1", " ")) will give me "Test " and i need "Test" because i will need to compare it later with another string, and it wont let me because im using it on an update query god knows why (one field of the table will be updated as "Test" to be clear), ill...

Hello Everyone I was wondering if you know any way to substract 1 to the instr returned value inside the left function, im doing something like left ([Field],instr([field]," ")), except the instr value needs to have something like this left ([Field],instr([field]," ")-1) but access won't let me...

by the way do you know any way to substract 1 to the instr returned value inside the left function? im doing something like left ([Field],instr([field]," ")), except the instr value needs to have something like this ([Field],instr([field]," ")-1) but access won't let me do that

Thanks a million this is exactly what i needed

Hello Everyone, I am working on an access database and i need to take some code that comes on one field and add it to another, a quick example, i have the field description and it comes like 1234 description 1, the code is always separated by a space from the description, I pretty much need to...

genious, thanks a million worked perfectly

Hello again everyone, I have a table that has this kind of fields, expense type, expense description, jan, feb, mar, apr, etc etc, the month fields showing the amount spent on each month, i need to take this view to a list kinda, and show the month value only, aka showing this with a new column...

Thanks a million millions man! this examples are exactly what i needed!, i hope i can add some of my vba code to it, make it get executed to excel and it will work smoothly according to what i need, really appreciated

Hey everyone, i am trying to export a designed table to excel, problem is, i need to export it with some formatting and i need to add totals for some of the columns, is there a way to do it with vba? i need to add some totals at the end of the sheet and doing it automatically would really help...

Hello everyone, I am kinda new to access and i discovered the pivot table view, i see a lot of advantages on it and i find it really powerful as a tool, based on this, i was wondering if there is a way for users to edit the information shown on the pivot table, or something similar to that...

yeah come to think of it that could work better in case theres errors, cuz my method can have a common mistake, ima research that more, thanks for the info man really appreciated

thanks a million man, really appreciate the help, it worked

Im trying to implement a query that creates a table with existing filtered data when i click a button, the problem is that, whenever i do this access prompts some windows asking if i want to confirm the operation of inserting X rows, i wanted to know if theres any parameter or any method to do...

the IT thing made me laugh, they are actually making this 10 times harder than it has to be, but yeah ill consider that, thanks for the info but ill still try to find a way around with the sharepoint, maybe a web database, im still open to more suggestions to see what i can do or help me take a...

yeah, i saw that option as well and it seemed pretty convenient, the problem is that the only resource allowed for us to share files is the sharepoint itself, that has become an issue for me since they dont allow servers, so it doesnt work for me completely, i tried uploading the back end to...

Hello, i am new to this forums and kind of new using access as well, i am developing a database atm and i am trying to share it for use with various computers at the same time, the problem is that i dont know how to share it properly, i tried using the sharepoint lists as tables but this is...