Search results

It is considered best practice to not store calculated values, but rather to recalculate them wherever necessary.

The way i prefer to deal with this is to set the required option for the FK to yes and then trap error 3314, telling users to input data into the required parent form field(s) first.

Hi Fmeister, part of your problem is that you have decided to use a multi-valued field. They can be useful, but they can also be tricky little things. Just like attachment fields, multi-valued fields can be thought of as a table within a table. When dealing with individual records within a...

Check out Lebans functions in his demo db here. I think it should give you something to run with.

Check out this link.

Hi Travis, First I want to give you a high five for wanting to use a database. I have worked in a bunch of labs (biology and chemistry), and omg, how those people love their spreadsheets. Holy crap, spreadsheets for logging patient data, sample data, equipment data, staff data, consumable...

What about: Select Top 1 * FROM ClientSearch WHERE...

If your Access_folder and your Excel_folder will always reside in the same folder, and the name of your Excel_folder is not likely to change then you could use something like: Public Function GetNewPath() Dim strOldPath As String Dim strFolder As String Dim strNewPath As String strOldPath...

I have managed to achieve that which i set out to do. Since in my searching, i came across several posts in various forums where people had asked similar questions about how to identify the final detail section on a page of a report without helpful responses, i thought that i would detail the...

Hi, I am trying to make a line in a report visible in the last detail section on each page only. Is there a way to achieve this? I have spent hours playing with different ideas, but nothing... I have looked into the HasContinued and WillContinue methods with no success. Any thoughts would...

In this particular instance, i am running this query as part of a check before appending records into an archive database. The archive database unfortunately has tables with the same names and structure as the main DB, so i didn't want to confuse myself with table references. Often i do use...

If I declare my SQL as a string and then execute it using MyDBPath as in my original post, I have no problems. What I am trying to do is use that same function within the SQL of a regular query to determine the path of my remote DB which can be used when the BE file has been moved. For the...

MyDBPath returns the path to the linked Back End.

Hi, I am trying to run a remote query that looks in a database that is in the same directory as the Back End of my main database. In VBA i can run that sql and connect to the database using a function: SELECT... FROM tablename IN """ & MyDBPath & "MyDBName.accdb"" WHERE However i...

Have a look at this link.

You could try running the delete through SQL. Something like: DoCmd.RunSQL ("DELETE TableName.* " & _ "FROM TableName " & _ "WHERE TableName.IDFieldName = " & Me![IDFieldName] & "; ")

Firstly, yes i did test it. Secondly, you are correct in that error 3022 is thrown at you if you enter a duplicate Vendor Name. However the OP was referring to error 2116: "The value in the field or record violates the validation rule for the record or field. For example you may have...

Trapping the error in the forms' before update event works. But if you add more controls to the form, then that error won't be picked up until the entire form is updated, so if there are other controls that require data after you enter the VendorFedID, then you will go through that process first...

Thanks vbaInet. The values i used were only used as an example. The query i am putting together lumps some related items together for analysis. I got around the issue by creating an invisible textbox on my dialog form. In the After Update event of my combo, i update the text box with the...

Also "1" or "2" throws me the same error.