Search results

The spreadsheet they are using is pretty basic. With just 3 tabs, one for input, output and a graph. About the samples: I populated the database to the point where there are 10 samples. And sometimes its needed to lets say mix sample 3 and 4. Or when the test is done with just just sample 1...

Yeah, you are probably right. The thing is, someone started making this database in early 2008, but never got to finish it. The people in the lab are still using Excel to enter the data and eventually make graphs etc. Ive put that all into Access, and everything works great. But now they...

Good Afternoon, I am currently working on a Access Application to determine the degree of compaction of sand. The degree of compaction is determined and calculated by putting samples in a Proctor machine. At this point, the user is able to select the different samples that need to go...

Thanks m8. Problem solved with a simple Private Sub Form_Load() Me.Form.Tabsubforms.subformprctrgrfkNEN.RecordSource = queryproctwtrgehgrfkNEN End Sub Cheers :)

Good Morning, As you may remember, i am having some problems with a graph on a subform. After a couple of days of trying several 'solutions' i tried to make a input criteria where the user can enter a ProctorID, which filters the graph and shows the graph of the given proctor. Which works...

Hey there again, I have a pretty simple question, just cant find a working solution. As you might remember i made a function to audit changes. When a change is being made, it checks if the active.control is empty, if it isnt it displays a inputbox to ask for the reason. Works perfect, but...

I wanted to let you know that ive found the solution. This topic can be closed :)

Good Morning, A couple of months ago i made a function in VBA to audit changes made using forms. Everything works perfect, the code i am using atm is: Public Function TrackChanges() Dim db As Database Dim rs As Recordset Dim strSQL As String Dim strCtl As String Dim strReason As String...

First off all, i'd like to apologize for responding this late. But i havent been at work due to the flue :(. Anyways, i cant seem to figure out whats wrong. Like i mentioned before i have a form with 5 subforms, made of tabs. Tab 1 : Input data Tab 2 : A tab to calculate if a correction is...

Ya i was thinking it could be something like that. Which is a pain in the ass because at this point, i really need that query. I wonder if it can be fixed by converting the query into a "make table " query. And then get the table, set up the relationships and then add it to the query for the...

Ya the thing is, On the new formula to determine the water-content of the sample, needs more data then the original formula, that extra data is provided in another query. I tried to change the RIGHT JOIN into an INNER JOIN, but it didnt have any effect on the outcome of the graph. Anyways...

Good morning, I am working on a database to determine the water-content of a specific sample. And the idea is to make a graph based on a query. I actually have to make 2 graphs, one based on the NEN(RAW) rules / standards, and on based on the NEN-EN rules / standards. The RAW graph works...

Ive added a screenshot of both graphs. Graph 1 is the graph that works perfectly, but graph2 on the otherhand.... As you can see it added the 7 points from proctor 1 (top ones) and the 6 points of proctor 2 (buttom ones)..

Good Afternoon, I am having a problem with a scatter plot i made in access.. I made 2 graphs this morning. Each graph represents some test results, but both calculated in a different way. The first graph works just fine. And the query behind it is : SELECT...

Good Morning peeps, Situation: I am trying to tweak a database i made a couple of months ago. As you might recall from my earlier posts, i made this database for a laboratory. Everything works fine but theres just one small thing that needs to be "fixed".. On one of the reports, a query...

Ill have a look... Thanks m8!

Yes, i noticed Date() was giving an error aswell, i changed it to now() and that error was gone. I think i may have found a solution to the report issue. One of the libraries that was checked (Microsoft ActiveX Data Objects 2.5), had a couple of 'newer' versions. So i changed the reference...

Good morning, Since last Monday ive been getting this error when i try to open a report. And i cant figure out how to solve it without losing other functions of the database. I know changing the reference to the from Microsoft DAO 3.6 to Microsoft DAO 3.5.1 solves the problem, but then i...

Good afternoon, Ive made some databases in the past few weeks, and every now and then there has been an update in either the VBA code or in the query format. Which means i'd have to manually copy the data from the former Database to the new and improved database. Which works, but takes a lot...

Good morning, I am having the following problem.. 2 months ago i added a function =TrackChanges to my database to track changes made using forms. The changes are being saved into a table. It was working great and its been "live" for about 6 weeks. But for some reason it stopped working in...