Search results

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

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

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

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

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

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