Search results

I have to replicate my database in a different location each day and I wanted to know if there's a way to retain the security and linkage once moved. My goal is to move the database. Front-End and Back-End as well as the security file so that it can be used at another site for reporting. Due...

I moved my access database and not my user account do not have privelages. However, the group accounts they are linked to have been set-up correctly. Why would my group account privelages be ok, but when I look at each user individually they have no privelages set. I'm confused as to why...

Does anyone know if there is a way to align text in a message box? I have a number of categories I want to display with the values and I want everything to line up. I want the ":" to line up on each category EX. Statement_ID: 312030 Parent: ABC Statement_Amount: $50,000.00

Does anyone know if there is a way to align text in a message box? I have a number of categories I want to display with the values and I want everything to line up. I want the ":" to line up on each category EX. Statement_ID: 312030 Parent: ABC Statement_Amount: $50,000.00

Is there a way to set a "Range" from vb code in Access? I use ranges a lot in excel to create formulas and I cannot figure out how to do this from access when exporting data to excel. Any information would be appreciated.

I am able to copy a recordset to excel, but I can't figure out how to copy the column headers. Any information would be appreciated.

Does anyone know how to manipulate a saved query? I want to change the select statement with code so that my pivot table will use the new records. Any information would be appreciated.

Does anyone know how to manipulate a saved query? I want to change the select statement with code so that my pivot table will use the new records. Any information would be appreciated.

I'm stuck trying to figure out how to update a query I have already saved. Here's my situation, I have already created a query called "REPORT_STMT_Breakout" and I want to be able to change this query based upon some date variables on a form. I'm using this query to create a pivot table. I can...

I have a query I saved which pulls data and a form that creates a pivot table based upon the query. Is there a way to create a query based upon criteria such as dates to limit my recordset? I'm trying to set date values in a form and update my saved query but I cannot figure it out. Any help...