Search results

Pat, You are right. InspectionID is an autonumber in the inspection table. As well as in the observation table as foreign key. I am trying to to see how can I use your code with the 3 tables (Inspection, Observation and Code). The list above is the result of a query. The sorting has to be done...

Pat, Thank you very much for your help! I am relatively new to Access and VBA. I have 3 tables to play with in my case: INSPECTIONS, OBSERVATIONS and CODE. Those are the tables I used to produce the list above. (INSPECTION (1) TO OBSERVATIONS (many) and OBSERVATIONS (1) to CODE (many). I...

Pat, The second part of your comment is what most likely will work in this situation. I would like to see the code sample if its possible. Thanks so much!! Sac

JDraw, The sequence above (ST,LD,WL FH) will be created if there are no other observations in between ST (start if inspection) and FH (Finish Inspection). I will call that a perfect pipe with no other observation or defect. Every inspection must start with the first 3 codes. If no other...

JDraw, If I do that, then I loose the code sequence. That is, (ST, LD, WL.....................FH). The first 3 codes must be in that order. In addition, the inspection must end with code FH. Thanks for the reply. Sac

Hi All, As usual, thanks for all the use full comments. I am so sorry that I forgot to mention that it is the result from the sql statement shown below. I sorted by observation and distance. I did that because the code values need to be in the right sequence (Start of inspection, Line deviates...

Hi guys, I am trying to sort out this issue where I need the last row to be inserted at the right location distance wise. This is a query from 2 tables: Observation and Inspection. Observation table contains the foreign key of the Inspection table. This query only contains the observations of...

Thanks theDBug!!

Hi All, I used the concatRelated() function to store all field values that contained the same key (INSPECTION) in the table called structuralDefects. Eg. SELECT DISTINCT structuralDefects.INSPECTION, ConcatRelated("DESCRIPTION","structuralDefects","structuralDefects.INSPECTION = " &...

theDBguy Thank you, I will look into it!! SAC

Hi All, I am trying to store an array values into a textbox. I tryed several ways but I was not successfull. Below is my code: Any help will be much appreciated. Private Sub Form_Load() Dim strOpenArgs() As String If Not IsNull(Me.OpenArgs) Then strOpenArgs = Split(Me.OpenArgs...

Arnelgp, After playing with the code and following your example code, It appears that this did the trick! The Picture file saved in the docs folder is the same name as the db! So now I just simply take the pic without renaming. A month ago, I was green with access VBA. But with your help, I...

Arnelgp, Thank you! I made the change and I still get the first pic in Docs folder with the same name as the one inserted in the table. After that, the name inserted in the table is different than the file name. Thank, Sac

Good Morning Arnelgp, I wanted to insert the pic into the db without renaming it as it takes more time when doing a lot of inspections. Also, when I name the file as the previous by mistake using the Inbox, all files get renamed and the picture assigned to the record changes. So I changed the...

arnelgp, Thank you! Sac.

arnelgp, Attached is the db I am working on. Lots of mistakes there. Hopefully with time, I will do better. There are 5 tables: Asset, Inspection, Code, Project And observations. The tables relationships are one to many. Every form has a subform that display the record that you enter through...

arnelgp, Thanks again for taking the time to help me!! I will post my result once I finish. Cheers, Sac

I came up with the following code that will play the video where its path is passes in the Form_Load() event. And a buttom when you click, it takes the still image and stores it in the documents folder. I would like to know how do I rename the pic file and store the path in a table field. From...

Arnelgp, Thank you So much!! I wil give it a try and post my results. Sincerely, Sac.

Hi All, I was reading in the forum and came a cross how to take a picture from a webcam and store the pic path in the db. I would like to take pics from a video file and store the path in the db. Currently, I take the picture from the video file using VLC video player and store it in a...