Search results

Thank you plog, That's the ticket........So easy... I see the approach........ Thank You, Thank You:)

Hello All: I have been struggling with understanding Queries related to Time Series. I find it difficult to get the right answer or understanding how to ask the right question Access style…… Table below is a sample data/table example for my question. The intent is to build a query that...

I am trying to import a table from another database. from all the stuff that I look at this code should work. but it just sits there as nothing happens am I missing something..... DoCmd.TransferDatabase acImport, "Microsoft Access", _ "Path_To_Database;PWD=password;LANGUAGE=us_english;"...

Thank you very much for your help

It Worked.......Great......Thanks..... So Is it the extra space that prohibit it from giving the result.......?

Thanks for the info......I have modified it as per the Article........ The ELookup is looking for a numeric value (MP_Elev) using an String, Alpha Numeric (Well_ID), If I understand this the Expression should be build for Text, if I am right it should look like this...

OK.... This is really embarrassing, You are right it's Details not Datails..... Corrected that and now it gives me a syntax error The Well_ID is string alpha numeric.......

Changed it as suggested, same result (#Name?)... I think I have Already tried this,,, =ELookup("[MP_Elev]","Elevation","Well_ID = " & [Forms]![Facility_Datails]![Well_ID],"ChangeDate DESC")Ardy

Yes The form will open (see Attachment)

Hello all: I am trying to use Allen Browne’s Extended DLookup() http://allenbrowne.com/ser-42.html namely ELookup(), But am running to a bit of problem. At first I got some syntax errors in which I figured out but now I am hitting a wall with No result…..I am hoping some of you might be able...

OK finally got it figured out,:D It seems that the SQL INSET INTO needs to match the table in terms of number, order and type, then we can use VALUES to set or create records..... In case somebody comes across this thread, I am posting the Code that works as of now..... Private Sub...

Hello Paul.... Yes you did, and I really appreciate it. It was for the same project. I am trying to custom make a an applet(Grade Book) for my wife(teacher). The fields are : GUSD_Student_ID : Number Subject: Text Type: Text Score: Number Nam: Text I tried your version with warning off so I...

Hello All: In the code below I am creating a record with the INSET INTO statement and then Updating with additional info in various fields. it is not working the way I thought it would, so I am trying to create the record in it's entirety …… SQL_Grade_GUSD_ID = "INSERT INTO Grades...

Thanks.......

The SQLs work fine, I just wanted to know is there a way to write the same code but in less number of lines .......for example is there a way to combine all DCmd.RunSQL statements.....

Hello All: How can I make the following code shorter to use less line of code.... DoCmd.SetWarnings False SQL = "INSERT INTO Guardians (GUSD_Student_ID) VALUES (" & Me.GUSD_Student_ID & ")" SQL1 = "INSERT INTO Grades (GUSD_Student_ID) VALUES (" & Me.GUSD_Student_ID & ")"...

For a moment I thought I am alone,,........:mad: Thanks JHB for the reply, been reading a bunch since my post, I came to the same conclusion, I think the easiest way out of this is to back fill the data with zero before the report even gets activated.......

Hello All: I have made a cross-tab query which works fine. I also have made a report which is based on this cross-tab query. Due to nature of the cross-tab query the Value column(s) is dynamic. The report I made is based on all available data types (columns). The report works if all data...

:)I love this forum, Thanks JHB and Old Man Devin, Both solutions works good. I am learning a lot, Always wondered what the OpenArgs are used for now I get it, I am sure I will be using this alot............. Thanks Ardy

Thanks for the reply, but maybe I am not explaining this correctly...... let me try again...... we have form(A) on this form there are two buttons (create test, Create Assignment). the two button are pointing to the same form(B).(yes I know ...Why two button are pointing to the same thing, but...