Search results

Hi Estuardo, Many thanks for you help, the problem is now solved. I would never have found it without your help. Kind regards, Eddie

I am running a query from a form to export the selected records to a .csv file. This works perfectly except that I want it exported in UFT-8 format. Is there way that I can do this? The code that I am using is as follows: The fields appended to NewProducts are so that the query can be run...

The criteria will be the ID of the record selected and I want returned the FieldLine for the related records. Kind regards, Eddie

In the fieldLine it returns as a string the values from a single column in a table. e.g. the records in the table are Black Blue Green The fieldline will return: 'black blue green'. Kind regards, Eddie

Hi Dave, I'm calling it in a query that I want to use as an update query. The end use is that the field line will be included in a CSV export file. Kind regards, Eddie

Little more help: I was given the following function which works perfectly: - Public Function FieldLine(FName As String, TName As String, Separator As String) As String Dim Mydb As Database Dim Rst As Recordset Set Mydb = CurrentDb Set Rst = Mydb.OpenRecordset("SELECT " & FName...

Hi Paul, you’re a gem, I have been at this all day and you’ve got it to work for me. Many Many thanks Eddie Before :banghead: after: :D

I've cut and pasted the module. Created a form with an unbound test with: = FieldLine("Options", "tblDBTest", " ") as its control source but when I try to open the form it gives me the following message: Run-time error '3061' Too few parameters. Expected 1. Does this make any sense. Kind...

I have a table with a field ‘Options’ that contains several records. What I want to do is to list the content of ‘Options’ into a single field separated by space. Eg: Options Small Medium Large To appear in a field as: Small Medium Large Options Small Medium Large Massive To appear in a...

Hi CJ, I have copied and pasted your function which I named as basListRecords but when I call it, it just returns an error. I have changed the: Set Res=Mydb.OpenRecordset("SELECT " & FName & " FROM " & TName & "WHERE FName is Not Null") To Set Rst=Mydb.OpenRecordset("SELECT " & FName & " FROM...

Hi CJ Your advice has indeed been very useful and I thank you very much not only for giving it but also your prompt reply. kind regards, Eddie P.S. where is the thanks button :)

I have a table with a field ‘Options’ that contains several records. What I want to do is list the content of ‘Options’ into a single field separated by space. Eg: Options Small Medium Large To appear in a field as: Small Medium Large Options Small Medium Large Massive To appear in...

Hi Catalina, Sorry for the delay coming back but had the opportunity to get away for a few days; I have now managed to get the colour change working. Many thanks for your help it was appreciated. Kind regards, Eddie

Hi Catalina, I am assuming that from your advice I will need to create a blind field with a default value of 0 for each of the fields that needs to be amended, and as each field is amended on its update event its corresponding blind field value is changed to 1. Is that what you are...

I have set certain fields to have a red “Fore Color” to indicate to the user that these fields need updating. After the field has been updating I change its “Fore Color” from red to black to do this I have put the following code onto the fields “On Change Event”: Private Sub SKU_Change()...

I would like to be able to copy a single record in a table and then paste this record a pre-defined number of times 10,20,30 depending on requirements. The reason I need to do this is that I want to set up a number of identical records that can easily be amended into unique records. This will...

Many many thanks for your help; based on your advice the single form now tracks the continuous form. This is just what I wanted. Kindest regards, Eddie

Thank you for the advice, I’ve certainly wasted a lot of time on split forms. What I’m now attempting is to achieve the same by placing two unbound subforms onto a parent form; one subform as a continuous form and one as a single form. However what I’m still having difficulty with is...

My apologies to everyone before I wrote this enquiry I had not seen the correspondence on this and I did not realise that it could not be done. In my defence the video from Microsoft showing how to set up a Navigation Form shows a picture of at the beginning of a split form. I’m assuming at that...

I’m new to both the Navigation Forms & Split Forms in Access 2010, but I can see that there is a lot to be gained from their use. What I could do with is some advice as to whether a split form can run in a navigation form? From my experience when I linked a split form into a navigation form it...