Recent content by barsa

I only need the <u>data</u> from the Access report. Once in Excel, the user will be able to edit the data (calculations).&nbsp;&nbsp;I am assuming that I would be able to have the data imported into Excel in some type of report format.&nbsp;&nbsp;Am I assuming correctly?

I have a report that gets created in Access, and I would like to be able to create a template in Excel to where the Access report could be exported, and once in Excel, the report could be edited.&nbsp;&nbsp;As of now, the Access report cannot be edited.&nbsp;&nbsp;<br><br>Can this be done?<br>If...

Here's an example:&nbsp;&nbsp;I try to import data from Excel,(for example), in which there are NULL values in a column that contains numbers and text.&nbsp;&nbsp;The column is formatted as text in Excel, and as I import in the Access wizard, I try to define the same column as text, but it...

Here's an example:&nbsp;&nbsp;I try to import data from Excel,(for example), in which there are NULL values in a column that contains numbers and text.&nbsp;&nbsp;The column is formatted as text in Excel, and as I import in the Access wizard, I try to define the same column as text, but it...

I performed some administrative updates to a database, and now I am trying to compact the database.&nbsp;&nbsp;I am getting an error returned saying that the database is &quot;opened exclusively by user....&quot;, and the computer is <b>MINE</b>.&nbsp;&nbsp;I close out of the database and in...

I have a database out on a shared drive, and the problem that is occuring is that one user, upon using a form that performs a function, gets a &quot;Cannot find project or library&quot; error message and within the function in the VBA module the &quot;Date&quot; function is...

How is it possible to create a button within a form that when pressed, the file window appears where you can select a file to be attached?<br> <br> I have a button that performs <br> @PostedCommand([EditRight];&quot;1&quot;)<br> @PostedCommand([EditInsertFileAttachment])<br>...

I imagined using a consecutive number system, (i.e. 1,2,3,4,...) <br> Basically, I would need to use a system that would allow for &quot;inserting&quot; a number, and refreshing all the documents.<br> <br> What do you see as my options?

First, since the existing documents will have to be updated with a value in this new field, I was thinking that I would sort the documents in a view according to how I think they should be prioritized, then CONSECUTIVELY enter the Priority number as they are sorted within the view.<br> <br> Once...

Thanks for the response...<br> My first task was to create the new field into the form, which I have completed. I have created a new view with the documents using the updated form, (using SELECT Form = formName).<br> <br> Now I am trying to figure out how to create a formula for the value of...

I am just beginning to work with Lotus Notes, and my task is to update an existing database by introducing a field into a form that creates an &quot;issue priority number&quot; for each document. Is it possible to update each existing document with this new field to then be able to sort by...