Search results for query: *

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...

Well in frustration I deleted the switchboard and re-made it and guess what it works now. The forms all do what they are supposed too. Must have been some underlying error causing it not function correctly which deleting must have reset. Either way it works correctly now so thanks for your...

I put a watch on the bookmark in code with some interesting results. When just the form is open the rs.bookmark has an absolute value of 1229 and the variable for customerId has the correct value 1207 However when run from the switchboard with the same code the varible still has the correct...

Actually upon testing like you suggested it seems when run from the switchboard the select record dosent function at all, even if you close the switchboard after you select the main customer entry/edit form. It seems if its run from the switchboard at all it dosent function, whether or not you...

Hi have a wierd thing happening in my database. I have a form in which you can enter customer details and create a new record for that customer from it. I also have a button which pops up a modal mini form to select a current customer name and pops that record up back into the customer details...

Hello out there im new this forum, but have searched many helpful answers for my problems and now have a question of my own. I have a form with search customer name, which pulls out all the instances of data files for that customer name and displays them in a list box. You can then select which...