Recent content by MarcusMaximus

That works creating a seperate text box to stop the original. JobLogMemoOrig being a separate text box on the form that invisible and not enabled s oit can't be edited. 'Cancel Me.JobLogMemo = Me.JobLogMemoOrig & vbCrLf & UCase(" (" & DLookup("StaffFName & ' ' & StaffLName", "tblStaff"...

What if i was to put the original memo into a text box that's invisible and when the user cancels copy the invisible text box into the visible one similarly to the save and exit option but appened the text "Cancelled on [Date] by [username]"

Hi i have an access database for tracking quotes and jobs, this includes a job memo section for any addition info on the job which is a memo field in the job table, tbljob. One of the staff claims that some of the info is just disappearing out of the memo field which i find hard to believe. I...

Apologies if I sounded a little ungrateful in the reply. I misinterpreted your recommendation. I tried to implement the the following in my report http://support.microsoft.com/default.aspx?scid=kb;en-us;285820 with a few changes to suite the report as the solution is for forms. I got the image...

I'd imagine you'd just create a second record set and use the same 'Do While' function to traverse through it and use sheet 2 instead of sheet one. Cherge may be able to give you more info or give it a go yourself.

Thanks but I don't think the solution will work as the are lots of images on our website that we want to possibly link to. Downloading the images defeats the purpose of what I am trying to achieve.

I want to embed web images into an access report. I have an access report that currently works perfectly pulling images in and displaying them from a local drive for each record. I want to keep this and add functionality to include images from a web site but it doesn't work when i put in...

Thanks chergh, your code worked a treat. I'm only getting the hang of vba from learning from people like yourself. At that I wouldn't have been able to come up with that fine piece of code.

Thanks for the Help people. I had one last throw at the dice and it didn't work so I'm going home for the evening and will do it manually tomorrow instead, unless somebody can offer me some insight into why my new or old technique won't work. In the new technique i write to the Temptable and...

Thanks chergh, but I'm probably going to have to do it manually unless i can find a work around. Maybe create a table and export that table to an excel file and then delete that table. And work my way through the record set.

Public Function ExportFiles() Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection rst.CursorType = adOpenStatic rst.Open "SELECT DISTINCT tblcustomer.userid FROM tblcustomer" While Not rst.EOF Dim...

Here's what I've come up with Public Function ExportFiles() Dim rst As ADODB.Recordset Set rst = New ADODB.Recordset rst.ActiveConnection = CurrentProject.Connection rst.CursorType = adOpenStatic rst.Open "SELECT DISTINCT tblcustomer.userid FROM tblcustomer" While...

I don't want to copy tables to separate worksheets. I have one table and i want to export multiple excel spread sheets based on the userid field. MSAccessRookie has the right idea but I'm not very familiar with VBA. Select Distinct UserID from tblcustomers What do i do with this query so i can...

Hi I have a database with many staff members and each staff member has many Customers assigned to them. I want to export customer details to a separate excel file for each staff member. I don't want to have to do this manually as its going to take up time. I'd like to name the files...

I couldn't find any tool to make as solved but consider this solved