Recent content by Scottish_Anatomist

Hey Everyone, Not so much a problem as curiosity. While going through all the code I've written for a project over the last year, I noticed that I've used two different methods to achieve the same result to add and edit/update records in tables. It seems that at the beginning of the project I...

Thanks sneuberg, that fixed that problem! Although unfortunately still can't get the whole thing to work lol. Yeah Ranman256, that was my first instinct as well, however then I ran into problems sorting the column headings into the order I needed them. :)

Hey Everyone, I'm trying to create a form that displays a crosstab query by putting in the maximum number of columns that could be returned as text boxes and I'm trying to create some VBA that will hide the unused ones. I originally tried to use a report based on some code that was posted as...

Thanks for the advice Minty, I really appreciate it! :)

Hi Everyone, I've created a search form where you can view multiple columns of data and can narrow down the data by searching via text box. I did this with the following code: Private Sub txt_MarketSearchBox_Change() Dim SearchString As String SearchString = txt_MarketSearchBox.Text...

Hey everyone, I'm trying to find a way to access the x axis category values on a chart created from a query (and the y axis ones). Although there is a wealth of information about manipulating the chart object in excel, I've been unable to find much about doing it in access and viewing the...

Hey Everyone, My name's James and I'm an Access-a-holic. Ok, maybe not quite - but I enjoy the ever frustrating circle of designing a database. In the real world I'm an anatomist, postgrad student and researcher living in the often rainy, but always interesting, city of Glasgow. (For any...