Recent content by Ollie71

Yes you are correct that line is highlighted. Last time I ran it, MaxYaxis = 3 The proceedure is called on the after update of the combo selection box. Its one of 3 called. The first Drawgraph() simply sets the rowsource of the graph with a select statement that incorporates the user...

Hello its me again with another strange one. I have a form that displays a big graph of individual elements, that the user selects off a pull down menu. When selected, several functions are called to set the graphs source with the right sql to get the data for the graph. The second function...

I think you misunderstood me. I was simply stating some of the reasons why it is like that, not that it was a particulary good idea. It has made some of the importing and other things easier to code and changing it is going to require a lot of re-coding, but I do see your point about the...

No they dont have exactly 24 in them. They all have 47 elements which are split later into 3 subclasses via queries. The other problem is that each test is a unique testing of the lvls of these elements in the test sample. In normilizing the tables like above you would have a table where each...

Im well Aceman, how are you? Yes I do tend to overshare, saves reposts of more info requests, at least thats the theory. I see what you mean in being not normalized, I made this structure as it saves on numbers of records (as there are thousands of tests) and keeps the test information...

I thought this would be simple but I cant seem to find a satisfactory way of doing it. Basically I have a form that has a drop down name selector. Once you select a name, a list box is populated with test results. You then select a test result. A query is run populating a subform giving the...

User is me, happens on my machine. It seems like the database is stuck on open. Closing and re-opening it has no effect. Might try and recopy the front end from a backup and see if the trouble is there, maybe that will fix it.

Not sure if this is the right place to put this one but hopefully someone can help me. For some reason (something ive done, but no clue what) when I try to add a button to a form I get the following popup "The database has been placed in a state by user 'blah' on machine 'blah blah' that...

Thanks PHV that worked a treat, though its strange it has to be formatted ass about like that to save properly in the table, some sort of translation problem with date fields? wierd but working now, thanks again, that one had me frustrated all afternoon, access peculiarities continue to...

I have a date issue with a table that recieves data from a form via insert into sql statements. I have a form that selects a customer, gives a code and then inputs the details into two tables. The problem table "LabDespatch" has these fields "[TransID], [DespatchDate], [DateCreated]...

Nice that works, I tried to do that myself but stuffed it by only having 2 sets of double quote marks, didnt realise it was three. Wonder why the shorthand version reads the appostrahy as part of the code instead of just a character contained with the string? I would have thought you could...

I have the following in a form that runs from a button to append the information contained in unbound controls on the form. MySQlLabRegHair = "INSERT INTO LabRegister ([CustomerId], [Lab], [Sample Date], [AHSCode], [Name]) " _ & "VALUES (" & Me![CustomerId] & ", '" & Me![Lab] & "'...

I found out a way to do this, so its all good now. How does one close a thread? Ollie

HarleyQ, Thanks mate that worked perfectly. You earned your star! I used Remou's version only because I understood it a little more than your version which im sure would have worked fine as well. Not sure if there is a better way to achieve what I need but I assigned the 'code' to one each...

Not sure if this is a silly question or not but anyone tell me if you can compare and strip txt and numbers from a String Variable. I have in my Db two different results codes. One for people Hair analysis (a number code like2980..) and one for Misc analysis (could be anything from dust, skin...