Search results

New fish in the ocean.

After a great suggestion from the community yesterday I am now one step forward into completing my task . Yet I am facing another problem which I am unable to solve myself because I still lack alot of knowledge of Access. First lets say I have a table named Table1 with the following structure...

Hey, I am trying to filter around 60 000 + lines of data with the use of combo boxes. Since ACCESS is rather new for me I am now completly stuck on how to combine the combo boxes. Lets say I have a table with this structure: I have first created a couple of queries to merge all relevant...

well the replacing at the end will not be a problem, but that step is one step too far :P. My question is how to set the standard value, or the value of the column 'NAME CODE' as <name>Name (variable)</name> As the size of the whole DB/ nr of lines are flexible it has to put the dummy file into...

Hey there I am rather new to working with Microsoft Acces and I have now come to the point that I want to integrate certain data into a static 'dummy XML code' which will ultimately end up in Acces building up the full .xml code. I have first focused on splitting and re-calculating the data...

But what I am trying to do is go from 1 column into 3, so splitting the digits up. I have a few thousand lines so a static function isnt possible. Isn't Replace function pretty static? or should I make the 'replace with' a variable? Edit 1: also, if I replace the ; for , it would mess up the...

Hey, I am very new to Microsoft Acces (just a few hours) and I know these questions / problems are fairly easy, but yet I would love some help since googling for some time didnt give me a satisfying answer. Basicly what I am trying to do atm is seperate a sery of numbers on a specific character...