Search results

I think it would need to be a table, i will give you a bigger picture idea of what i am trying to accomplish in the hope it might make it clearer. Basically i am trying to create a database which tracks client samples that are received for testing, so that when the samples are recieved they are...

Sorry about the lack of information, I was not really sure what information was needed. The items being tested vary, but I thought i would just refer to the as "Product" which would go into the sample table, from there I wanted to be able to define what each product is being tested for, and for...

Hello, I am slowly tip toeing into the world of Microsoft Access and am finding it quite interesting, however I have a strange table requirement that I am trying to get working and to be honest I am quite stumped at the easiest way to do this. Basically the table is a 'test request' table...

Hello, I am wondering if anyone has an example word document they would be able to send me that would show how merging images works. Basically I have a spreadsheet which has a column for the Building name, and another which is the Room name and then a third column which is the image filename...

Hello. I am slowly learning more and more about access and its various abilities. I suspect i am moving more towards a PHP and MySQL based solution with this question, but i will ask it anyway. I am looking to create a projects database, where there are employee's who have projects, and...

It might interest you to know that Albert Einstein was actually not working as a full time scientist when he discovered the theory of Relativity, instead he was working as a Patent Clerk. Some of the great discoveries have been made by people who are not full time scientists. So i would not...

I love that comment, it made me laugh, lets look at the phrase 'real scientists' as framed by a religious style atheism. It is some of the most influential scientists in history who are locked in by a religious style atheism who have come up with some of the most incredible discoveries. Indeed...

You stated that i was unable to see any other view, and blinded by my religious atheism. Have a look at the above comment and read it, i have quite clearly indicated that there are missing links in the theory. Like everyone else has stated, have a look at the evidence, it is there and if you...

I think clearly this is a debate that is quite fruitless, simply because instead of going with the evidence that is presented before us. You choose to put faith in the word of the bible (which is your choice). The science is clearly there in terms of evolution, the concept, principal and even...

Modern HealthCare throws a spanner in the works of Evolution, Evolution is quite a lot about environmental pressure which allows the development of a trait or characteristic which is of benefit, in the same way it also allows for the removal of genes which do not serve any benefit, by the...

small time changes add up, look at each time you eat junk food, your stomach gets slowly bigger and bigger, which might not be noticable at the time, but in the span of 50 - 60 years, it becomes very noticable. (pending exercise etc) its a bad analogy but the same with evoloution, given a much...

you have compleatly mis-interprated my comments, which is not a first as i tend to not explain myself very well. Evolution functions perfectly well, it does not try and say man evolved from species A to species B, it simply says that over a period of time, there will be a range of random...

For those that are interested this is the age-of-man theory, or at least one of them. http://en.wikipedia.org/wiki/File:Age-of-Man-wiki.jpg

Replies with "I aint related to no damn monkey! :mad: lol"

Ahh how i love the evolution arguments, it certianly brings about some of the most interesting debates! The theory of evolution is quite simple, it says that an evolutionary pressure is applied to a population, and within that population there will be random mutations as is normal in any...

I am curious how people handle reporting in their database systems, basically i am trying to work out how i can allow my system to dynamically generate reports but still allow for traceability. The logic is that i would need to potentially generate a reportID, and other report information in a...

Thanks for taking a peak at it. I have attached a mock up database, and there is a query that shows the SampleID, the Test, and the Calculation. I guess the idea is to be able to have a report that would group by Test Name, and then show the SampleID, and is joined by the SampleID and would show...

Hi, I have quite a few different calculations that i run depending on the analysis type that was requested from the client. Because of this i was trying to work out how to best structure the system to handle these different calculations that thought possibly about storing the SQL in a table. I...

Got it working with this, not the neatest but it works :) Private Sub ImportMultiple() Dim strFile As String Dim strFileList() As String Dim intFile As Integer Dim filename As String Dim path As String Dim Response As String Dim myStrFilter As String Dim strInputFileName As String Dim strSQL...

So i got it to import a specific file using this code below, but how do i now get it to import anything with PG*.xls and also to scan through every worksheet within the spreadsheet? Public Sub ADD() Dim myRec As DAO.Recordset Dim xl As Excel.Application Dim xlsht As Excel.Worksheet Dim xlWrkBk...