ChrisM@home (2/6/2012)

---

pwalter83 (2/6/2012)

---

Hi,

I need to use the split function to display values separated by comma(,). However, the problem I am facing is that the values itself are separated by space....

J Livingston SQL (1/23/2012)

---

pwalter83 (1/23/2012)

---

Thanks for your reply, however, I do not want to create a new table from scratch....

Sean Lange (1/23/2012)

---

pwalter83 (1/23/2012)

---

Hi,

I am new to MS Access (2007) and have a requirement to add an existing table to MS- Access database. There are 4 tables already associated with...

Thanks for your reply, however, I do not want to create a new table from scratch. I only wish to...

Well, that is the only problem and the reason for my query. This is...

I didnt understand you, I cannot bring the...

Hi Ninja,

Thanks, I was able to find out the correct syntax but this still doesnt work and gives an error- #Name?

I am trying to autopopulate a...

ProofOfLife (12/19/2011)

---

Hi Paul

I am comfortable using VBA, so my solution would be to add an AfterUpdate event on the LINE_CD control with something simple like a DLookup, using it to...

Ninja's_RGR'us (12/19/2011)

---

In vba the code will look like

me.text1...

Ninja's_RGR'us (12/19/2011)

---

Add the 2 columns in the select that fills the combo, change the # of columns property in the combo. Set the witdh for those colums to 0;

So...

Ninja's_RGR'us (12/16/2011)

---

P.S. Just make sure to not leave it on once you're done, it requires a lot of ressources and in a very worst case scenario it can slow down...

Ninja's_RGR'us (12/16/2011)

---

Time to run profiler and see what access sends to sql server. Debug that in SSMS then bring it back to access once it works in SSMS.

Keep in...

I am using sql as the data source. The values...

Ninja's_RGR'us (12/16/2011)

---

Is the data on access or sql server?

If the latter you can run a trace to see what access is sending to sql server.

If the former, go step by...

I did what you told me and created a query and when I run it int he query builder...