Search results for query: *

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

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

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

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] & "'...

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

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